preparedstatementdeletedemo.java

Eclipse程序设计经典教程+源代码 学习java的朋友可以看看

package preparedstatement;

import java.sql.*;

public class PreparedStatementDeleteDemo {
  public PreparedStatementDeleteDemo() {
    //定义数据库连接的驱动程序
    String driver = "org.gjt.mm.mysql.Driver";
    //定义MySQL数据库的连接地址
    String url = "jdbc:mysql://localhost:3306/EmployeeEBKC10";
    //声明连接类
    Connection conn = null;
    //employee数据表的删除SQL语句
    String deleteSql = "delete from employeeTable where employeeId = ?";
    //employee数据表的选择SQL语句
    String selectSql = "select count(*) from employeeTable";
    try {
      //使用JDBC技术创建数据库连接
      Class.forName(driver);
      //使用DriverManager类的getConnection()方法建立连接
      conn = DriverManager.getConnection(url, "root", "test");
      Statement stmt = conn.createStatement();
      //取得删除前的记录总数
      ResultSet rs = stmt.executeQuery(selectSql);
      if(rs.next()){
        System.out.println("删除前的记录总数 = " + rs.getInt(1));
      }
      //通过PreparedStatement删除记录
      PreparedStatement pstmt = conn.prepareStatement(deleteSql);
      //设置参数
      pstmt.setString(1, "2007010030");
      int result = pstmt.executeUpdate();
      if(result > 0){
        System.out.println("2007010030记录删除成功.");
      }
      //取得删除后的记录总数
      rs = pstmt.executeQuery(selectSql);
      if(rs.next()){
        System.out.println("删除后的记录总数 = " + rs.getInt(1));
      }
    }catch(Exception e){
      e.printStackTrace();
    }
  }
  public static void main(String[] args) {
    new PreparedStatementDeleteDemo();
  }
}