addservlet.java

用Servlet做的一个小项目。用Servlet做的一个小项目。用Servlet做的一个小项目。用Servlet做的一个小项目。用Servlet做的一个小项目。

package controller;

import java.io.IOException;
import java.io.PrintWriter;
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 javax.servlet.http.HttpSession;

import model.UserBean;
import model.dao.BaseDao;

/**
 * 添加联系人
 */
public class AddServlet extends HttpServlet {

	Connection con = null;

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

	public void doPost(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		HttpSession session = request.getSession(false);
		request.setCharacterEncoding("GBK");
		// 获取添加的元素的值
		String name = request.getParameter("name");
		String sex = request.getParameter("sex");
		String phone = request.getParameter("phone");
		String address = request.getParameter("address");
		String mobilePhone = request.getParameter("mobilePhone");
		String company = request.getParameter("company");
		String comPhone = request.getParameter("comPhone");
		String comAddress = request.getParameter("comAddress");
		int relation = Integer.parseInt(request.getParameter("relation"));

		// 定义SQL语句
		String sql = "insert BOOK(name,sex,phone,address,mobilePhone,company,comPhone,comAddress,relation,userId) values(?,?,?,?,?,?,?,?,?,?)";

		// 获取session
		UserBean user = (UserBean) session.getAttribute("user");

		// 给占位符赋值
		String[] param = { name, sex, phone, address, mobilePhone, company,
				comPhone, comAddress, String.valueOf(relation),
				String.valueOf(user.getUserId()) };

		// 传值并执行命令
		int num = BaseDao.executeSQL(sql, param);
		if (num > 0) {
			response.sendRedirect("bookContent.jsp");
		} else {
			response.sendRedirect("addError.jsp");
		}

	}
}