数据库驱动问题 Class.forName("org.gjt.mm.mysql.Driver").newInstance(); String url ="jdbc:mysql://localhost/myDB?user=soft&password=soft1234&useUnicode=true&characterEncoding=8859_1" //myDB为数据库名 Connection conn= DriverManager.getConnection(url); 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 将包解压,找到*.jar文件,将这个文件加入到classpath中即可,然后按着上面老兄的方法就行了 String driverName = "org.gjt.mm.mysql.Driver"; String connURL = "jdbc:mysql://localhost/DBNAME?user=XXX&password=XXX&useUnicode=true&characterEncoding=8859_1"; try{ Class.forName(driverName); Connection conn = DriverManager.getConnection(connURL); Statement stmt = conn.createStatement(); StringBuffer strsql = new StringBuffer(); strsql.append("select * from USERTABLE where username ='" + username + "'"); ResultSet rs = stmt.executeQuery(strsql.toString()); if(!rs.next() ||!password.equals(NulltoString(rs.getString("password")).trim())){ DBmsg = "对不起,您所输入的用户不存在或用户密码不正确"; }else{ username = NulltoString(rs.getString("username")); selectright = NulltoString(rs.getString("selectright")); deleteright = NulltoString(rs.getString("deleteright")); updateright = NulltoString(rs.getString("updateright")); } }catch (ClassNotFoundException ex){ ex.printStackTrace(); }catch (SQLException ex){ ex.printStackTrace(); } 首先把你下的驱动解压, 然后把里面的jar文件放在j2sdk1.4.2\jre\lib\ext下。 对不同的工具可能有些差别的了,不过我同意tianwaifeixue001(华仔)的观点。 String driverName = "org.gjt.mm.mysql.Driver";String connURL = "jdbc:mysql://localhost/database_name?user=XXX&password=XXX&useUnicode=true&characterEncoding=8859_1"; 如何在javascript中调用java类并得到java类返回的值? 急!!!!!!!!!!!!Linux下部署DNS和sendmail的问题?????????? tomcat servlet 测试问题 求助:服务器热备份切换后数据库访问的问题 跪求 Spring Web Flow教程 有哪位有防止别人拷贝的JAVA的源程序吗,我急等用,分不够另加 事務處理問題,來者有分 在JSP页中嵌套进应用程序该怎么写 Java程序中读Oracle表数据是乱码 在线等!!! 如何增加关键字为自动增量的记录? 请问WebServices支持Session吗 中文URL的问题,谢谢了。
String connURL = "jdbc:mysql://localhost/DBNAME?user=XXX&password=XXX&useUnicode=true&characterEncoding=8859_1";
try{
Class.forName(driverName);
Connection conn = DriverManager.getConnection(connURL);
Statement stmt = conn.createStatement();
StringBuffer strsql = new StringBuffer();
strsql.append("select * from USERTABLE where username ='" + username + "'");
ResultSet rs = stmt.executeQuery(strsql.toString());
if(!rs.next() ||!password.equals(NulltoString(rs.getString("password")).trim())){
DBmsg = "对不起,您所输入的用户不存在或用户密码不正确";
}else{
username = NulltoString(rs.getString("username"));
selectright = NulltoString(rs.getString("selectright"));
deleteright = NulltoString(rs.getString("deleteright"));
updateright = NulltoString(rs.getString("updateright"));
} }catch (ClassNotFoundException ex){
ex.printStackTrace();
}catch (SQLException ex){
ex.printStackTrace();
}
String connURL = "jdbc:mysql://localhost/database_name?user=XXX&password=XXX&useUnicode=true&characterEncoding=8859_1";