studentdao.java

学生信息管理的Java系统运用JSp技术实现

package studentInfo;

/* 模型组件 */

import java.sql.*;
import java.util.*;
import java.util.ArrayList;

public class StudentDAO {
  public StudentDAO() {
  }

  Connection conn;
  PreparedStatement ps;
  ResultSet rs;

 //保存数据
  public boolean saveData(ArrayList arr)
  {
    //从数据访问组件dbPool中取得连接
    conn = DBPool.getConnection();

    String studNo = (String)arr.get(0);
    String name = (String)arr.get(1);
    String sex = (String)arr.get(2);
    String age = (String)arr.get(3);

    try {
      String sql = "insert into t_student values(?,?,?,?)";
      ps = conn.prepareStatement(sql);
      ps.setString(1,studNo);
      ps.setString(2,name);
      ps.setString(3,sex);
      ps.setString(4,age);

      ps.executeUpdate();

        return true;

    } catch (SQLException e) {return false;}
  }

}