java.sql.SQLException:Can not issue data manipulation statements with executeQuery()，executequery

java.sql.SQLException:Can not issue data manipulation statements with executeQuery()，executequery

1、錯誤描述

java.sql.SQLException:Can not issue data manipulation statements with executeQuery()

2、錯誤原因

Class.forName("com.mysql.jdbc.Driver");Connection conn = null;Statement stat = null;ResultSet rs = null;try {conn = DriverManager.getConnection(url, username, password);stat = conn.createStatement();stat.executeQuery(sql);

}

Statement在調用查詢SQL方法時，調用executeQuery，導致出錯

3、解決辦法

     將“stat.executeQuery(sql);”換成“stat.execute(sql);”