部门信息管理系统

实现对部门信息的分类管理，对不同部门人员的管理（增删改查），新用户的注册和登陆等

功能分析：

1. 实现用户的登陆
2. 实现用户的注册（注册不同的部门和职位）
3. 登陆之后会显示所有员工和经理的信息
4. 实现对这些信息的删除和更新操作

下面看一下效果图吧

登陆页面

注册页面

登陆之后页面

点击删除ID为10之后的页面

点击更新之后的页面

这个系统一共有两大步

1 . 数据库
2 . 后台功能的实现

下面我们将实现这两大步

一 数据库内容

数据库内容自行设计和填充数据！！！

二 后台功能代码

目录结构图

下面正式欣赏代码

@1 bean包

bean包里的Department.java代码

package com.hnpi.bean;

public class Department {
   
	private int id;
	private String branch;
	public int getId() {
   
		return id;
	}
	public void setId(int id) {
   
		this.id = id;
	}
	public String getBranch() {
   
		return branch;
	}
	public void setBranch(String branch) {
   
		this.branch = branch;
	}
	public Department() {
   
		super();
		// TODO Auto-generated constructor stub
	}
	public Department(int id, String branch) {
   
		super();
		this.id = id;
		this.branch = branch;
	}
	
	

}

bean包里的User.java代码

package com.hnpi.bean;

public class User {
   
	private int id;
	private String name;
	private String pwd;
	private String rname;
	private String branch;
	private String role;
	public int getId() {
   
		return id;
	}
	public void setId(int id) {
   
		this.id = id;
	}
	public String getName() {
   
		return name;
	}
	public void setName(String name) {
   
		this.name = name;
	}
	public String getPwd() {
   
		return pwd;
	}
	public void setPwd(String pwd) {
   
		this.pwd = pwd;
	}
	public String getRname() {
   
		return rname;
	}
	public void setRname(String rname) {
   
		this.rname = rname;
	}
	public String getBranch() {
   
		return branch;
	}
	public void setBranch(String branch) {
   
		this.branch = branch;
	}
	public String getRole() {
   
		return role;
	}
	public void setRole(String role) {
   
		this.role = role;
	}
	public User() {
   
		super();
		// TODO Auto-generated constructor stub
	}
	public User(int id, String name, String pwd, String rname, String branch,
			String role) {
   
		super();
		this.id = id;
		this.name = name;
		this.pwd = pwd;
		this.rname = rname;
		this.branch = branch;
		this.role = role;
	}
	
	

}

@2 servlet包

servlet 包里的LoginServlet.java代码

package com.hnpi.servlet;

import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import com.hnpi.util.DBUtil;

public class LoginServlet extends HttpServlet {
   


	public void doGet(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
   

		doPost(request, response);
	}


	public void doPost(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
   

		String name = request.getParameter("name");
		String pwd = request.getParameter("pwd");
		
		request.setCharacterEncoding("utf-8");
		response.setContentType("text/html");
		
		boolean flag = false;
		Connection conn = DBUtil.getConn();
		PreparedStatement ps = null;
		ResultSet rs = null;
		String sql = "select * from users where name = ? and pwd = ?";
		
		try {
   
			ps = conn.prepareStatement(sql);
			ps.setString(1, name);
			ps.setString(2, pwd);
			rs = ps.executeQuery();
			
			if(rs.next<