SQL的用法

Class.forName("com.mysql.jdbc.Driver");
con=DriverManager.getConnection("jdbc:mysql://localhost/test?useUnicode=true&characterEncoding=utf8","root","");

//上句不同之处似乎是为了汉字编码的问题加了  "?useUnicode=true&characterEncoding=utf8"

 

//插入是这么写的

 
PreparedStatement pt= con.prepareStatement("select count(*) from TBL_USER where uname=? and upass=?");
pt.setString(1, "小强");
pt.setString(2, "123");
ResultSet rt= pt.executeQuery();