[Java知识库]建设工程管理系统（二）

建设工程管理系统2

上传之前优化后的建设工程管理系统，增加了登录、注销、分页、修改密码等功能。
项目地址：项目下载链接

开发环境

• jdk1.8 版本
• eclipse 开发工具
• tomcat 服务器
• mysql 数据库

项目演示

项目信息列表

项目信息添加

修改管理员密码

搭建项目框架

编写model层代码

管理员实体类

public class Admin {
  int id;
  String name;
  String pwd;
  String nickname;
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 getNickname() {
	return nickname;
}
public void setNickname(String nickname) {
	this.nickname = nickname;
}
public Admin(int id, String name, String pwd, String nickname) {
	super();
	this.id = id;
	this.name = name;
	this.pwd = pwd;
	this.nickname = nickname;
}
public Admin() {
	super();
}

  
}

项目类

public class Project {
	int id;
	String project_id;
	String project_name;
	String deputy_name;
	String telephone;
	String addr;
	
	
	public int getId() {
		return id;
	}
	public void setId(int id) {
		this.id = id;
	}
	public String getProject_id() {
		return project_id;
	}
	public void setProject_id(String project_id) {
		this.project_id = project_id;
	}
	public String getProject_name() {
		return project_name;
	}
	public void setProject_name(String project_name) {
		this.project_name = project_name;
	}
	public String getDeputy_name() {
		return deputy_name;
	}
	public void setDeputy_name(String deputy_name) {
		this.deputy_name = deputy_name;
	}
	public String getTelephone() {
		return telephone;
	}
	public void setTelephone(String telephone) {
		this.telephone = telephone;
	}
	public String getAddr() {
		return addr;
	}
	public void setAddr(String addr) {
		this.addr = addr;
	}
	public Project(int id, String project_id, String project_name,
			String deputy_name, String telephone, String addr) {
		super();
		this.id = id;
		this.project_id = project_id;
		this.project_name = project_name;
		this.deputy_name = deputy_name;
		this.telephone = telephone;
		this.addr = addr;
	}
	public Project() {
		super();
	}
	
	
}

信息类

package com.model;

import java.util.Date;

public class Message {
    int id;
    String p_id;
    String name;
    String requires;
    String phone;
    String time;
	public int getId() {
		return id;
	}
	public void setId(int id) {
		this.id = id;
	}
	public String getP_id() {
		return p_id;
	}
	public void setP_id(String p_id) {
		this.p_id = p_id;
	}
	public String getName() {
		return name;
	}
	public void setName(String name) {
		this.name = name;
	}
	
	public String getRequires() {
		return requires;
	}
	public void setRequires(String requires) {
		this.requires = requires;
	}
	public String getPhone() {
		return phone;
	}
	public void setPhone(String phone) {
		this.phone = phone;
	}
	
	
	
	
	public String getTime() {
		return time;
	}
	public void setTime(String time) {
		this.time = time;
	}
	public Message(int id, String p_id, String name, String requires, String phone, String time) {
		super();
		this.id = id;
		this.p_id = p_id;
		this.name = name;
		this.requires = requires;
		this.phone = phone;
		this.time = time;
	}
	public Message() {
		super();
	}
    
    
}

编写数据接口

管理员接口

package com.dao;

import com.model.Admin;

public interface AdminDao {
  
	//查询账号密码
    Admin login(String name,String pwd);
    
    //修改密码
    void editPwd(String name, String pwd);
}

信息接口

package com.dao;

import java.util.List;

import com.model.Message;

public interface MsgDao {
  
	
	//显示列表
	List<Message> select(int page, int pagesize);
	
	//得到所有的页数
    int getTotalPage(int pagesize);
	
	//增加
	void insert(Message msg);
	
	//修改
	void update(Message msg);
	
	//删除
	void delete(int id);
	
	//查询，按照主键ID
	Message selectById(int id);
}

项目接口

package com.dao;

import java.util.List;

import com.model.Project;

public interface ProjectDao {
  
	
	    //查询
		List<Project> select(int page, int pagesize);
		
		//增加
		void insert(Project project);
		
		//修改
		void update(Project project);
		
		//删除
		void delete(int id);
		
		//查询，按照主键ID
		Project selectById(int id);
		
		//得到所有的页数
		int getTotalPage(int pagesize);
}

编写dao层代码

因为有大量公共的代码所以抽取出去做一个父类

package com.dao;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;



public class BaseDao {
  
	String driver="com.mysql.jdbc.Driver";
	 String url="jdbc:mysql://localhost:3306/projects?characterEncoding=utf-8";
	 String user="root";
	 String password="root";
	 
