具体代码是:
public void writetDateTomysql(int i,int m)
{ try
{
Connection conn;
Statement stmt;
ResultSet res;
Class.forName("com.mysql.jdbc.Driver").newInstance();
conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/test",
"root", "12345");
String sql="insert into friendship values(?,?)";
PreparedStatement pstmt = conn.prepareStatement(sql);
pstmt.setInt(1,i);
pstmt.setInt(2, m);
pstmt.executeQuery();
}
catch (Exception ex)
{
System.out.println("Error : " + ex.toString());
}
}
发生的异常:
Error : java.sql.SQLException: Can not issue data manipulation statements with executeQuery().
无法向数据库插入数据,郁闷!
谁能告诉我程序哪里错了??
谢谢
public void writetDateTomysql(int i,int m)
{ try
{
Connection conn;
Statement stmt;
ResultSet res;
Class.forName("com.mysql.jdbc.Driver").newInstance();
conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/test",
"root", "12345");
String sql="insert into friendship values(?,?)";
PreparedStatement pstmt = conn.prepareStatement(sql);
pstmt.setInt(1,i);
pstmt.setInt(2, m);
pstmt.executeQuery();
}
catch (Exception ex)
{
System.out.println("Error : " + ex.toString());
}
}
发生的异常:
Error : java.sql.SQLException: Can not issue data manipulation statements with executeQuery().
无法向数据库插入数据,郁闷!
谁能告诉我程序哪里错了??
谢谢
而不是executeQuery().
来看看吧 希望有所帮助