SWINGTWO

 /*
     * 根据用户名找密码
     * 参数1：用户名
     * 返回值：该用户名对应的密码
     * */
    public String findPwd(String userName)
    {
     String pwd=null;
     String sql="select pasword from t_user where username =?";
     Connection conn=null;
     PreparedStatement ps = null;
     ResultSet rs =null;
     try
     {  
      conn=db.getConn();
      ps =conn.prepareStatement(sql);
   ps.setString(1, userName);
   rs=ps.executeQuery();
   while(rs.next())
   {
    pwd=rs.getString(1);
   }
  }
     catch (SQLException e)
     {
   e.printStackTrace();
  }
     finally
     {
   try
   {
    rs.close();
    ps.close();
    conn.close();
   }
   catch (SQLException e)
   {
    e.printStackTrace();
   }
  }
     return pwd;
    }
}

package dao;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import java.sql.ResultSet;
import util.DBUtil;
public class StaffMes
{
 DBUtil db = new DBUtil();
 Connection conn =null;
 String sqlcount1 = "SELECT COUNT(*) FROM t_staff WHERE RID = ? and d_del = 0";
 String sqlcount2 = "select count(*) from t_staff,t_dep,t_relation where t_relation.did=" +
   "t_dep.did and t_staff.rid=t_relation.rid and t_dep.did=? and t_staff.d_del = 0"; 
 /*
  * 得到结果集的记录条数
  * 参数1：获得记录条数的sql语句
  * 参数2：部门或小组的id
  * 返回值：记录条数
  * */
 public int getrsRow(String sqlcount,int id)
 {
  int count = 0;
  PreparedStatement ps = null;
  ResultSet rSet = null;
  conn = db.getConn();
  
  try
  {
   conn=db.getConn();
      ps = conn.prepareStatement(sqlcount);
      ps.setInt(1, id);
   rSet = ps.executeQuery();
   while(rSet.next())
   {
    count = rSet.getInt(1);
   }
  }
  catch (SQLException e)
  {
   e.printStackTrace();
  }
  
  return count;
 }
 
 
 
 public int getRow()
 {   
  String sql = "SELECT COUNT(*) FROM t_staff";
  int count = 0;
  PreparedStatement ps = null;
  ResultSet rSet = null;
  conn = db.getConn();
  
  try
  {
   conn=db.getConn();
   ps = conn.prepareStatement(sql);
   rSet = ps.executeQuery();
   while(rSet.next())
   {
    count = rSet.getInt(1);
   }
  }
  catch (SQLException e)
  {
   e.printStackTrace();
  }
  
  return count;
 }

    /*
     * 按小组搜员工
     * 参数1：小组id
     * 返回值：二维数组：该小组的所有员工信息
     * */
 public String[][] getLeadResult(int id)
 {
  String sql = "SELECT * FROM t_staff WHERE RID = ? and d_del = 0 ";
  PreparedStatement ps =null;
  ResultSet rSet = null;
  String[][] strDouble = null;
  conn = db.getConn();
  try
  {
   ps = conn.prepareStatement(sql);
   ps.setInt(1, id);
   rSet = ps.executeQuery();
   strDouble = new String[getrsRow(sqlcount1,id)][5];
   int i = 0;
   while(rSet.next())
   {
    strDouble[i][0] = rSet.getString(1);
    strDouble[i][1] = rSet.getString(2);
    strDouble[i][2] = rSet.getString(3);
    strDouble[i][3] = rSet.getString(5);
    strDouble[i][4] = rSet.getString(6);
    i++;
   }
   
  }
  catch (SQLException e)
  {
   e.printStackTrace();
  }
  finally
  {
   try
   {
    rSet.close();
    ps.close();
    conn.close();
   }
   catch (SQLException e)
   {
    e.printStackTrace();
   }
  }
  
  return strDouble;
 }
 
 /*
  * 按部门搜
  * 参数1：部门id
     * 返回值：二维数组：该部门的所有员工信息
  * */
 public String[][] getDepartResult(int id)
 {
    String sql = "select * from t_staff,t_dep,t_relation where t_relation.did = t_dep.did and t_staff.rid = t_relation.rid and t_dep.did = ? and t_staff.d_del = 0";
    PreparedStatement ps =null;
    ResultSet rSet = null;
    String[][] strDouble = null;
    conn = db.getConn();
  try
  {
   strDouble = new String[getrsRow(sqlcount2,id)][5];
   ps = conn.prepareStatement(sql);
   ps.setInt(1, id);
   rSet = ps.executeQuery();
   int i = 0;
   while(rSet.next())
   {
    strDouble[i][0] = rSet.getString(1);
    strDouble[i][1] = rSet.getString(2);
    strDouble[i][2] = rSet.getString(3);
    strDouble[i][3] = rSet.getString(5);
    strDouble[i][4] = rSet.getString(6);
    i++;
   }
   
  }
  catch (SQLException e)
  {
   e.printStackTrace();
  }
  finally
  {
   try
   {
    rSet.close();
    ps.close();
    conn.close();
   }
   catch (SQLException e)
   {
    e.printStackTrace();
   }
  }
  
  return strDouble;
 }
 
 /*
  * 增加员工
  * 参数1：一维数组：员工的所有信息
  * */
 public void addStaff(String[] str)
 {
  PreparedStatement prep = null;
  conn = db.getConn();
  String sql="insert into t_staff values(?,?,?,?,?,?,?)";
  try
  {
   prep=conn.prepareStatement(sql);
   prep.setString(1,str[0]);
   prep.setString(2, str[1]);
   prep.setString(3, str[2]);
   prep.setString(4,str[3]);
   prep.setString(5, str[4]);
   prep.setString(6, str[5]);
   prep.setString(7,str[6]);
   prep.executeUpdate();
  }
  catch (SQLException e)
  {
   e.printStackTrace();
  }
  finally
  {
   try
   {
    prep.close();
    conn.close();
   }
   catch (SQLException e)
   {
    e.printStackTrace();
   }
  }
 }