Esempio n. 1
0
  public List<User> findByName(String user_name) {
    String sql = "select user_id,user_type,user_name from user where user_name like ?";
    PooledConnection con;
    con = this.getConnection();
    PreparedStatement pst = con.getPrepareStatement(sql);

    List<User> list = new ArrayList<User>();

    try {
      pst.setString(1, "%" + user_name + "%");
      ResultSet res = pst.executeQuery();

      while (res.next()) {
        User u = new User();
        u.setUser_id(res.getString(1));
        u.setUser_type(res.getInt(2));
        u.setUser_name(res.getString(3));
        list.add(u);
      }

    } catch (SQLException e) {
      e.printStackTrace();
    } finally {
      con.close();
    }

    return list;
  }
Esempio n. 2
0
  public boolean updUser(User u) {
    String sql;

    if (u.getUser_psw().equals(""))
      sql = "update user set user_name=?,user_type=? where user_id = ?";
    else sql = "update user set user_name=?,user_psw=?,user_type=? where user_id = ?";

    PooledConnection con;
    con = this.getConnection();
    PreparedStatement pst = con.getPrepareStatement(sql);

    try {

      pst.setString(1, u.getUser_name());
      if (u.getUser_psw().equals("")) {
        pst.setInt(2, u.getUser_type());
        pst.setString(3, u.getUser_id());
      } else {
        pst.setString(2, u.getUser_psw());
        pst.setInt(3, u.getUser_type());
        pst.setString(4, u.getUser_id());
      }
      pst.executeUpdate();
    } catch (SQLException e) {
      e.printStackTrace();
      return false;
    } finally {
      con.close();
    }

    return true;
  }
Esempio n. 3
0
  public boolean check(User u) {
    String sql = "select *  from user where user_id=? and user_psw=?";
    PooledConnection con;
    con = this.getConnection();
    PreparedStatement pst = con.getPrepareStatement(sql);

    try {
      pst.setString(1, u.getUser_id());
      pst.setString(2, u.getUser_psw());
      ResultSet res = pst.executeQuery();
      return res.next();
    } catch (SQLException e) {
      // TODO Auto-generated catch block
      e.printStackTrace();
      return false;
    } finally {
      con.close();
    }
  }
Esempio n. 4
0
  public boolean save(User u) {
    String sql = "insert into user values(?,?,?,?)";
    PooledConnection con;
    con = this.getConnection();
    PreparedStatement pst = con.getPrepareStatement(sql);

    try {
      pst.setString(1, u.getUser_id());
      pst.setInt(2, u.getUser_type());
      pst.setString(3, u.getUser_psw());
      pst.setString(4, u.getUser_name());
      pst.executeUpdate();
    } catch (SQLException e) {
      // TODO Auto-generated catch block
      e.printStackTrace();
      return false;
    } finally {
      con.close();
    }

    return true;
  }
Esempio n. 5
0
  public boolean updPermission(String user_id, int type) {
    String sql = "update user set user_type = ? where user_id = ?";
    PooledConnection con;
    con = this.getConnection();
    PreparedStatement pst = con.getPrepareStatement(sql);

    List<User> list = new ArrayList<User>();

    try {
      pst.setInt(1, type);
      pst.setString(2, user_id);
      pst.executeUpdate();

    } catch (SQLException e) {
      e.printStackTrace();
      return false;
    } finally {
      con.close();
    }

    return true;
  }
Esempio n. 6
0
  public User loadById(String user_id) {
    String sql = "select *  from user where user_id=?";
    PooledConnection con;
    con = this.getConnection();
    PreparedStatement pst = con.getPrepareStatement(sql);

    try {
      pst.setString(1, user_id);
      ResultSet res = pst.executeQuery();
      if (!res.next()) return null;
      User u = new User();
      u.setUser_id(user_id);
      u.setUser_type(res.getInt(2));
      u.setUser_name(res.getString(4));
      return u;
    } catch (SQLException e) {
      e.printStackTrace();
    } finally {
      con.close();
    }

    return null;
  }