程序如下:
程序如下:
Class.forName("com.mysql.jdbc.Driver");
String url="jdbc:mysql://localhost:8080/jjm_geho?user=root&password=12345678&characterEncoding=GBK";
Connection cons= DriverManager.getConnection(url);
Statement stmta = cons.createStatement();
String mjb1 = "123";
String mjb2 = "测试";
String kas9 = "insert into jkas(as1,as2) values('"+mjb1+"','"+mjb2+"')";
stmta.executeUpdate(kas9);
//以上cons连接做数据查询是正常的,就是不能插入。
//查询是正常的如下:
Statement stmt=cons.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
String jsyi02="select * from jkas ";
ResultSet rst02=stmt.executeQuery(jsyi02);
rst02.first();
while(rst.next())
{
out.println(rst02.getString("as1")+":"+rst02.getString("as2")+"
");
}
%>
请各位高手指点,让我能添加数据成功,另外还有加分。mysql字符是GBK。
展开