建設工程管理系統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>
<a href="#">業務處理</a>
<a href="#">歡迎:${name}『管理員』</a>
<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>
<a href="#">業務處理</a>
<a href="#">歡迎:${name}『管理員』</a>
<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>
<a href="#">業務處理</a>
<a href="#">歡迎:${name}『管理員』</a>
<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>
后面的資訊串列頁面和專案管理頁面差不多，就不一樣演示了，詳細可以看上傳的專案代碼，(一定要記得導包！！！)
轉載請註明出處，本文鏈接：https://www.uj5u.com/qita/290851.html
標籤：其他
上一篇：介面測驗知識
下一篇：關于Keil 5 下載及安裝教程