2016-java基础篇-jdbc

java连接oracle写法：

1.引入如下jar包：

E:\app\cl\product\11.2.0\dbhome_1\jdbc\lib\ojdbc6_g.jar

2.具体代码如下：

package com.tsinghuas;

import javax.servlet.http.*;
import java.io.*;
import java.sql.*;

public class LoginCl extends HttpServlet{

	public void doGet(HttpServletRequest req,HttpServletResponse res){
		Connection con=null;
		PreparedStatement pre=null;
		ResultSet result =null;
		
		try{
			//
			String su=req.getParameter("username");
			String sp=req.getParameter("passwd");
			if(su.equals("sp")&&sp.equals("123")){
			Class.forName("oracle.jdbc.driver.OracleDriver");
			String url="jdbc:oracle:thin:@127.0.0.1:1521:orcl";
			String user="Test01";
			String password="Test01";
			con=DriverManager.getConnection(url,user,password);
			String sql="select * from users where username=?";
			pre =con.prepareStatement(sql);
			pre.setString(1,"admin");
			result=pre.executeQuery();
			String email="";
			while(result.next()){
				email=result.getString("email");
				System.out.println(email);
			}
			
				HttpSession hs=req.getSession(true);
				hs.setMaxInactiveInterval(10);
				hs.setAttribute("pass","ok");
				hs.setAttribute("email1",email);
				
				res.sendRedirect("welcome?uname="+su+"&uPasswd="+sp);
			}else{
				res.sendRedirect("login");
			}
			

			
			
		}catch(Exception e){
			e.printStackTrace();
		}
		finally{
			try{
				result.close();
				pre.close();
				con.close();
			}catch(Exception e){
				e.printStackTrace();
			}
		}
	}
	
	public void doPost(HttpServletRequest req,HttpServletResponse res){
		
		this.doGet(req,res);
	} 
}