(一)美化管理系統界面，完善頁面
軟體：
playcolor——得到顔色配置
Sothink Logo Maker——制作網頁logo
(二)管理系統功能改進
1.删除使用者
（1）wel.java中添加
pw.println("<td><a href="DelUserCl?userid=" target="_blank" rel="external nofollow" target="_blank" rel="external nofollow" mce_href="DelUserCl?userid=" target="_blank" rel="external nofollow" target="_blank" rel="external nofollow" "+ub.getUserId()+" οnclick=/"return window.confirm('您确認删除該使用者嗎？')/">删除使用者</a></td>");
（2）編寫DelUserCl.java（删除處理頁面）
//處理删除某個使用者
package com.tsinghua;
import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;
public class DelUserCl extends HttpServlet {
public void init() throws ServletException{}
public void process(HttpServletRequest req,HttpServletResponse res)
throws ServletException,IOException{
try{
res.setContentType("text/html;charset=UTF-8"); //中文亂碼解決
//調用userBeanCl的删除使用者的方法，完成删除
UserBeanCl ubc=new UserBeanCl();
//接收從Wel.java中傳遞的id
String id=req.getParameter("userid");
if( ubc.delUser(id)){
//删除成功
res.sendRedirect("Ok");
}else{
//删除失敗
res.sendRedirect("Erro");
}
}catch(Exception ex){
ex.printStackTrace();
}
}
public void doGet(HttpServletRequest req,HttpServletResponse res)
throws ServletException,IOException{
process(req,res);
}
public void doPost(HttpServletRequest req,HttpServletResponse res)
throws ServletException,IOException{
process(req,res);
}
public void destroy(){
super.destroy();
}
}
（3）編寫Erro.java（删除失敗）
//操作失敗頁面
package com.tsinghua;
import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;
public class Erro extends HttpServlet {
public void init() throws ServletException{}
public void process(HttpServletRequest req,HttpServletResponse res)
throws ServletException,IOException{
try{
//中文亂碼解決
res.setContentType("text/html;charset=UTF-8");
//業務邏輯
PrintWriter pw=res.getWriter();
//傳回登入界面
pw.println("<html>");
pw.println("<body bgcolor=#345D6E>");
pw.println("<img src="images/lola.gif" mce_src="images/lola.gif"><hr><center>");
pw.println("<h1>很遺憾，操作失敗！</h1>");
pw.println("<a href="main" target="_blank" rel="external nofollow" target="_blank" rel="external nofollow" target="_blank" rel="external nofollow" target="_blank" rel="external nofollow" mce_href="main" target="_blank" rel="external nofollow" target="_blank" rel="external nofollow" target="_blank" rel="external nofollow" target="_blank" rel="external nofollow" >傳回主界面</a> <a href="welcome" target="_blank" rel="external nofollow" target="_blank" rel="external nofollow" target="_blank" rel="external nofollow" target="_blank" rel="external nofollow" mce_href="welcome" target="_blank" rel="external nofollow" target="_blank" rel="external nofollow" target="_blank" rel="external nofollow" target="_blank" rel="external nofollow" >繼續删除/修改使用者</a>");
pw.println("</center><hr><img src="images/mylogo.bmp" mce_src="images/mylogo.bmp">");
pw.println("</body>");
pw.println("</html>");
}catch(Exception ex){
ex.printStackTrace();
}
}
public void doGet(HttpServletRequest req,HttpServletResponse res)
throws ServletException,IOException{
process(req,res);
}
public void doPost(HttpServletRequest req,HttpServletResponse res)
throws ServletException,IOException{
process(req,res);
}
public void destroy(){
super.destroy();
}
}
（4）編寫Ok.java（删除成功頁面）
//操作成功頁面
package com.tsinghua;
import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;
public class Ok extends HttpServlet {
public void init() throws ServletException{}
public void process(HttpServletRequest req,HttpServletResponse res)
throws ServletException,IOException{
try{
//中文亂碼解決
res.setContentType("text/html;charset=UTF-8");
//業務邏輯
PrintWriter pw=res.getWriter();
//傳回登入界面
pw.println("<html>");
pw.println("<body bgcolor=#345D6E>");
pw.println("<img src="images/lola.gif" mce_src="images/lola.gif"><hr><center>");
pw.println("<h1>恭喜你，操作成功</h1>");
pw.println("<a href="main" target="_blank" rel="external nofollow" target="_blank" rel="external nofollow" target="_blank" rel="external nofollow" target="_blank" rel="external nofollow" mce_href="main" target="_blank" rel="external nofollow" target="_blank" rel="external nofollow" target="_blank" rel="external nofollow" target="_blank" rel="external nofollow" >傳回主界面</a> <a href="welcome" target="_blank" rel="external nofollow" target="_blank" rel="external nofollow" target="_blank" rel="external nofollow" target="_blank" rel="external nofollow" mce_href="welcome" target="_blank" rel="external nofollow" target="_blank" rel="external nofollow" target="_blank" rel="external nofollow" target="_blank" rel="external nofollow" >繼續删除/修改使用者</a>");
pw.println("</center><hr><img src="images/mylogo.bmp" mce_src="images/mylogo.bmp">");
pw.println("</body>");
pw.println("</html>");
}catch(Exception ex){
ex.printStackTrace();
}
}
public void doGet(HttpServletRequest req,HttpServletResponse res)
throws ServletException,IOException{
process(req,res);
}
public void doPost(HttpServletRequest req,HttpServletResponse res)
throws ServletException,IOException{
process(req,res);
}
public void destroy(){
super.destroy();
}
}
2.顯示使用者的頭像
（1）資料庫添加字段：
alter table users add column myPic varchar(50);
insert into users(myPic) values('1.gif');//添加記錄
（2）在images中加入頭像
（3）添加代碼：
pw.println("<img src="images/lola.gif" mce_src="images/lola.gif"> 歡迎您："+myName+"<img src="images/1.gif" mce_src="images/1.gif"><hr><center>");
3.指定跳轉到某一頁
清楚servlet和html表單送出原理
Wel.java中加入：
pw.println("請輸入需要跳轉的頁面");
pw.println("<form action=welcome>");
pw.println("<input type=text name=pageNow>");
pw.println("<input type=submit value=go>");
pw.println("</form>");
3.精确查找和模糊查找
//查詢使用者使用表單
pw.println("<form method=post action=search>");
pw.println("請輸入使用者名：<input type=text name=uname>");
pw.println("<input type=submit value=搜><br><br>");
pw.println("<input type=radio name=sType value=mo checked>模糊查詢");
pw.println("<input tyep=radio name=sType value=zhu>精确查詢");
pw.println("</form>");
//得到搜尋的類型
String type=req.getParameter("sType");
String con=req.getParameter("uname");
if(con!=null){
String sql="";
if(type.equals("mo")){
sql="select * from users where username like '%'"+con+"%'";//模糊查找
}else{
sql="select * from users where username='"+con+"'";// 精确查找
}
}
（三）終極架構圖
![使用Windbg調試.Net應用程式[圖]](data:image/gif;base64,R0lGODlhAQABAIAAAP///wAAACwAAAAAAQABAAACAkQBADs=)