UC知道java使用mysql出错，高手指教
来源：百度知道 编辑：UC知道 时间：2024/06/13 22:14:17
package jdbc;
import java.sql.*;
public class TestDML {
/**
* @param args
*/
public static void main(String[] args) {
// TODO Auto-generated method stub
try{
Class.forName("com.mysql.jdbc.Driver");
String url="jdbc:mysql://127.0.0.1:3306/test";
Connection conn=DriverManager.getConnection(url,"root","mysql");
Statement stmt=conn.createStatement();
stmt.executeUpdate("insert into stu values('j001','zhangsan',18)");
stmt.executeUpdate("insert into stu values('j002','李四',20)");
stmt.executeUpdate("insert into stu values('j003','wangwu',19)");
stmt.executeUpdate("insert into stu values('j004','zhaoliu',21)");
ResultSet rs=stmt.executeQuery("select * from stu order by sid");//用于执行SELECT语句
while(rs.
import java.sql.*;
public class TestDML {
/**
* @param args
*/
public static void main(String[] args) {
// TODO Auto-generated method stub
try{
Class.forName("com.mysql.jdbc.Driver");
String url="jdbc:mysql://127.0.0.1:3306/test";
Connection conn=DriverManager.getConnection(url,"root","mysql");
Statement stmt=conn.createStatement();
stmt.executeUpdate("insert into stu values('j001','zhangsan',18)");
stmt.executeUpdate("insert into stu values('j002','李四',20)");
stmt.executeUpdate("insert into stu values('j003','wangwu',19)");
stmt.executeUpdate("insert into stu values('j004','zhaoliu',21)");
ResultSet rs=stmt.executeQuery("select * from stu order by sid");//用于执行SELECT语句
while(rs.
将汉字先改成字母试一下再说啊
估计字符集的问题
mysql 支持中文不太好啊
连接字符串后面加上useUnicode=true&;characterEncoding=gbk 试试
是GBK吧。。呵呵。
说的好像是：列，name所添加的字符的问题。。
set character_set_client=utf8;
set character_set_connection=utf8;
set character_set_database=utf8;
set character_set_filesystem=binary;
set character_set_results=utf8;
set character_set_server=utf8;
set character_set_system=utf8;
SHOW VARIABLES LIKE 'character_set_%';
用这个试一下。。
如果你都设成GBK的话，上面的utf8改成gbk。
http://hi.baidu.com/yuanli_whu/blog/item/ec70cf22af8f5e4cac34de60.html
再看看这个。
希望你将SQL 改成这种模式
"insert into productname (name,number1,tprice,) values ('"&pname&"','"&number1&"','"&tprice&"')"