qq_41708767的博客

package cn.edu.hbue.ghp; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.SQLException; public class tainjia { public static void main(String[] args) { // TODO Auto-generated method stub java.sql.Connection connection = null; PreparedStatement preStmt = null; try{ Class.forName("com.mysql.jdbc.Driver"); String url = "jdbc:mysql://localhost:3306/grade?user=root&"+"password=ghp"; connection = DriverManager.getConnection(url); if(connection != null){ System.out.println("连接成功"); } String sql = "insert into book(author,publisher,isbn,pubDate,price,categoryId)"+"values(?,?,?,?,?,?)"; preStmt = connection.prepareStatement(sql); preStmt.setString(1, "EDA技术"); preStmt.setString(2, "清华大学"); preStmt.setString(3, "1"); preStmt.setString(4, "2017-1-1"); preStmt.setDouble(5, 66); preStmt.setInt(6, 2); preStmt.executeUpdate(); preStmt.setString(1, "你要去相信，没有到不了的明天"); preStmt.setString(2, "湖南出版时"); preStmt.setString(3, "2"); preStmt.setString(4, "2014-11-13"); preStmt.setDouble(5, 32.8); preStmt.setInt(6, 1); preStmt.executeUpdate(); System.out.println("添加数据的行为数为"+preStmt.getUpdateCount()); }catch(ClassNotFoundException e){ System.out.println("JDBC driver error"); }catch(SQLException e){ System.out.println("JDBC operation error"); }finally{ try{ if(preStmt != null){ preStmt.close(); } }catch(SQLException e){ System.out.println("PreparedStatement close error"); } try{ if( connection != null){ connection.close(); } }catch(SQLException e){ System.out.println("PreparedStatement close error"); } } } }