我装了mysql用java连数据库,却发现只能执行查询操作,不能执行数据修改操作。publicstaticvoidmain(String[]args)throwsClassNotFoundException,SQLException{Class.forName("com.my...
我装了mysql用java连数据库,却发现只能执行查询操作,不能执行数据修改操作。
public static void main(String[] args) throws ClassNotFoundException, SQLException{
Class.forName("com.mysql.jdbc.Driver");
System.out.println("loaded");
Connection connection = DriverManager.getConnection("jdbc:mysql://localhost/test");
System.out.println("Database");
Statement statement = connection.createStatement();
ResultSet resultset = statement.executeQuery("update pet set birth='1989-9-9' where name='Whister'");
System.out.print("success");
}
返回结果是:
loaded
Database
Exception in thread "main" java.sql.SQLException: Can not issue data manipulation statements with executeQuery().
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:987)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:982)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:927)
at com.mysql.jdbc.StatementImpl.checkForDml(StatementImpl.java:434)
at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1390)
at Algorithm.testFile.main(testFile.java:22)
如果是查询操作:
ResultSet resultset = statement.executeQuery("Select *from pet where sex='f'");
则执行成功返回
loaded
Database
success
不知道为什么
展开