newcustomer2servlet.java

中国移动管理系统

package com.chinamobile.servlet;

import java.io.IOException;
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.chinamobile.dao.CustomerDAO;
import com.chinamobile.dao.SQLServerDAOFactory;

public class NewCustomer2Servlet extends HttpServlet {

	@Override
	protected void doGet(HttpServletRequest req, HttpServletResponse resp)
			throws ServletException, IOException {
		doPost(req, resp);
	}

	@Override
	protected void doPost(HttpServletRequest request,
			HttpServletResponse response) throws ServletException, IOException {
		String isExist = request.getParameter("isExist");
		String id = request.getParameter("Customer_ID");
		String sex = request.getParameter("sex");
		String ID_Type = request.getParameter("cardName");
		if ("身份证".equals(ID_Type)){
			ID_Type="D";
		} else if ("军官证".equals(ID_Type)){
			ID_Type="A";
		} else if ("护照".equals(ID_Type)){
			ID_Type="P";
		}
		String ID_Number = request.getParameter("cardNum");
		String name = request.getParameter("CustomerName");
		String birthday = request.getParameter("birthday");
		String address = request.getParameter("address");

		SQLServerDAOFactory dao = new SQLServerDAOFactory();
		Connection conn = dao.getConnection();
		PreparedStatement pstmt = null;
		String update = "update TCustomer set ID_Type=?,ID_Number=?,Customer_Name=?,Customer_Birthday=?,Customer_Sex=?,Customer_Address=? where Customer_ID=?";
		String insert = "insert into TCustomer values(null,?,?,?,?,?,?)";

		try {
			if ("true".equals(isExist)) {
				pstmt = conn.prepareStatement(update);
				pstmt.setString(1, ID_Type);
				pstmt.setString(2, ID_Number);
				pstmt.setString(3, name);
				pstmt.setString(4, birthday);
				pstmt.setString(5, sex);
				pstmt.setString(6, address);
				pstmt.setString(7, id);
			} else if ("false".equals(isExist)) {
				pstmt = conn.prepareStatement(insert);
				pstmt.setString(1, ID_Type);
				pstmt.setString(2, ID_Number);
				pstmt.setString(3, name);
				pstmt.setString(4, birthday);
				pstmt.setString(5, sex);
				pstmt.setString(6, address);
			}
			pstmt.execute();
		} catch (SQLException e) {
			e.printStackTrace();
		}
		request.getRequestDispatcher("newUser.jsp?id="+id).forward(request, response);
	}

}