addservlet.java

java+oracle 完成通讯录的增删改查

package servlet;

import java.io.IOException;

import java.sql.Connection;

import java.sql.SQLException;
import java.sql.Statement;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import db.OracleConn;

public class AddServlet extends HttpServlet {

	public void doGet(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		// 处理中文问题
		request.setCharacterEncoding("gbk");
		response.setContentType("text/html; charset=gbk");
		// 从addRecord.jsp中提取联系人信息
		String Name = request.getParameter("Name");
		// System.out.println(Name);
		String Phone = (String) request.getParameter("Phone");
		String Address = (String) request.getParameter("Address");
		String Qq = (String) request.getParameter("Qq");
		String Email = (String) request.getParameter("Email");
		Connection conn = OracleConn.getConnection();
		try {
			Statement stmt = conn.createStatement();
			String sql = "insert into addresslist values(seq_list.nextval,'"
					+ Name + "','" + Phone + "','" + Address + "',to_number('"
					+ Qq + "'),'" + Email + "')";

			int affectedRow = stmt.executeUpdate(sql);
			if (affectedRow != 0) {
				response.sendRedirect("addOk.jsp");
				System.out.println("插入了" + affectedRow + "笔数据!");
			}
		} catch (SQLException e) {

			e.printStackTrace();
		} finally {
			OracleConn.closeConnection(conn);
		}

	}

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

	}

}