批处理插入数据

import java.sql.*;
public class preparedStatementTest {
 public static void main(String[] args) {
  Connection con = null;
  ResultSet rs = null;
  PreparedStatement ps = null;
  try {
   SqlConnectionHelp.driver();
   con = SqlConnectionHelp.getConnection();
   if (con == null)
    return;
   String sql = "insert into member values(?,?,?,?,?)";
   ps = con.prepareStatement(sql);
   ps.setInt(1, 4);
   ps.setString(2, "xiao");
   ps.setString(3, "19870210");
   ps.setInt(4, 25);
   ps.setString(5, "7777777");
   ps.addBatch();
   
   ps.setInt(1, 5);
   ps.setString(2, "xiao");
   ps.setString(3, "19870210");
   ps.setInt(4, 25);
   ps.setString(5, "7777777");
   ps.addBatch();
   ps.executeBatch();
   //System.out.println("恭喜你，成功插入了" + count + "条记录!");
   //count = ps.executeUpdate("update member set age=age+1");
   //System.out.println("恭喜你，成功更新了" + count + "条记录!");
   SqlConnectionHelp.release(ps);
   String sqll = "select *from member";
   ps = con.prepareStatement(sqll);
   rs = ps.executeQuery();
   System.out.println("******************************");
   System.out.println("会员ID/t姓名/t密码/t年龄/tOICQ号");
   while (rs.next()) { //从结果集中获取每个列中的值
    int id = rs.getInt(1); //获取当前记录中第1列内容
    String userName = rs.getString(2);//获取当前记录中第2列内容
    String passWord = rs.getString(3);//获取当前记录中第3列内容
    int age = rs.getInt(4); //获取当前记录中第4列内容
    String oicq = rs.getString(5); //获取当前记录中第5列内容
    System.out.println(id + "/t" + userName + "/t" + passWord
      + "/t" + age + "/t" + oicq);

   }

  } catch (Exception e) {
   e.printStackTrace();
  } finally {
   SqlConnectionHelp.release(rs, ps, con);
  }
 }

}

 

import java.sql.*;
public class SqlConnectionHelp {
  public static void driver() {
  String s = "com.mysql.jdbc.Driver";
  try {
   Class.forName(s);
  } catch (Exception e) {
   e.printStackTrace();
  }
 }
 /***
  * 连接数据库的方法
  * @return 返回数据库连接的对象
  */
 public static Connection getConnection() {
  String url="jdbc:mysql://localhost:3306/jdbc";
  Connection con = null;
  String userName = "root";
  String passWord = "123456";
  try {
   con = DriverManager.getConnection(url, userName, passWord);

  } catch (Exception e) {
   e.printStackTrace();
  }
  return con;
 }
 /***
  * 释放数据库资源
  * @param rs 结果集对象
  * @param stmt 编译语句对象
  * @param con 数据库连接对象
  */
 //释放数据库资源
 public static void release(ResultSet rs, Statement stmt, Connection con) {
  try {
   if (rs != null)
    rs.close(); // 关闭结果集
  } catch (Exception ee) {
   ee.printStackTrace();
  }
  try {
   if (stmt != null)
    stmt.close();// 关闭编译语句
  } catch (Exception ee) {
   ee.printStackTrace();
  }
  try {
   if (con != null)
    con.close();// 关闭数据库连接
  } catch (Exception ee) {
   ee.printStackTrace();
  }
 }
 /***
  * 重载 releaser方法
  * @param o
  */
 public static void release(Object o){
  try{
   if(o instanceof ResultSet){
    ((ResultSet)(o)).close();
   }else if(o instanceof Statement){
    ((Statement)o).close();
   }else if(o instanceof Connection){
    ((Connection)o).close();
   }
  }catch(Exception e){
   e.printStackTrace();
  }
 }

}