jsp连接Oracle

jsp连接oracle数据库

1.工具类(util)

连接Oracle的变量

private static  String   DRIVER="oracle.jdbc.driver.OracleDriver";
private static  String URL="jdbc:oracle:thin:@127.0.0.1:1521:ORCL";
private static  String USERNAME="scott";     // 用户名
private static  String PASSWORD="123456";  //密码

加载驱动

static {
	try {
		Class.forName(DRIVER);
		System.out.println("加载成功");
	} catch (ClassNotFoundException e) {
		e.printStackTrace();
	}
}

连接数据库（返回Connection对象）

public static Connection getConnection(){
	Connection conn = null;
	try {
		conn = DriverManager.getConnection(URL,USERNAME,PASSWORD);
		System.out.println("链接成功");
	} catch (SQLException e) {
		e.printStackTrace();
	}
	return conn;
}

关闭三大对象

public static void closeAll(ResultSet rs,Connection conn,PreparedStatement  pstm)
{
	try {
		if(rs!=null){
			rs.close();
		}if(pstm!=null){
			pstm.close();
		}if(conn!=null)
		{
			conn.close();
		}
	} catch (SQLException e) {
		e.printStackTrace();
	}
}

2.编写jsp页面

创建个form表单即可

<form action="UserServlet" method="get"></from>  //跳转页面是UserServlet

3. 创建UserServlet

jsp中是get方法，则在doget方法中

	protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		request.setCharacterEncoding("UTF-8");
		response.setContentType("text/html;charset=UTF-8");
		PrintWriter out = response.getWriter();
		UserDAO ud = new UserDAO();      // 创建dao对象
		System.out.println(ud.isExistEmail(7369));	//dao对象调用方法	
	}

4.创建UserDAO .java(进行数据库的操作)

Connection conn = null;
	PreparedStatement ps = null;
	ResultSet rs = null;
	
	public boolean isExistEmail(int email) {
		conn = DBUtil.getConnection();
		String sql = "SELECT * FROM emp WHERE empno=?";
		try {
			ps = conn.prepareStatement(sql);
			ps.setObject(1, email);
			rs = ps.executeQuery();
			if (rs.next())
				return true;
		} catch (SQLException e) {
			e.printStackTrace();
		} finally {
			DBUtil.closeAll(rs, conn, ps);
		}
		return false;
	}