	 //查询
	 public ResultSet executeQuery(String sql, Object[] params) {
	  ResultSet rs=null;
	  Connection conn=null;
	  PreparedStatement prep=null;
	  try {
	Class.forName(driver);
	conn =DriverManager.getConnection(url, user, password);
	prep=conn.prepareStatement(sql);
	
	 for (int i = 0; i < params.length; i++) {
			prep.setObject(i + 1, params[i]);
		}
	 rs=prep.executeQuery();
	} catch (ClassNotFoundException e) {
	// TODO Auto-generated catch block
	e.printStackTrace();
	} catch (SQLException e) {
	// TODO Auto-generated catch block
	e.printStackTrace();
	}finally {
	try {
		if(rs==null) {
			conn.close();
			prep.close();
		}
		
	} catch (SQLException e) {
		// TODO Auto-generated catch block
		e.printStackTrace();
	}
	
	}
	  
	  return rs;
	 }
	 
	 
	 //增加  删除 修改
	 public void executeNoQuery(String sql, Object[] params) {
	 
	  try {
	Class.forName(driver); //加载驱动
	 Connection  conn =DriverManager.getConnection(url, user, password);//创建连接
	 PreparedStatement  pre =conn.prepareStatement(sql);
	 for (int i = 0; i < params.length; i++) {
			pre.setObject(i + 1, params[i]);
		}
	 
	pre.execute();
	
	} catch (ClassNotFoundException e) {
	// TODO Auto-generated catch block
	e.printStackTrace();
	} catch (SQLException e) {
	// TODO Auto-generated catch block
	e.printStackTrace();
	}
	 } 
	}

管理员接口实现

package com.dao.impl;

import java.sql.ResultSet;
import java.sql.SQLException;

import com.dao.AdminDao;
import com.dao.BaseDao;
import com.model.Admin;

public class AdminDaoImpl extends BaseDao implements AdminDao{
   
	//查询
	@Override
	public Admin login(String name, String pwd) {
		
	   String sql ="select * from t_admin where name= ? and pwd= ?";
	   Object [] params = {name,pwd};
	   Admin admin =new Admin();
	   ResultSet rs =super.executeQuery(sql, params);
	   try {
		while(rs.next()) {
			   admin.setName(rs.getString("name"));
			   admin.setPwd(rs.getString("pwd"));
			   admin.setNickname(rs.getString("nickname"));
		   }
	} catch (SQLException e) {
		// TODO Auto-generated catch block
		e.printStackTrace();
	}
		return admin;
	}

	//修改密码
	@Override
	public void editPwd(String name, String pwd) {
		String sql="update t_admin set pwd=? where name= ?";
		 Object [] params = {pwd,name};
		 super.executeNoQuery(sql, params);
	}
}

信息接口实现

package com.dao.impl;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

import com.dao.BaseDao;
import com.dao.MsgDao;
import com.model.Message;

public class MsgDaoImpl extends BaseDao implements MsgDao{

