selectrecordservlet.java

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

package servlet;

import java.io.IOException;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import javax.servlet.RequestDispatcher;
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 bean.AddressListBean;

import db.OracleConn;

public class selectRecordServlet extends HttpServlet {

	public void doGet(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		final String sql = "select * from AddressList where name=?";
		String address = "selectFail.jsp";
		Connection conn = null;
		PreparedStatement stmt = null;
		ResultSet rs = null;
		AddressListBean listbean = new AddressListBean();
		conn = OracleConn.getConnection();
		try {
			stmt = conn.prepareStatement(sql);
			stmt.setString(1, request.getParameter("Id"));
			rs = stmt.executeQuery();
			if (rs != null) {
				rs.next();
				listbean.setId(rs.getInt("id"));
				listbean.setName(rs.getString("name"));
				listbean.setAddress(rs.getString("address"));
				listbean.setQq(rs.getInt("qq"));
				listbean.setPhone(rs.getString("phone"));
				listbean.setEmail(rs.getString("email"));
				address = "selectidOK.jsp";
			}
		} catch (SQLException e) {
			e.printStackTrace();
		} finally {
			OracleConn.closeResultSet(rs);
			OracleConn.closeConnection(conn);
		}

		request.setAttribute("list", listbean);
		// HttpSession session = (HttpSession)request.getSession();
		// session.setAttribute("list", listbean);
		RequestDispatcher dis = request.getRequestDispatcher(address);
		dis.forward(request, response);
	}

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

}