我正在尝试使用jdbc将一些数据插入到我的数据库中。我正在使用正确的表,数据库名称和参数。一切检查完毕。
代码
public static void main(String[] args) throws IOException/*, ClassNotFoundException, SQLException*/ { DataInputStream d = new DataInputStream(System.in); System.out.println("Enter employee ID : "); @SuppressWarnings("deprecation") int empid = Integer.parseInt(d.readLine()); System.out.println("Enter employee name : "); @SuppressWarnings("deprecation") String empname = d.readLine(); System.out.println("Enter employee ID : "); @SuppressWarnings("deprecation") double empsalary = Double.parseDouble(d.readLine()); try { Class.forName("com.mysql.jdbc.Driver"); } catch (ClassNotFoundException e) { e.printStackTrace(); } Connection con; try { con = DriverManager.getConnection("jdbc:mysql://localhost:3306/testDB","root",""); PreparedStatement pst = con.prepareStatement("insert into `employee` values(?,?,?"); pst.setInt(1, empid); pst.setString(2, empname); pst.setDouble(3, empsalary); int rowcount = pst.executeUpdate(); System.out.println(rowcount + " row has been instered"); } catch (SQLException e) { e.printStackTrace(); }
这是当我尝试运行它时给我的错误:
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723) at com.mysql.jdbc.Connection.execSQL(Connection.java:3283) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1332) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1604) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1519) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1504) at com.test.jdbcExample.main(jdbcExample.java:47)
您在此行中有语法错误:
PreparedStatement pst = con.prepareStatement("insert into `employee` values(?,?,?");
您缺少values子句的右括号。