	@Override
	public List<Message> select(int page, int pagesize) {
		List<Message> msgList =new ArrayList<Message>();
		String sql ="select * from t_message order by id  LIMIT ?,?";
		Object [] params = {page,pagesize};
		ResultSet rs =super.executeQuery(sql, params);
		try {
			while(rs.next()){
				//读取数据
				int id  = rs.getInt("id");
				String p_id = rs.getString("p_id");
				String name =rs.getString("name");
				String requires =rs.getString("requires");
				String phone=rs.getString("phone");
				String time=rs.getString("time");
				//构建对象，记录数据
				Message message = new Message(id, p_id, name, requires, phone, time);
				msgList.add(message);
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return msgList;
	}
		

	@Override
	public void insert(Message msg) {
		String sql="insert into t_message(p_id,name,requires,phone,time)values(?,?,?,?,?)";
		Object [] params= {msg.getP_id(),msg.getName(),msg.getRequires(),msg.getPhone(),msg.getTime()};
		super.executeNoQuery(sql, params);
		
	}

	@Override
	public void update(Message msg) {
		String sql ="update t_message set name=?,requires=?,phone=?,time=? where id=?";
		System.out.println(msg.getId());
		Object [] params= {msg.getName(),msg.getRequires(),msg.getPhone(),msg.getTime(),msg.getId()};
		super.executeNoQuery(sql, params);
	}

	@Override
	public void delete(int id) {
		String sql="delete from t_message where id=?";
		Object [] params= {id};
		super.executeNoQuery(sql, params);
	}

	@Override
	public Message selectById(int id) {
		String sql="select * from t_message where id=?";
		Object [] params= {id};
		ResultSet rs=super.executeQuery(sql, params);
		Message message=null;
		try {
			while(rs.next()){
				//读取数据
				int ids  = rs.getInt("id");
				String p_id = rs.getString("p_id");
				String name =rs.getString("name");
				String requires =rs.getString("requires");
				String phone=rs.getString("phone");
				String time=rs.getString("time");
				//构建对象，记录数据
				 message = new Message(ids, p_id, name, requires, phone, time);
				
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return message;
	}


	@Override
	public int getTotalPage(int pagesize) {
		int totalPage=1;
		String sql = "select count(*) as total from t_message where 1=?";
		Object [] params= {1};
		ResultSet rs =super.executeQuery(sql, params);
		try {
			if(rs.next()){
			//总条数
				int totalRows = rs.getInt("total");
				if(totalRows%pagesize ==0){
					totalPage = totalRows /pagesize;
				}else{
					totalPage = totalRows/pagesize+1;
				}
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return totalPage;
	}
	

}

项目接口实现

package com.dao.impl;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

import com.dao.BaseDao;
import com.dao.ProjectDao;
import com.model.Project;

public class ProjectDaoImpl extends BaseDao implements ProjectDao{

	@Override
	public List<Project> select(int page, int pagesize) {
		List<Project> projectlist = new ArrayList<Project>();
		String sql = "select * from t_project ORDER BY id  LIMIT ?,?";
		Object [] params = {page,pagesize};
		ResultSet rs =super.executeQuery(sql, params);
		try {
			while(rs.next()){
				 //读取数据
				int id  = rs.getInt("id");
				String project_id = rs.getString("project_id");
				String project_name =rs.getString("project_name");
				String deputy_name =rs.getString("deputy_name");
				String telephone =rs.getString("telephone");
				String addr =rs.getString("addr");
				//构建对象，记录数据
				Project project = new Project(id, project_id, project_name, deputy_name, telephone, addr);
				projectlist.add(project);
				
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return projectlist;
	}

	@Override
	public void insert(Project project) {
		String sql = "insert into t_project(project_id,project_name,deputy_name,telephone,addr)values(?,?,?,?,?)";
		Object [] params= {project.getProject_id(),project.getProject_name(),project.getDeputy_name(),project.getTelephone(),project.getAddr()};
	    super.executeNoQuery(sql, params);
	}

	@Override
	public void update(Project project) {
		String sql="update t_project set project_name=?, deputy_name=?, telephone=?, addr=? where  id=?";
	    Object [] params= {project.getProject_name(),project.getDeputy_name(),project.getTelephone(),project.getAddr(),project.getId()};
	    super.executeNoQuery(sql, params);
	}

	@Override
	public void delete(int id) {
		String sql="delete from t_project where id =?";
		Object [] params= {id};
		super.executeNoQuery(sql, params);
 	}

	@Override
	public Project selectById(int id) {
		Project project = new Project();
		String sql ="select * from t_project where id = ?";
		Object [] params = {id};
		ResultSet rs= super.executeQuery(sql, params);
		try {
			if(rs.next()){
				//读取数据
				//设置对象属性的值
				 project.setId(rs.getInt("id"));
				 project.setProject_id(rs.getString("project_id"));
				 project.setProject_name(rs.getString("project_name"));
				 project.setProject_name(rs.getString("deputy_name"));
				 project.setDeputy_name(rs.getString("telephone"));
				 project.setTelephone(rs.getString("addr"));
				 project.setAddr(rs.getString("addr"));			
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		
		return project;
	}

	@Override
	public int getTotalPage(int pagesize) {
		int totalPage=1;
		String sql = "select count(*) as total from t_project where 1=?";
		Object [] params= {1};
		ResultSet rs =super.executeQuery(sql, params);
		try {
			if(rs.next()){
			//总条数
				int totalRows = rs.getInt("total");
				if(totalRows%pagesize ==0){
					totalPage = totalRows /pagesize;
				}else{
					totalPage = totalRows/pagesize+1;
				}
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return totalPage;
	}

}

编写controller层代码

新建管理员servlet

package com.controller;

import java.io.IOException;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;

import com.dao.impl.AdminDaoImpl;
import com.model.Admin;


public class AdminServlet extends HttpServlet {
	private static final long serialVersionUID = 1L;

    public AdminServlet() {
        super();
      
    }


	protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		doPost(request, response);
	}

	
	protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		
		request.setCharacterEncoding("utf-8");
		response.setCharacterEncoding("utf-8");
		
		AdminDaoImpl adminDao = new AdminDaoImpl();
		
		String action = request.getParameter("action");
		if(action.equals("dl")){
			String name =request.getParameter("name");
			String pwd =request.getParameter("pwd");
			Admin admins =adminDao.login(name, pwd);
			//、进行判断密码
	    	if(name.equals(admins.getName())&&pwd.equals(admins.getPwd())){
	    		HttpSession session=request.getSession();
				session.setAttribute("name", admins.getNickname());
				session.setAttribute("username", admins.getName());
	    	
	    		//跳转到主界面
	    		response.sendRedirect("ProjectServlet?action=list");
	    	}
	    	else{
	    		//登录页面
	    		response.sendRedirect("login.jsp");
	    	}
		}else if(action.equals("logout")){
    		request.getSession().invalidate();
    		response.sendRedirect("login.jsp");
    	}else if(action.equals("edit")){
    		String name = request.getParameter("name");
    		String pwd =request.getParameter("pwd");
    		String pwd1= request.getParameter("pwd1");
    		Admin admins =adminDao.login(name, pwd);
    		if(name.equals(admins.getName())&&pwd.equals(admins.getPwd())){
        		//修改新密码
        		adminDao.editPwd(name, pwd1);
        		System.out.println("修改成功");
        		response.sendRedirect("ProjectServlet?action=list");
        	}else{
        	    System.out.println("原密码不正确!");
        	    response.sendRedirect("login.jsp");
        	}
    		
    	}
    	
	}

}

新建项目管理servlet

package com.controller;

import java.io.IOException;
import java.util.List;


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

import com.dao.impl.ProjectDaoImpl;
import com.model.Project;

public class ProjectServlet extends HttpServlet {
	private static final long serialVersionUID = 1L;
       
   
    public ProjectServlet() {
        super();
        // TODO Auto-generated constructor stub
    }

	
	protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		doPost(request, response);
	}


	protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		//设置编码格式
		request.setCharacterEncoding("utf-8");
		response.setCharacterEncoding("utf-8");
		
		ProjectDaoImpl projectDao = new ProjectDaoImpl();
		String action =request.getParameter("action");
	   
		String username=(String) request.getSession().getAttribute("name");
		if(username!=null) { //判断是否d'l
		
		if(action.equals("list")){
			//执行查询
			int pagesize = 6;
//			if (request.getParameter("pagesize")!=null) {
//				pagesize=Integer.parseInt(request.getParameter("page"));
//			}
			int page=0;  //从0行开始
			int totalPage = 1;  //默认1页	
			//从页面传递
	        if(request.getParameter("page")!=null){
		    page=Integer.parseInt(request.getParameter("page"));
	}
	        int next = page + pagesize;
	        int pre = page - pagesize;
	        totalPage= projectDao.getTotalPage(pagesize);
	        int last;
	        int total=totalPage*pagesize;
	            last = total - pagesize;
	            
	        pre = pre < 0 ? 0 : pre;
	        next = next >= last ? last : next;
	            
	        request.setAttribute("next", next);
	        request.setAttribute("pre", pre);
	        request.setAttribute("last", last);
	        request.setAttribute("totalPage", totalPage);
	       
			List<Project> projectlist= projectDao.select(page,pagesize);
			//将数据加入到request请求,页面转发
			request.setAttribute("list", projectlist);
			request.getRequestDispatcher("projectlist.jsp").forward(request, response);
	
			
		}else if(action.equals("del")){
			//执行删除	    
	      int  id = Integer.parseInt(request.getParameter("id"));
			projectDao.delete(id);
			//重新转到list页面
			response.sendRedirect("ProjectServlet?action=list");
			
		}else if(action.equals("add")){
			//执行添加
		
			String project_id = request.getParameter("project_id");
			String project_name= request.getParameter("project_name");
			String deputy_name =request.getParameter("deputy_name");
			String telephone =request.getParameter("telephone");
			String addr =request.getParameter("addr");
			Project project = new Project(0,project_id, project_name, deputy_name, telephone, addr);
			projectDao.insert(project);
			
			request.getRequestDispatcher("ProjectServlet?action=list").forward(request, response);
			
		}else if(action.equals("listbyid")){
			//执行查询关键字的数字
			int id2 =Integer.parseInt(request.getParameter("id"));
			Project project = projectDao.selectById(id2);
			 //将查询得到的对象，转向到修改页面
			request.setAttribute("project", project);
		
			request.getRequestDispatcher("projectedit.jsp").forward(request, response);
			
		}else if(action.equals("edit")){
			//执行修改
			int id = Integer.parseInt(request.getParameter("id"));
			String project_id = request.getParameter("project_id");
			String project_name= request.getParameter("project_name");
			String deputy_name =request.getParameter("deputy_name");
			String telephone =request.getParameter("telephone");
			String addr =request.getParameter("addr");
			
		    Project project = new Project(id, project_id, project_name, deputy_name, telephone, addr);
		    System.out.println(project);
		    projectDao.update(project);
			response.sendRedirect("ProjectServlet?action=list");
		}
	}else {
		response.sendRedirect("login.jsp");
	}
	}

}

新建信息servlet

package com.controller;

import java.io.IOException;
import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.Date;
import java.util.List;

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

import com.dao.impl.MsgDaoImpl;
import com.model.Message;


public class MsgServlet extends HttpServlet {
	private static final long serialVersionUID = 1L;
       
    
    public MsgServlet() {
        super();
        // TODO Auto-generated constructor stub
    }

	
	protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
	doPost(request, response);
	}
	
	
	protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
	
	request.setCharacterEncoding("utf-8");
	response.setCharacterEncoding("utf-8");
	
	MsgDaoImpl msg =new MsgDaoImpl();
	String action = request.getParameter("action");
	
	String username=(String) request.getSession().getAttribute("name");
	if(username!=null) {
		if(action.equals("list")){
			int pagesize = 6;
			int page=0;  //从0行开始
			int totalPage = 1;  //默认1页	
			//从页面传递
	        if(request.getParameter("page")!=null){
		    page=Integer.parseInt(request.getParameter("page"));
	}
	        int next = page + pagesize;
	        int pre = page - pagesize;
	        totalPage= msg.getTotalPage(pagesize);
	        int last;
	        int total=totalPage*pagesize;
	            last = total - pagesize;
	            
	        pre = pre < 0 ? 0 : pre;
	        next = next >= last ? last : next;
	            
	        request.setAttribute("next", next);
	        request.setAttribute("pre", pre);
	        request.setAttribute("last", last);
	        request.setAttribute("totalPage", totalPage);
			List<Message> messList = msg.select(page,pagesize);
			request.setAttribute("list", messList);
			request.getRequestDispatcher("msglist.jsp").forward(request, response);
			//添加
		}else if(action.equals("add")){
			Message message = new Message();
			message.setP_id(request.getParameter("p_id"));
			message.setName(request.getParameter("name"));
			message.setRequires(request.getParameter("requires"));
			message.setPhone(request.getParameter("phone"));
			message.setTime(request.getParameter("time"));
			msg.insert(message);
			request.getRequestDispatcher("MsgServlet?action=list").forward(request, response);
			//执行查询关键字的数字
		}else if(action.equals("listbyid")){
			int id2 =Integer.parseInt(request.getParameter("id"));
			Message message = msg.selectById(id2);
			 //将查询得到的对象，转向到修改页面
			request.setAttribute("message", message);
			request.getRequestDispatcher("msgedit.jsp").forward(request, response);
			//修改
		}else if(action.equals("edit")){
			int id = Integer.parseInt(request.getParameter("id"));
			String p_id = request.getParameter("p_id");
			String name= request.getParameter("name");
			String requires =request.getParameter("requires");
			String phone =request.getParameter("phone");
			String time=request.getParameter("time");
			
			Message messages=new Message(id, p_id, name, requires, phone, time);
			System.out.println(messages.getName()+messages.getRequires());
			msg.update(messages);
			response.sendRedirect("MsgServlet?action=list");
		//删除
		}else if(action.equals("del")){
			 int  id = Integer.parseInt(request.getParameter("id"));
				msg.delete(id);
				//重新转到list页面
				response.sendRedirect("MsgServlet?action=list");
		}
		
	}else {
		response.sendRedirect("login.jsp");
	}
	
	}
	
	}

编写视图层

登录页面

<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>
    <base href="<%=basePath%>">
    
    <title>登录</title>
    
	<meta http-equiv="pragma" content="no-cache">
	<meta http-equiv="cache-control" content="no-cache">
	<meta http-equiv="expires" content="0">    
	<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
	<meta http-equiv="description" content="This is my page">
	<link rel="stylesheet" type="text/css" href="admin/css/normalize.css" />
<link rel="stylesheet" type="text/css" href="admin/css/demo.css" />
<!--必要样式-->
<link rel="stylesheet" type="text/css" href="admin/css/component.css" />
<!--[if IE]>
<script src="admin/js/html5.js"></script>
<![endif]-->
</head>
<body>
		<div class="container demo-1">
			<div class="content">
				<div id="large-header" class="large-header">
					<canvas id="demo-canvas"></canvas>
					<div class="logo_box">
						<h3>管理员登录</h3>
						<form action="AdminServlet?action=dl"  method="post">
							<div class="input_outer">
								<span class="u_user"></span>
								<input name="name"  class="text" style="color: #FFFFFF !important" type="text" placeholder="请输入账户">
							</div>
							<div class="input_outer">
								<span class="us_uer"></span>
								<input name="pwd" class="text" style="color: #FFFFFF !important; position:absolute; z-index:100;"value="" type="password" placeholder="请输入密码">
							</div>
							<div class="mb2"><a class="act-but submit"  style="color: #FFFFFF"><input type="submit" value="登录" style="background-color: transparent;border:0px"></a></div>
						</form>
					</div>
				</div>
			</div>
		</div><!-- /container -->
		<script src="admin/js/TweenLite.min.js"></script>
		<script src="admin/js/EasePack.min.js"></script>
		<script src="admin/js/rAF.js"></script>
		<script src="admin/js/demo-1.js"></script>
	</body>
</html>

项目列表页面

<%@page import="com.dao.impl.ProjectDaoImpl"%>
<%@page import="com.dao.ProjectDao"%>
<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>
    <base href="<%=basePath%>">
    
    <title>项目列表</title>
    
	<meta http-equiv="pragma" content="no-cache">
	<meta http-equiv="cache-control" content="no-cache">
	<meta http-equiv="expires" content="0">    
	<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
	<meta http-equiv="description" content="This is my page">
	<!--
	<link rel="stylesheet" type="text/css" href="styles.css">
	-->

  </head>
  <style>
  .tu{
  background-image: url("admin/timg.jpg");
  background-repeat: no-repeat;
   background-size: 100% 100%;
  }
  .bj{
   background-image: url("admin/t.jpg");
  background-repeat: no-repeat;
   background-size: 100% 100%;
  }
  a{
  color:white;
  text-decoration: none;
  }
  a:hover{
  color: blue;
  }
   tr:hover{
  background-color: lightblue !important;
  }
  </style>
  <script type="text/javascript">
function logout(){
	if(confirm('您确定要退出系统吗？')){
		window.location.href="${pageContext.request.contextPath}/AdminServlet?action=logout";
	}
}
</script>
  <body>
    
<div style="float:left; width:100%;height:100%">
	<!--头部-->
    <div style="float:left; width:100%; background-color:#cccccc; height:120px;" class="tu">
    	<div style="float:right; font-size:30px; color:white; padding-top:40px; padding-right:30px;">
        	建设工程监管信息系统
        </div>
        
        <div style="float:left; padding-top:90px;">
        	<a href="#" style="margin-left: 5px">系统管理</a>
            &nbsp;&nbsp;
            <a href="#">业务处理</a>
            &nbsp;&nbsp;
            <a href="#">欢迎:${name}『管理员』</a>
            &nbsp;&nbsp;
           <a href="javascript:logout()" style="margin-left:30px">退出系统</a>
        </div>
    </div>
    
    <!--内容-->
  
    <div style="float:left; width:100%;color:white !important;" class="bj">
    	<!--左边功能导航-->
        <div style="float:left; width:19%;color:white; min-height:600px;border-right: 1px solid white">
        	<ul>
        	     <li style="height:30px"> <a href="ProjectServlet?action=list">项目信息列表</a> </li>
            	 <li style="height:30px"> <a href="projectadd.jsp">项目招标登记</a> </li>
                 <li style="height:30px"> <a href="MsgServlet?action=list">招标公告列表</a> </li>
                 <li style="height:30px"> <a href="msgadd.jsp">发布招标公告</a> </li>
                 <li style="height:30px"> <a href="adminedit.jsp">修改管理密码</a> </li>
            </ul>
        </div>
        
       	<!--内容-->
        <div style="float:left; width:80%;">
        	<div style="float:left; border-bottom:1px solid #cccc; width:100%;">
            	>>项目信息
				<span style="margin-left:80px;">
                	您的位置:项目信息列表->
                </span>
            </div>
            
            <div style="float:right; margin-top:10px; margin-right:10px;">            	
            	<input type="button" value="新建工程" style="background-color:rgba(255,255,255,0.5)"; onclick="location.href='projectadd.jsp'" />
            </div>
            
            <div style="float:left; width:100%; margin-top:20px; ">
            	<table style="width:98%;" align="center">
                	<tr>
                    	<td colspan="6" style="background-color:rgba(255,255,255,0.5); color:#fff;">项目信息</td>
                        
                    </tr>
                    <tr style="background-color:rgba(255,255,255,0.5);">
                    	<td>工程编号</td>
                        <td>工程名称</td>
                        <td>工程地址</td>
                        <td>法人代表</td>
                        <td>联系电话</td>
                        <td>相关操作</td>
                    </tr>
                    <c:forEach items="${list}" var="project">
                    <tr style="background-color:rgba(255,255,255,0.5);">
                    	<td> ${project.project_id } </td>
                        <td> ${project.project_name } </td>
                        <td>${project.addr }</td>
                        <td>${project.deputy_name }</td>
                        <td>${project.telephone }</td>
                        <td> 
                        		<a href="ProjectServlet?action=listbyid&id=${project.id }">修改</a>　
                        		<a href="ProjectServlet?action=del&id=${project.id }" onclick="return confirm('确定要删除该数据吗？三思啊! 删了可就没了！')">删除</a>
                        </td>
                    </tr>
                    </c:forEach>
                      
                </table>
                <div style="width:100%;margin-top: 20px">
                <div style="text-align: center;">
                 <a href="ProjectServlet?action=list&page=0">首页</a>
                <a href="ProjectServlet?action=list&page=${pre}">上一页</a>
                   <a href="ProjectServlet?action=list&page=${next}">下一页</a>
                   <a href="ProjectServlet?action=list&page=${last}">末页</a>
                   <a href="javascript:void(0)">共 ${totalPage} 页</a>
                                           
                </div>
                 
                </div>
                
                
            </div>
        </div>
    </div>
    
  
    
</div>


  </body>
</html>

项目添加页面

<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>
    <base href="<%=basePath%>">
    
    <title>项目添加</title>
    
	<meta http-equiv="pragma" content="no-cache">
	<meta http-equiv="cache-control" content="no-cache">
	<meta http-equiv="expires" content="0">    
	<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
	<meta http-equiv="description" content="This is my page">
	

  </head>
  <style>
  .tu{
  background-image: url("admin/timg.jpg");
  background-repeat: no-repeat;
   background-size: 100% 100%;
  }
  .bj{
   background-image: url("admin/t.jpg");
  background-repeat: no-repeat;
   background-size: 100% 100%;
  }
  a{
  color:white;
  text-decoration: none;
  }
  a:hover{
  color: blue;
  }
  </style>
  <script type="text/javascript">
function logout(){
	if(confirm('您确定要退出系统吗？')){
		window.location.href="${pageContext.request.contextPath}/AdminServlet?action=logout";
	}
}
</script>
  <body>
    
<div style="float:left; width:100%;height:100%">
	<!--头部-->
    <div style="float:left; width:99.7%; background-color:#cccccc; height:120px;" class="tu">
    	<div style="float:right; font-size:30px; color:white; padding-top:40px; padding-right:30px;">
        	建设工程监管信息系统
        </div>
        
        <div style="float:left; padding-top:90px;">
        	<a href="#" style="margin-left: 5px">系统管理</a>
            &nbsp;&nbsp;
            <a href="#">业务处理</a>
            &nbsp;&nbsp;
               <a href="#">欢迎:${name}『管理员』</a>
            &nbsp;&nbsp;
           <a href="javascript:logout()" style="margin-left:30px">退出系统</a>
        </div>
    </div>
    
    <!--内容-->
  
    <div style="float:left; width:100%;color:white !important;" class="bj">
    	<!--左边功能导航-->
        <div style="float:left; width:19%;color:white; min-height:600px;border-right: 1px solid white">
        	<ul>
        	     <li style="height:30px"> <a href="ProjectServlet?action=list">项目信息列表</a> </li>
            	 <li style="height:30px"> <a href="projectadd.jsp">项目招标登记</a> </li>
                 <li style="height:30px"> <a href="MsgServlet?action=list">招标公告列表</a> </li>
                 <li style="height:30px"> <a href="msgadd.jsp">发布招标公告</a> </li>
                 <li style="height:30px"> <a href="adminedit.jsp">修改管理密码</a> </li>
            </ul>
        </div>
        
       	<!--内容-->
        <div style="float:left; width:80%;">
        	<div style="float:left; border-bottom:1px solid #cccc; width:100%;">
            	>>管理系统
				<span style="margin-left:80px;">
                	您的位置：项目信息录入->
                </span>
            </div>
            
            <div style="float:right; margin-top:10px; margin-right:10px;">            	
            	<input type="button" value="返回" style="background-color:rgba(255,255,255,0.5);" onclick="location.href='ProjectServlet?action=list'" />
            </div>
            
             <div style="float:left; width:100%; margin-top:20px; ">
            	<form method="post" action="ProjectServlet?action=add">
            	<table style="width:98%;background-color:rgba(255,255,255,0.5);" align="center">
                	<tr>
                    	<td colspan="3" style="background-color:rgba(255,255,255,0.5); color:#fff;">项目信息添加</td>
                        
                    </tr>
                    <tr >
                    	<td align="right">工程编号：</td>
                        <td> <input type="text" name="project_id" /> </td>
                    </tr>
                    <tr >
                    	<td align="right">工程名称：</td>
                        <td> <input type="text" name="project_name" /> </td>
                    </tr>
                    <tr >
                    	<td align="right">法人代表：</td>
                        <td> <input type="text" name="deputy_name" /> </td>
                    </tr>
                    <tr >
                    	<td align="right">建设单位电话：</td>
                        <td> <input type="text" name="telephone" /> </td>
                    </tr>
                    <tr >
                    	<td align="right">建设单位地址：</td>
                        <td> <input type="text" name="addr" /> </td>
                    </tr>
                    <tr>
                    	<td></td>
                        <td> <input type="submit" value="确定" /> <input type="reset" value="重置" /></td>
                    </tr>
                </table>
                </form>
                
            </div>
                
                
           
        </div>
    </div>
    
  
    
</div>


  </body>
</html>

项目修改页面

<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>
    <base href="<%=basePath%>">
    <title>项目修改</title>
	<meta http-equiv="pragma" content="no-cache">
	<meta http-equiv="cache-control" content="no-cache">
	<meta http-equiv="expires" content="0">    
	<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
	<meta http-equiv="description" content="This is my page">
	

  </head>
  <style>
  .tu{
  background-image: url("admin/timg.jpg");
  background-repeat: no-repeat;
   background-size: 100% 100%;
  }
  .bj{
   background-image: url("admin/t.jpg");
  background-repeat: no-repeat;
   background-size: 100% 100%;
  }
  a{
  color:white;
  text-decoration: none;
  }
  a:hover{
  color: blue;
  }
  </style>
  <script type="text/javascript">
function logout(){
	if(confirm('您确定要退出系统吗？')){
		window.location.href="${pageContext.request.contextPath}/AdminServlet?action=logout";
	}
}
</script>
  <body>
    
<div style="float:left; width:100%;height:100%">
	<!--头部-->
    <div style="float:left; width:100%; background-color:#cccccc; height:120px;" class="tu">
    	<div style="float:right; font-size:30px; color:white; padding-top:40px; padding-right:30px;">
        	建设工程监管信息系统
        </div>
        
        <div style="float:left; padding-top:90px;">
        	<a href="#" style="margin-left: 5px">系统管理</a>
            &nbsp;&nbsp;
            <a href="#">业务处理</a>
            &nbsp;&nbsp;
             <a href="#">欢迎:${name}『管理员』</a>
            &nbsp;&nbsp;
           <a href="javascript:logout()" style="margin-left:30px">退出系统</a>
        </div>
    </div>
    
    <!--内容-->
  
    <div style="float:left; width:100%;color:white !important;" class="bj">
    	<!--左边功能导航-->
        <div style="float:left; width:19%;color:white; min-height:600px;border-right: 1px solid white">
        	<ul>
        	     <li style="height:30px"> <a href="ProjectServlet?action=list">项目信息列表</a> </li>
            	 <li style="height:30px"> <a href="projectadd.jsp">项目招标登记</a> </li>
                 <li style="height:30px"> <a href="MsgServlet?action=list">招标公告列表</a> </li>
                 <li style="height:30px"> <a href="msgadd.jsp">发布招标公告</a> </li>
                 <li style="height:30px"> <a href="adminedit.jsp">修改管理密码</a> </li>
            </ul>
        </div>
        
       	<!--内容-->
        <div style="float:left; width:80%;">
        	<div style="float:left; border-bottom:1px solid #cccc; width:100%;">
            	>>项目信息录入
				<span style="margin-left:80px;">
                	您的位置：招投标流程->
                </span>
            </div>
            
            <div style="float:right; margin-top:10px; margin-right:10px;">            	
            	<input type="button" value="返回" style="background-color:rgba(255,255,255,0.5);" onclick="location.href='ProjectServlet?action=list'" />
            </div>
            
             <div style="float:left; width:100%; margin-top:20px; ">
            	<form method="post" action="ProjectServlet?action=edit">
            	<table style="width:98%;background-color:rgba(255,255,255,0.5);" align="center">
                	<tr>
                    	<td colspan="3" style="background-color:rgba(255,255,255,0.5); color:#fff;">项目信息添加</td>
                        
                    </tr>
                     <tr >
                        <td> <input type="hidden"  value="${project.id }" name="id" readonly="readonly" /> </td>
                    </tr>
                    <tr >
                    	<td align="right" >工程编号：</td>
                        <td > <input type="text" style="background-color:rgba(255,255,255,0.5)" name="project_id"  value="${project.project_id }" readonly="readonly"/> </td>
                    </tr>
                    <tr >
                    	<td align="right">工程名称：</td>
                        <td > <input type="text" style="background-color:rgba(255,255,255,0.5)" name="project_name" value="${project.project_name }"/> </td>
                    </tr>
                    <tr >
                    	<td align="right">法人代表：</td>
                        <td> <input type="text" style="background-color:rgba(255,255,255,0.5)" name="deputy_name" value="${project.deputy_name }"/> </td>
                    </tr>
                    <tr >
                    	<td align="right">建设单位电话：</td>
                        <td> <input type="text" style="background-color:rgba(255,255,255,0.5)" name="telephone" value="${project.telephone }"/> </td>
                    </tr>
                    <tr >
                    	<td align="right">建设单位地址：</td>
                        <td> <input type="text" style="background-color:rgba(255,255,255,0.5)" name="addr" value="${project.addr}"/> </td>
                    </tr>
                    <tr>
                    	<td></td>
                        <td> <input type="submit" value="确定" style="background-color:rgba(255,255,255,0.5)" /> </td>
                    </tr>
                </table>
                </form>
                
            </div>
                
                
           
        </div>
    </div>
    
  
    
</div>


  </body>
</html>

后面的信息列表页面和项目管理页面差不多，就不一样演示了，详细可以看上传的项目代码。(一定要记得导包！！！)