addcontact.java

电话簿管理系统

package Bean;

import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;

public class addContact extends HttpServlet{
	
	public void doPost(HttpServletRequest request,HttpServletResponse response) throws ServletException,IOException{
		DB db = new DB();	
		response.setContentType("text/html");
		PrintWriter out = response.getWriter();		
		String str = request.getParameter("edit");
		String sql = "";
		
		String fName,lName,jobTitle,dept,eMail,offPh,mobile;
		
		fName = request.getParameter("FirstName").trim();
		lName = request.getParameter("LastName").trim();
		jobTitle = request.getParameter("JobTitle").trim();
		dept = request.getParameter("Dept").trim();
		eMail = request.getParameter("EMail").trim();
		offPh = request.getParameter("OffPh").trim();
		mobile = request.getParameter("Mobile").trim();
		
		try{
			if(str.equals("false")){
				sql = "insert into myaddrbook (firstname,lastname,jobtitle,department,offph,mobile,email) values(";
				if(fName.equals(""))
					sql = sql + "null" +",";
				else
					sql = sql + "'" + fName + "',";
				if(lName.equals(""))
					sql = sql + "null" + ",";
				else
					sql = sql + "'" + lName + "',";
				if(jobTitle.equals(""))
					sql = sql + "null" + ",";
				else
					sql = sql + "'" + jobTitle + "',";
				if(dept.equals(""))
					sql = sql + "null" + ",";
				else
					sql = sql + "'" + dept + "',";
				if(offPh.equals(""))
					sql = sql + "null" + ",";
				else
					sql = sql + offPh + ",";
				if(mobile.equals(""))
					sql = sql + "null" + ",";
				else
					sql = sql + mobile + ",";
				if(eMail.equals(""))
					sql = sql + "null" + ")";
				else
					sql = sql + "'" + eMail + "')";
				
				if(db.addContact(sql)){
					out.println("Contact successfully updated!");
				}
				else{
					out.println("Contact failed updadted,Please check the data!");
				}
				
			}
			else if(str.equals("true")){
				HttpSession session = request.getSession();
				String ID = String.valueOf((session.getAttribute("ID")));
				sql = "update myaddrbook set ";
				if(fName.equals(""))
					sql += "firstname = null,";
				else
					sql += "firstname = '" + fName + "',";
				if(lName.equals(""))
					sql += "lastname = null,";
				else
					sql += "lastname = '" + lName + "',";
				if(jobTitle.equals(""))
					sql += "jobTitle = null,";
				else
					sql += "JobTitle = '" + jobTitle + "',";
				if(dept.equals(""))
					sql += "department = null,";
				else
					sql += "department = '" + dept + "',";
				if(offPh.equals(""))
					sql += "offPh = null,";
				else
					sql += "offph = '" + offPh + "',";
				if(mobile.equals(""))
					sql += "mobile = null,";
				else
					sql += "mobile ='" + mobile + "',";
				if(eMail.equals(""))
					sql += "email = null";
				else
					sql += "email = '" + eMail + "'";					
				sql += " where ID = '" + ID + "'";

				if(db.modifyContact(sql)){
					out.print("Contact successfully updated!");
				}
				else{
					out.println("Contact failed updated,Please check the data!");
				}
			}
		}
		catch(Exception e){
			out.println("Contact failed updated!"+e.getMessage());
		}
		
	}
}