dboperate.java~2~

java+sql2000企业人力管理系统

package managersystem.user;
import java.sql.*;
import java.util.*;
import managersystem.DBGet;
import managersystem.user.*;
//import manpowermanager.*;
/**
 * <p>Title: 企业人力资源管理系统</p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2008</p>
 *
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */
public class DBoperate {
  public DBoperate() {
  }
  public boolean getUserAndpwd(Users objU){
    boolean success = false;
    Connection con = null;
    PreparedStatement ptmt = null;
    ResultSet rs = null;
    String strSQL = "select * from Users where UserName = ? and Pwd = ?";
    try {
      DBGet objG = new DBGet();
      con =objG.getConnection();
      ptmt = con.prepareStatement(strSQL);
      ptmt.setString(1,objU.getUserName());
      ptmt.setString(2,objU.getPwd());
      rs = ptmt.executeQuery();
      if(rs.next()){
        success = true;
      }
      objG.clossConnection(con);
    }
    catch (Exception ex) {
      ex.printStackTrace();
    }
    return success;
  }

  public ArrayList ArrayName(){
    ArrayList arrayname = new ArrayList();
    Connection con = null;
    PreparedStatement ptmt = null;
    ResultSet rs = null;
    String strSQL = "select * from Users";
    try {
      DBGet objG = new DBGet();
      con = objG.getConnection();
      ptmt = con.prepareStatement(strSQL);
      rs = ptmt.executeQuery();
      while(rs.next()){
        arrayname.add(rs.getString(1));
      }
    }
    catch (Exception ex) {
      ex.printStackTrace();
    }
    return arrayname;
  }
}