栏目分类:
子分类:
返回
名师互学网用户登录
快速导航关闭
当前搜索
当前分类
子分类
实用工具
热门搜索
名师互学网 > IT > 软件开发 > 后端开发 > Java

WEB-小项目(增删改查)

Java 更新时间: 发布时间: IT归档 最新发布 模块sitemap 名妆网 法律咨询 聚返吧 英语巴士网 伯小乐 网商动力

WEB-小项目(增删改查)

数据库脚本:

CREATE TABLE `user`(
	userId INT(32) PRIMARY KEY AUTO_INCREMENT,
	userName VARCHAr(22) NOT NULL,
	userPwd VARCHAr(32) NOT NULL,
	userPhone VARCHAr(200) NOT NULL,
	userSex INT(10) NOT NULL,
	userEmail VARCHAr(100) NOT NULL,
	userBirthday DATE NOT NULL
)CHARSET=utf8;

INSERT INTO `user`(userName,userPwd,userPhone,userSex,userEmail,userBirthday)
VALUES
('tom','132.com','18539365895',0,'1262614414@qq.com','2003-02-02'),
('jim','465.com','12345678984',1,'2438385915@qq.com','2002-10-05'),
('jerry','789.com','96385274185',0,'1367877957@qq.com','2000-08-12');

SELECt * FROM `user`;

实体类:entity:

  private int userId;
    private String userName;
    private String userPwd;
    private String userPhone;
    private int userSex;
    private String userEmail;
    private Date userBirthday;
//+get/set  方法

dao:

        UserDao:

public interface UserDao {
    //登录
    User login(String name,String pwd);
    //查询全部
    List getAll();
    //模糊查询
    ListgetUserByUserNameOrUserPhoneOrUserEmail(String name);
    //根据id进行查询
    User getUserById(int id);
    //删除
    int deleteUserById(int id);
    //增加
    int addUser(User user);
    //修改
    int updateUserById(User user);
}

        Dao...IMpl:

public class UserDaoImpl extends BaseDao implements UserDao {
    @Override
    public User login(String name, String pwd) {
        String sql="select * from user where userName=? and userPwd=?";
        Object [] objects={name,pwd};
        ResultSet rs = this.executeQuery(sql, objects);
        User user=null;
        try {
            if(rs.next()){
                user=new User();
                user.setUserId(rs.getInt("userId"));
                user.setUserName(rs.getString("userName"));
                user.setUserPwd(rs.getString("userPwd"));
                user.setUserSex(rs.getInt("userSex"));
                user.setUserPhone(rs.getString("userPhone"));
                user.setUserEmail(rs.getString("userEmail"));
                user.setUserBirthday(rs.getDate("userBirthday"));
            }
        } catch (SQLException e) {
            e.printStackTrace();
        }
        return user;
    }

    @Override
    public List getAll() {
        String sql="select * from user";
        List userList=new ArrayList<>();
        ResultSet rs = this.executeQuery(sql, null);
        try {
            while(rs.next()){
                User user=new User();
                user.setUserId(rs.getInt("userId"));
                user.setUserName(rs.getString("userName"));
                user.setUserPwd(rs.getString("userPwd"));
                user.setUserSex(rs.getInt("userSex"));
                user.setUserPhone(rs.getString("userPhone"));
                user.setUserEmail(rs.getString("userEmail"));
                user.setUserBirthday(rs.getDate("userBirthday"));
                //添加到集合中
                userList.add(user);
            }
        }catch (Exception ex){
            ex.printStackTrace();
        }
        return userList;
    }

