userdao.java

来自「J2EE开源编程精要15讲 源代码 希望对大家学习有用」· Java 代码 · 共 103 行

package user;

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




public class UserDAO {

    public UserDAO() {
        try {
            jbInit();
        } catch (Exception ex) {
            ex.printStackTrace();
        }
    }

    private void jbInit() throws Exception {
    }

  static Connection dbConn,conn;
  static PreparedStatement ps;
  static ResultSet rs;
  static ArrayList arr;





//把用户数据查入数据表中
  public static boolean insert(ArrayList list) {
         boolean bo = false;


      try {

          conn = DBPool.getConnection();
          System.out.println("Location is after getConnection()!");
      ps = conn.prepareStatement("insert into t_user values(?,?)");
      ps.setString(1, (String)list.get(0));
      ps.setString(2, (String)list.get(1));


       ps.executeUpdate();
       System.out.println("Data has Inserted!");
       ps.close();
       conn.close();

       bo= true;

      } catch(Exception e) {
          bo = false;
          System.out.println(e);}
     // finally {
       //   try {
//              ps.close();
         //     conn.close();
         // }catch (SQLException e) {System.out.println(e);}
      //}
      return bo;
  }

  //登录验证
    public static ArrayList verify(String username, String password) {
        arr = new ArrayList();
        boolean bo = false;
      try {

          conn = DBPool.getConnection();

      ps = conn.prepareStatement("select * from t_user where username=?");
      ps.setString(1,username);

       rs=ps.executeQuery();
       if(rs.next()) {
           arr.add(rs.getString(1));
           arr.add(rs.getString(2));
           arr.add(rs.getString(3));

       }
       //System.out.println("Data has Inserted!");
       ps.close();
       conn.close();


      } catch(Exception e) {
          System.out.println(e);}
     // finally {
       //   try {
//              ps.close();
         //     conn.close();
         // }catch (SQLException e) {System.out.println(e);}
      //}


        return arr;
    }

}