java修改mysql数据出错_java mysql 增删改查运行时错误

/**向数据库xscj中的xs表中添加记录，修改记录，删除记录。*/importjava.sql.*;publicclassTestDML{publicstaticvoidmain(String[]args){ResultSetrs=null;Statementstmt=null;Connec...

/**

向数据库xscj中的xs表中添加记录，修改记录，删除记录。

*/

import java.sql.*;

public class TestDML{

public static void main(String[] args){

ResultSet rs = null;

Statement stmt = null;

Connection conn = null;

try{

//加载并注册mysql的JDBC驱动

Class.forName("com.mysql.jdbc.Driver");

//建立到mysql数据库的连接

conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/xscj","root","huanxingli");

//访问数据库，执行SQL语句

stmt = conn.createStatement();

//添加记录

System.out.println("添加记录后：");

String sql1 = "insert into xs values(100003,'zhangyan','computer')";

stmt.executeUpdate(sql1);

rs = stmt.executeQuery("select * from xs");

while(rs.next()){

System.out.println(rs.getInt("id"));

System.out.println(rs.getString("name"));

System.out.println(rs.getString("profession"));

}

//修改记录

System.out.println("修改记录后：");

String sql2 = "update xs set name = 'wangtao' where id = 100002";

stmt.executeUpdate(sql2);

rs = stmt.executeQuery("select * from xs");

while(rs.next()){

System.out.println(rs.getInt("id"));

System.out.println(rs.getString("name"));

System.out.println(rs.getString("profession"));

}

}catch(ClassNotFoundException e){

e.printStackTrace();

}catch(SQLException e){

e.printStackTrace();

}finally{

try{

if(rs!=null){

rs.close(); //关闭ResultSet对象

rs=null;

}

if(stmt!=null){

stmt.close();

stmt=null; //关闭Statement对象

}

if(conn!=null){

conn.close(); //关闭Connection对象

conn=null;

}

}catch(SQLException e){

e.printStackTrace();

}

}

}

}

E:\JavaPractice>java TestDML

添加记录后：

java.sql.SQLException: Column count doesn't match value count at row 1

at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1075)

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3566)

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3498)

at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1959)

at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2113)

at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2562)

at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1664)

at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1583)

at TestDML.main(TestDML.java:44)

展开