昨天还能连上,今天不知道出了什么问题,报错了,
java.lang.Exception: 操作数据库出错!!
at com.sun.cn.DataBaseConnection.<init>(DataBaseConnection.java:19)
at com.sun.cn.userDAOImpl.login(userDAOImpl.java:10)
at com.sun.cn.loginServlet.doPost(loginServlet.java:24)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:237)
下面是连接数据库的bean;
package com.sun.cn;
import java.sql.*;
public class DataBaseConnection
{
private String DBDRIVER="com.mysql.jdbc.Driver";
private String DBURL="jdbc:mysql://localhost:3306/qxwtt";
private String DBUSER="root";
private String DBPASSWORD="123456";
Connection conn=null;
public DataBaseConnection() throws Exception
{
try
{
Class.forName(DBDRIVER);
this.conn=DriverManager.getConnection(DBURL,DBUSER,DBPASSWORD);
}
catch (Exception e)
{
throw new Exception("操作数据库出错!!");
}
}
public Connection getConnection()
{
return this.conn;
}
public void close()
{
try
{
if(conn!=null)
{
conn.close();
conn=null;
}
}
catch (Exception e)
{
e.printStackTrace();
}
}
}
java.lang.Exception: 操作数据库出错!!
at com.sun.cn.DataBaseConnection.<init>(DataBaseConnection.java:19)
at com.sun.cn.userDAOImpl.login(userDAOImpl.java:10)
at com.sun.cn.loginServlet.doPost(loginServlet.java:24)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:237)
下面是连接数据库的bean;
package com.sun.cn;
import java.sql.*;
public class DataBaseConnection
{
private String DBDRIVER="com.mysql.jdbc.Driver";
private String DBURL="jdbc:mysql://localhost:3306/qxwtt";
private String DBUSER="root";
private String DBPASSWORD="123456";
Connection conn=null;
public DataBaseConnection() throws Exception
{
try
{
Class.forName(DBDRIVER);
this.conn=DriverManager.getConnection(DBURL,DBUSER,DBPASSWORD);
}
catch (Exception e)
{
throw new Exception("操作数据库出错!!");
}
}
public Connection getConnection()
{
return this.conn;
}
public void close()
{
try
{
if(conn!=null)
{
conn.close();
conn=null;
}
}
catch (Exception e)
{
e.printStackTrace();
}
}
}
解决方案 »
- extremecomponents组件 页面在翻页后 不影响checkbox的选中状态
- js写的一个日历,属性的控制!
- struts2标签问题
- 高分求助,weblogic下载文件乱码
- 请教一个关于数据库海量数据处理的问题.
- 初学者的小问题~~~~~~~~~
- 总结:jsp(java) 访问html,javascript
- java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket
- 用过jspsmartupload的请进!!
- 插入数据库行删除不行哪位给解释一下
- 关于一个基于java的搜索引擎 好心人帮我看看
- 着急 高手看看 JS结合JvavaScriopt查询数据并且用表格显示出来
究竟是什么出错了。把e.printStackTrace();打出来再检查
this.conn=DriverManager.getConnection(DBURL,DBUSER,DBPASSWORD);估计是驱动程序找不到