JSP连接mysql的问题,找不到驱动 本帖最后由 Feryest 于 2013-04-23 00:15:22 编辑 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 1.public class DBHelper { 2. public static Connection getConnection() { 3. Connection conn = null; 4. try { 5. Class.forName("com.mysql.jdbc.Driver"); 6. conn = DriverManager.getConnection("jdbc:mysql://localhost/ad?useUnicode=true&characterEncoding=GBK&jdbcCompliantTruncation=false", 7. "root", "root"); 8. } catch (Exception e) { 9. e.printStackTrace(); 10. } 11. return conn; 12. } 13.} 14. 自己看看 Class.forName(driverName).newInstance(); 改为Class.forName(driverName); public class Db { private static String DB_DRIVER_CLASS = "com.mysql.jdbc.Driver"; private static String DB_PRO = "jdbc:mysql"; private static String DB_HOST = "localhost"; private static String DB_PORT = "3306"; private static String DB_NAME = "2009.5018"; private static String DB_USER = "5018"; private static String DB_PASSWORD = "5018"; private static String DB_URL = DB_PRO+"://"+DB_HOST+":"+DB_PORT+"/"+DB_NAME+ "?user="+DB_USER+"&password="+DB_PASSWORD+"&useUnicode=true&characterEncoding=utf-8"; static{ try { Class.forName(DB_DRIVER_CLASS).newInstance(); } catch (Exception e) { System.out.println("load class error!"); e.printStackTrace(); } } public static Connection getConnection(){ Connection conn = null; try { conn = DriverManager.getConnection(DB_URL); } catch (SQLException e) { System.out.println("get conn error!"); e.printStackTrace(); } return conn; } public static void colseConnection(Connection conn){ if(null != conn){ try { conn.close(); } catch (SQLException e) { e.printStackTrace(); } conn = null; } } public static void closeResultSet(ResultSet rs){ if(rs!=null){ try { rs.close(); } catch (SQLException e) { e.printStackTrace(); } rs = null; } } public static void closePreparedStatement(PreparedStatement pstm){ if(pstm != null){ try { pstm.close(); } catch (SQLException e) { e.printStackTrace(); } pstm = null; } } public static void closeStatement(Statement stm){ if(stm != null){ try { stm.close(); } catch (SQLException e) { e.printStackTrace(); } stm = null; } }} 其实刚开始我们也是这样写的,改过private static String DB_URL = DB_PRO+"://"+DB_HOST+":"+DB_PORT+"/"+DB_NAME+"?user="+DB_USER+"&password="+DB_PASSWORD+"&useUnicode=true&characterEncoding=utf-8";之后就对了 你意思是,和字段类型有关系?报错的是Class.forName(DB_DRIVER_CLASS).newInstance();这一步额,驱动相关的吧、、、 错误说的很明显了。java.lang.ClassNotFoundException: com.mysql.jdbc.Driver,没有找到com.mysql.jdbc.Driver这个类,你的驱动jar是从哪弄来的?你打开jar文件按照包路劲去找找看有没有Driver这个类。如果没有就是jar包不对,如果有那你就从新编译一下工程,从新部署。 eclipse不会把驱动自动加到tomcat中去,你的tomcat中lib文件夹中有驱动吗 这个我不是很记得了,eclipse解压以后选了workspace路径就可以用了。Tomcat需要另外安装吗?还是在Eclipse里面导入Tomcat插件什么的?所以我不知道Eclipse里面用到的Tomcat是哪个路径。 这个我不是很记得了,eclipse解压以后选了workspace路径就可以用了。Tomcat需要另外安装吗?还是在Eclipse里面导入Tomcat插件什么的?所以我不知道Eclipse里面用到的Tomcat是哪个路径。 ajax报错 log4j中怎样将异常的完整信息写入日志文件????? 用过 xheditor 的来!! 提交表单 有关JSP与数据库连接与输出方面的问题 求救,Struts自带例子程序一问! java常见异常 日语,韩语,阿拉伯语的编码分别是多少。 我该怎么办??? 为什么我的JAVABEAN在JB7(TOMCAT4)中可以正常调用,关掉JB7后单开TOMCAT4就不行了 地址栏上加%20,为什么项目会报500,求解释 java做b/c模式 是指的jsp做的网站吗?
2. public static Connection getConnection() {
3. Connection conn = null;
4. try {
5. Class.forName("com.mysql.jdbc.Driver");
6. conn = DriverManager.getConnection("jdbc:mysql://localhost/ad?useUnicode=true&characterEncoding=GBK&jdbcCompliantTruncation=false",
7. "root", "root");
8. } catch (Exception e) {
9. e.printStackTrace();
10. }
11. return conn;
12. }
13.}
14.
自己看看
Class.forName(driverName);
private static String DB_DRIVER_CLASS = "com.mysql.jdbc.Driver";
private static String DB_PRO = "jdbc:mysql";
private static String DB_HOST = "localhost";
private static String DB_PORT = "3306";
private static String DB_NAME = "2009.5018";
private static String DB_USER = "5018";
private static String DB_PASSWORD = "5018";
private static String DB_URL = DB_PRO+"://"+DB_HOST+":"+DB_PORT+"/"+DB_NAME+
"?user="+DB_USER+"&password="+DB_PASSWORD+"&useUnicode=true&characterEncoding=utf-8";
static{
try {
Class.forName(DB_DRIVER_CLASS).newInstance();
} catch (Exception e) {
System.out.println("load class error!");
e.printStackTrace();
}
}
public static Connection getConnection(){
Connection conn = null;
try {
conn = DriverManager.getConnection(DB_URL);
} catch (SQLException e) {
System.out.println("get conn error!");
e.printStackTrace();
}
return conn;
}
public static void colseConnection(Connection conn){
if(null != conn){
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
conn = null;
}
}
public static void closeResultSet(ResultSet rs){
if(rs!=null){
try {
rs.close();
} catch (SQLException e) {
e.printStackTrace();
}
rs = null;
}
}
public static void closePreparedStatement(PreparedStatement pstm){
if(pstm != null){
try {
pstm.close();
} catch (SQLException e) {
e.printStackTrace();
}
pstm = null;
}
}
public static void closeStatement(Statement stm){
if(stm != null){
try {
stm.close();
} catch (SQLException e) {
e.printStackTrace();
}
stm = null;
}
}}
"?user="+DB_USER+"&password="+DB_PASSWORD+"&useUnicode=true&characterEncoding=utf-8";之后就对了