不需改“my.ini”文件
mysql-connector-java-3.1.4-beta-bin(驱动程序)
Class.forName("org.gjt.mm.mysql.Driver").newInstance();
String url ="jdbc:mysql://127.0.0.1/chengxin?user=userName&password=passWord&useUnicode=true&characterEncoding=iso-8859-1"; 1.写入时直接用 request.getParameter("parName");
2.读出时用
pstrWord = rs.getString("parName");
pstrWord = new String(pstrWord.getBytes("ISO8859_1"), "GBK");
mysql-connector-java-3.1.4-beta-bin(驱动程序)
Class.forName("org.gjt.mm.mysql.Driver").newInstance();
String url ="jdbc:mysql://127.0.0.1/chengxin?user=userName&password=passWord&useUnicode=true&characterEncoding=iso-8859-1"; 1.写入时直接用 request.getParameter("parName");
2.读出时用
pstrWord = rs.getString("parName");
pstrWord = new String(pstrWord.getBytes("ISO8859_1"), "GBK");
public Connection getConnection(){
try{
Class.forName("org.gjt.mm.mysql.Driver");
con=
DriverManager.getConnection(url+"?"+"user="+user+"&password="+pws+"&useUnicode=true&characterEncoding=gb2312");
}
catch(Exception e){
}
return con;
}
public static void main(String[] args){
ConnectionMySQL c=new ConnectionMySQL();
Connection conn2=c.getConnection();
try {
// String sql=;
Statement stmt = conn2.createStatement();
stmt.execute("INSERT into certificate (certificate_type)VALUES ('¿Õf´ð¸´´ófff´óʦ¸µÈöf')");
}
catch (SQLException ce) {
System.err.println(ce.getMessage());
}
System.out.println("ok");
}
}
pstrWord = new String(pstrWord.getBytes("GBK"), "ISO8859_1");
stmt.execute("INSERT into certificate (certificate_type) VALUES (pstrWord)")这样再试试!