2016-java基础篇-jdbc

来源：互联网发布：json接口api 编辑：程序博客网时间：2024/06/05 05:16

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);} }

0 0