    @Override
    public List getUserByUserNameOrUserPhoneOrUserEmail(String name) {
        String sql="SELECt * FROM `user` WHERe userName LIKE ? OR userPhone LIKE ? OR userEmail LIKE ?";
        name="%"+name+"%";
        Object [] objects={name,name,name};
        List userList=new ArrayList<>();
        ResultSet resultSet = this.executeQuery(sql, objects);
        try {
            while(rs.next()){
                User user=new User();
                user.setUserId(rs.getInt("userId"));
                user.setUserName(rs.getString("userName"));
                user.setUserPwd(rs.getString("userPwd"));
                user.setUserSex(rs.getInt("userSex"));
                user.setUserPhone(rs.getString("userPhone"));
                user.setUserEmail(rs.getString("userEmail"));
                user.setUserBirthday(rs.getDate("userBirthday"));
                //添加到集合中
                userList.add(user);
            }
        }catch (Exception ex){
            ex.printStackTrace();
        }
        return userList;
    }

    @Override
    public User getUserById(int id) {
        String sql="select * from user where userId=?";
        Object [] objects={id};
        User user=null;
        ResultSet rs = this.executeQuery(sql, objects);
        try {
            if(rs.next()){
                user=new User();
                user.setUserId(this.rs.getInt("userId"));
                user.setUserName(this.rs.getString("userName"));
                user.setUserPwd(this.rs.getString("userPwd"));
                user.setUserSex(this.rs.getInt("userSex"));
                user.setUserPhone(this.rs.getString("userPhone"));
                user.setUserEmail(this.rs.getString("userEmail"));
                user.setUserBirthday(this.rs.getDate("userBirthday"));
            }
        } catch (SQLException e) {
            e.printStackTrace();
        }
        return user;
    }

    @Override
    public int deleteUserById(int id) {
        String sql="delete from user where  userId=?";
        Object [] objects={id};
        return this.executeUpdate(sql,objects);
    }

    @Override
    public int addUser(User user) {
        String sql="INSERT INTO `user`(userName,userPwd,userPhone,userSex,userEmail,userBirthday)VALUES(?,?,?,?,?,?)";
        Object [] objects={user.getUserName(),user.getUserPwd(),user.getUserPhone(),user.getUserSex(),user.getUserEmail(),user.getUserBirthday()};
        return this.executeUpdate(sql,objects);
    }

    @Override
    public int updateUserById(User user) {
        String sql="UPDATE USER SET userName=?,userPwd=?,userPhone=?,userSex=?,userEmail=?,userBirthday=? WHERe userId=?";
        Object [] objects={user.getUserName(),user.getUserPwd(),user.getUserPhone(),user.getUserSex(),user.getUserEmail(),user.getUserBirthday(),user.getUserId()};
        return this.executeUpdate(sql,objects);
    }
}

Service:

        userService:

public interface UserService {
    //登录
    User login(String name, String pwd);
    //查询全部
    List getAll();
    //模糊查询
    ListgetUserByUserNameOrUserPhoneOrUserEmail(String name);
    //删除
    boolean deleteUserById(int id);
    //增加
    boolean addUser(User user);
    //修改
    boolean updateUserById(User user);
    //根据id进行查询
    User getUserById(int id);
}

        UserServiceImpl:

public class UserServiceImpl implements UserService {
    //创建数据访问层对象
    UserDao ud=new UserDaoImpl();
    @Override
    public User login(String name, String pwd) {
        return ud.login(name,pwd);
    }

    @Override
    public List getAll() {
        return ud.getAll();
    }

    @Override
    public List getUserByUserNameOrUserPhoneOrUserEmail(String name) {
        return ud.getUserByUserNameOrUserPhoneOrUserEmail(name);
    }

    @Override
    public boolean deleteUserById(int id) {
        if(ud.deleteUserById(id)>0){
            return true;
        }
        return false;
    }

    @Override
    public boolean addUser(User user) {
        if(ud.addUser(user)>0){
            return  true;
        }
        return false;
    }

    @Override
    public boolean updateUserById(User user) {
        if(ud.updateUserById(user)>0){
            return true;
        }
        return false;
    }

    @Override
    public User getUserById(int id) {
        return ud.getUserById(id);
    }
}

Servlet:

