管理员添加用户 + 查看所有用户信息

一、最终实现样式

1、输入信息后点击“添加用户” → 可将信息加入数据库中

2、点击“查看已注册的用户” → 跳转到Admin_user_show.jsp界面，即可查看所有用户的信息：包括刚添加的用户信息（但还未解决乱码问题）

3、点击“返回添加用户” → 即可回到开始的添加用户信息界面

二、代码展示

userDao.java

//管理员Admin_user界面显示全部用户信息
public List<user> selectAllUser();
//管理员在Admin_user.jsp界面添加用户 + 注册：查询用户名是否重复
public user getUserByUsername(String user_name);

userDaoImpl.java

//管理员Admin_user界面显示全部用户信息
public List<user> selectAllUser() {
   
   List<user> show_user = new ArrayList<user>();
   try {
   
        Connection con = connectionUtils.getCon();
   	String sql = "select user_id,user_name,user_password,user_num,user_phone,user_sex,user_school,user_identify,user_intro from user";
  	PreparedStatement ps = con.prepareStatement(sql);
   	ResultSet rs = ps.executeQuery();
   	while(rs.next()) {
   
   	    user user = new user();
    	    user.setUser_id(rs.getInt("user_id"));
   	    user.setUser_name(rs.getString("user_name"));        
   	    user.setUser_password(rs.getString("user_password"));
            user.setUser_num(rs.getString("user_num"));
            user.setUser_phone(rs.getString("user_phone"));
    	    user.setUser_sex(rs.getString("user_sex"));
    	    user.setUser_school(rs.getString("user_school"));
    	    user.setUser_identify(rs.getString("user_identify"));
    	    user.setUser_intro(rs.getString("user_intro"));
    	    show_user.add(user);
       }
       return show_user;
   } catch (Exception e) {
   
       e.printStackTrace();
   } finally {
   
       try {
   
           connectionUtils.closeCon();
       } catch (Exception e) {
   
           e.printStackTrace();
       }
   }
   return null;
}
//管理员在Admin_user.jsp界面添加用户 + 注册：查询用户名是否重复（里面内容几乎一样，删除其中的password）
@Override
public user getUserByUsername(String user_name) {
   
   user u = null;
   //JDBC步骤：获取连接、编写SQL、预编译SQL、设置占位符参数、执行SQL、封装结果、关闭连接
   //选中后右键surround with再选try/catch block
//1.获取连接：首先，添加驱动包mysql-connector-java-5.1.48-bin.jar,会自动build path
   try {
   
   /*
    * Class.forName("com.mysql.jdbc.Driver"); String
    * url="jdbc:mysql://localhost:3306/syj"; String sql_user="root"; String
    * sql_pwd="syjsql"; Connection con =
    * DriverManager.getConnection(url,sql_user,sql_pwd);
    */  
       Connection con = connectionUtils.getCon();
       String sql = "select user_id,user_name,user_password from user where user_name = ?";
       PreparedStatement ps = con.prepareStatement(sql);
       ps.setString(1,user_name);
       ResultSet rs = ps.executeQuery();
       if(rs.next()) {
   
    	  u = new user();
   	  u.setUser_id(rs.getInt("user_id"));
   	  u.setUser_name(rs.getString("user_name"));
    	  u.setUser_password(rs.getString("user_password"));
       }
       return u;
   } catch (Exception e) {
   
       e.printStackTrace();
   } finally {
   
       try