连接mysql时出错

Question

有这个连接时没有问题
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");

Answer 1

characterEncoding=gb2312应该是character set=gb2312吧

Answer 2

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

Answer 3

苯方法很好用啊!这是个连接数据库的类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;
    }
}

Answer 4

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

Answer 5

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","");