@WebServlet("/UserServlet")
public class UserServlet extends HttpServlet {
    @Override
    protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        this.doPost(req,resp);
    }

    @Override
    protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {

        req.setCharacterEncoding("utf-8");
        resp.setCharacterEncoding("utf-8");
        resp.setContentType("text/html;charset=UTF-8");
        String path = req.getParameter("path");
        HttpSession session = req.getSession();
        UserService us=new UserServiceImpl();
        if(path.equals("login")){
            //获取用户名和密码
            String userName = req.getParameter("userName");
            String userPwd=req.getParameter("userPwd");
            User user = us.login(userName, userPwd);
            if(user!=null){
                session.setAttribute("user",user);
                resp.getWriter().print("");
            }else{
                resp.getWriter().print("");
            }
        }else if(path.equals("showAll")){
            List userList = us.getAll();
            req.setAttribute("userList",userList);
            req.getRequestDispatcher("show.jsp").forward(req,resp);	
			
        }else if(path.equals("toUpdate")){
            String id = req.getParameter("id");
            User user = us.getUserById(Integer.valueOf(id));
            req.setAttribute("userUpdate",user);
            req.getRequestDispatcher("updateOrAdd.jsp").forward(req,resp);

        }else if(path.equals("updateOrAdd")){
            String id = req.getParameter("id");
            String userName = req.getParameter("userName");
            String userPwd = req.getParameter("userPwd");
            String userPhone = req.getParameter("userPhone");
            String userSex = req.getParameter("userSex");
            String userEmail = req.getParameter("userEmail");
            String ub = req.getParameter("userBirthday");
            Date userBirthday=null;
            SimpleDateFormat sdf=new SimpleDateFormat("yyyy-MM-dd");
            try {
                userBirthday=sdf.parse(ub);
            } catch (ParseException e) {
                e.printStackTrace();
            }
            User user=new User();
            user.setUserName(userName);
            user.setUserPwd(userPwd);
            user.setUserPhone(userPhone);
            user.setUserSex(Integer.valueOf(userSex));
            user.setUserEmail(userEmail);
            user.setUserBirthday(userBirthday);
            if(id.equals("") || id.equals(" ") || id==null){
                //添加
                boolean flag = us.addUser(user);
                if(flag){
                    resp.getWriter().print("");
                }else{
                    resp.getWriter().print("");
                }
            }else{
                user.setUserId(Integer.valueOf(id));
                boolean flag = us.updateUserById(user);
                if(flag){
                    resp.getWriter().print("");
                }else{
                    resp.getWriter().print("");
                }
            }
        }else if(path.equals("del")){
            String id = req.getParameter("id");
            boolean flag = us.deleteUserById(Integer.valueOf(id));
            resp.getWriter().print(flag);
        }else if(path.equals("search")){
            String search=req.getParameter("search");
            List userList = us.getUserByUserNameOrUserPhoneOrUserEmail(search);
            req.setAttribute("userList",userList);
            req.getRequestDispatcher("show.jsp").forward(req,resp);
        }
    }
}

JSP:

登录页面:


  
    登录
    
  
  
  
趣买买购物
用户名:
密码:

展示页面show.jsp:

            我的订单     增加用户
            
  
序号 用户名 用户密码 手机号 性别 邮箱 生日 操作
${user.userId} ${user.userName} ${user.userPwd} ${user.userPhone} 男女 ${user.userEmail} ${user.userBirthday} 删除   修改

删除的关键脚本:

  
    

修改页面的关键代码:

            
用户名 (必填) 密码 (必填)
手机 (必填) 性别 checked >男 checked>女
邮箱 (必填) 生日

转载请注明:文章转载自 www.mshxw.com
本文地址:https://www.mshxw.com/it/986629.html
我们一直用心在做
关于我们 文章归档 网站地图 联系我们

版权所有 (c)2021-2022 MSHXW.COM

ICP备案号:晋ICP备2021003244-6号