快捷導(dǎo)航

Java使用PreparedStatement接口及ResultSet結(jié)果集的方法示例

更新時(shí)間：2018年07月07日 11:28:07 作者：Young-xy

這篇文章主要介紹了Java使用PreparedStatement接口及ResultSet結(jié)果集的方法,結(jié)合實(shí)例形式分析了PreparedStatement接口及ResultSet結(jié)果集的相關(guān)使用方法與操作注意事項(xiàng),需要的朋友可以參考下

本文實(shí)例講述了Java使用PreparedStatement接口及ResultSet結(jié)果集的方法。分享給大家供大家參考，具體如下：

說明：

1.PreparedStatement接口繼承Statement,它的實(shí)例包含已編譯的SQL語句，執(zhí)行速度要快于Statement。

2.PreparedStatement繼承了Statement的所有功能，三種方法executeUpdate、executeQuery、execute不再需要參數(shù)。

3.在JDBC應(yīng)用中，一般都用PreparedStatement，而不是Statement。

便于操作，先做一些封裝：

對(duì)連接數(shù)據(jù)庫，關(guān)閉連接封裝，在之前博客中已經(jīng)提到DbUtil.java;

對(duì)數(shù)據(jù)庫表進(jìn)行封裝，這里是對(duì)我的數(shù)據(jù)庫中comp表進(jìn)行操作，因此封裝如下：

package com.mysqltest.jdbc.modelComp;
public class CompMember {
  private int id;
  private String name;
  private int age;
  private double salary;
  /**
   * 構(gòu)造函數(shù)1
   * @param name
   * @param age
   * @param salary
   */
  public CompMember(String name, int age, double salary) {
    super();
    this.name = name;
    this.age = age;
    this.salary = salary;
  }
  /**
   * 重載構(gòu)造函數(shù)
   * @param id
   * @param name
   * @param age
   * @param salary
   */
  public CompMember(int id, String name, int age, double salary) {
    super();
    this.id = id;
    this.name = name;
    this.age = age;
    this.salary = salary;
  }
  /**
   * get,set方法
   */
  public int getId() {
    return id;
  }
  public void setId(int id) {
    this.id = id;
  }
  public String getName() {
    return name;
  }
  public void setName(String name) {
    this.name = name;
  }
  public int getAge() {
    return age;
  }
  public void setAge(int age) {
    this.age = age;
  }
  public double getSalary() {
    return salary;
  }
  public void setSalary(double salary) {
    this.salary = salary;
  }
  @Override
  /**
   * 改寫toString,使得顯示更好
   */
  public String toString() {
    return "["+this.id+"]"+this.name+","+this.age+","+this.salary;
  }
}

然后利用PreparedStatement接口實(shí)現(xiàn)增的操作：

package com.mysqltest.jdbc.xiao1;
import java.sql.Connection;
import java.sql.PreparedStatement;
import com.mysqltest.jdbc.modelComp.CompMember;
import com.mysqltest.jdbc.util.DbUtil;
public class PstatementTest {
  private static DbUtil dbUtil = new DbUtil();
  /**
   * 用PreparedStatement添加成員
   * @param mem
   * @return
   * @throws Exception
   */
  private static int addMember(CompMember mem) throws Exception{
    Connection con = dbUtil.getCon();
    String sql = "insert into comp values(null,?,?,?)";
    PreparedStatement pstmt = con.prepareStatement(sql);
    pstmt.setString(1, mem.getName());
    pstmt.setInt(2, mem.getAge());
    pstmt.setDouble(3, mem.getSalary());
    int result = pstmt.executeUpdate();//中間不用傳入sql
    dbUtil.close(pstmt, con); //preparedStatement是子類，用父類關(guān)閉也行
    return result;
  }
  public static void main(String[] args) throws Exception {
    CompMember mem = new CompMember("劉翔", 24, 8000.00);
    int result = addMember(mem);
    if (result==1) {
      System.out.println("添加成功");
    } else {
      System.out.println("添加失敗");
    }
  }
}

再利用PreparedStatement接口實(shí)現(xiàn)查詢，并運(yùn)用ResultSet結(jié)果集：

package com.mysqltest.jdbc.xiao2;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.ArrayList;
import java.util.List;
import com.mysqltest.jdbc.modelComp.CompMember;
import com.mysqltest.jdbc.util.DbUtil;
public class ResultsetTest {
  private static DbUtil dbUtil = new DbUtil();
  /**
   * 遍歷查詢結(jié)果
   * @throws Exception
   */
  @SuppressWarnings("unused")
  private static void listMem1() throws Exception {
    Connection con = dbUtil.getCon();// 獲取連接
    String sql = "select * from comp";
    PreparedStatement pstmt = con.prepareStatement(sql);
    ResultSet rs = pstmt.executeQuery();// 返回結(jié)果集
    // next()將光標(biāo)向后一行
    while (rs.next()) {
      int id = rs.getInt(1);// 獲取第一列的值id
      String name = rs.getString(2);//
      int age = rs.getInt(3);
      double salary = rs.getDouble(4);
      System.out.println("編號(hào)：" + id + "姓名：" + name + "年齡：" + age + "工資：" + salary);
      System.out.println("+====================================+");
    }
  }
  /**
   * 遍歷查詢結(jié)果方法2
   * @throws Exception
   */
  @SuppressWarnings("unused")
  private static void listMem2() throws Exception {
    Connection con = dbUtil.getCon();// 獲取連接
    String sql = "select * from comp";
    PreparedStatement pstmt = con.prepareStatement(sql);
    ResultSet rs = pstmt.executeQuery();// 返回結(jié)果集
    // next()將光標(biāo)向后一行
    while (rs.next()) {
      int id = rs.getInt("id");// 獲取第一列的值id
      String name = rs.getString("name");//
      int age = rs.getInt("age");
      double salary = rs.getDouble("salary");
      System.out.println("編號(hào)：" + id + "姓名：" + name + "年齡：" + age + "工資：" + salary);
      System.out.println("+====================================+");
    }
  }
  private static List<CompMember> listMem3() throws Exception{
    List<CompMember> memList = new ArrayList<CompMember>();
    Connection con = dbUtil.getCon();// 獲取連接
    String sql = "select * from comp";
    PreparedStatement pstmt = con.prepareStatement(sql);
    ResultSet rs = pstmt.executeQuery();// 返回結(jié)果集
    // next()將光標(biāo)向后一行
    while (rs.next()) {
      int id = rs.getInt("id");// 獲取第一列的值id
      String name = rs.getString("name");//
      int age = rs.getInt("age");
      double salary = rs.getDouble("salary");
      CompMember mem = new CompMember(id, name, age, salary);
      memList.add(mem);//添加到List中
    }
    return memList;
  }
  public static void main(String[] args) throws Exception {
//    listMem1();
//    listMem2();
    List<CompMember> memList = listMem3();
    for (CompMember mem : memList) { //遍歷集合的每個(gè)元素
      System.out.println(mem);
    }
  }
}

更多關(guān)于java相關(guān)內(nèi)容感興趣的讀者可查看本站專題：《Java+MySQL數(shù)據(jù)庫程序設(shè)計(jì)總結(jié)》、《Java數(shù)據(jù)結(jié)構(gòu)與算法教程》、《Java文件與目錄操作技巧匯總》、《Java操作DOM節(jié)點(diǎn)技巧總結(jié)》和《Java緩存操作技巧匯總》

希望本文所述對(duì)大家java程序設(shè)計(jì)有所幫助。

您可能感興趣的文章: