JDBC中的executeQuery和executeUpdate

• executeQuery 更新查询信息

 // 1.加载驱动类
 Class.forName("com.mysql.jdbc.Driver");
 //2.定义数据库信息
 String url = "jdbc:mysql://localhost:3306/ceshi";
 String user = "root";
 String password = "root";
 //3.创建连接
 Connection conn = DriverManager.getConnection(url,user,password);
 //4.定义sql语句
 String sql = "select * from book where bookID=?";
 //5.创建语句连接
 PreparedStatement ps = conn.prepareStatement(sql);
 int bookID = 1;
 ps.setInt(1,bookID);//查找bookID为1的图书信息
 rs = ps.executeQuery();//执行executeQuery查询
 while(rs.next()){
   System.out.println(rs.getString("stock"));
}

• executeUpdate 更新数据操作 增删改

// 1.加载驱动类
 Class.forName("com.mysql.jdbc.Driver");
 //2.定义数据库信息
 String url = "jdbc:mysql://localhost:3306/ceshi";
 String user = "root";
 String password = "root";
 //3.创建连接
 Connection conn = DriverManager.getConnection(url,user,password);
 //4.定义sql语句
 String sql = "update book set bookname=? where bookID=?";
 //5.创建语句连接
 int bookID = 1;
 String name = "王武";
 ps = conn.prepareStatement(sql);
 ps.setString(1,name);//将bookID为1的信息中修改bookname为王武
 ps.setInt(2,bookID);
 ps.executeUpdate();