连接mysql时出错

[ccdxjjxy]

有这个连接时没有问题
conn=DriverManager.getConnection("jdbc:mysql://localhost/student?user=root&password=8780&useUnicode=true&characterEncoding=ISO-8859-1");
换成这个就不行了
conn=DriverManager.getConnection("jdbc:mysql://localhost/student?user=root&password=8780&useUnicode=true&characterEncoding=gb2312");

[lrk817]

你这是笨办法，去找点好的方法去！

[ccdxjjxy]

有什么好的方法，还有这个问题怎么解决

[allright_flash]

characterEncoding=gb2312

应该是character set=gb2312吧

[pronumen]

String url="jdbc:mysql://localhost/wip?useUnicode=true&characterEncoding=gb2312"
conn=DriverManager.getConnection(url,"user","password");


這樣看看

[bjkamui]

苯方法很好用啊!这是个连接数据库的类

import com.mysql.jdbc.Driver;
import java.sql.*;

public class MySqlConnectionBean {
Connection con=null;
private static MySqlConnectionBean me=new MySqlConnectionBean();
public MySqlConnectionBean() {
}
public static MySqlConnectionBean newIn(){
return me;
}

public Connection GetConnection() {
try{
String dbName="数据库名";
String userName="root";
String userPasswd="密码";
String url="jdbc:mysql://localhost/"+dbName+"?user="+userName+"&password="+userPasswd+"&useUnicode=true&characterEncoding=GBK";
Class.forName("com.mysql.jdbc.Driver").newInstance();
con=(Connection) DriverManager.getConnection(url);
System.out.println("-----------数据库连接成功!------------");
}catch(Exception ex){
ex.printStackTrace();
}
return con;
}
}

[行近远山]

mysql安装时有一项字体选择
重新配置一下config试试，把字体改成gbk2312

[xuwei1985]

mysql的JDBC连接方法(导入mysql-connector-java-3.0.15-ga-bin.jar)

String url = "jdbc:mysql://localhost/test";
Class.forName("org.gjt.mm.mysql.Driver");
cn = java.sql.DriverManager.getConnection(url, "root","");