1,在安装oracle的目录下找到ojdbc。目录一般是product/11.20/dbhome_1/jdbc.复制到工程下webContent/WEB-INF/lib。
2,编写java类:
View Code
package test;import java.sql.*;public class Dbconn { String user = "user"; String password = "123456"; String url ="jdbc:oracle:thin:@localhost:1521:orcl";//orcl表示你的SID// String url="jdbc:oracle:thin:@localhost:1521:orcl"; Connection conn = null; Statement stmt = null; ResultSet rs = null; public Dbconn(){ try { //注册驱动程序 DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver()); //获得数据库连接 conn = DriverManager.getConnection(url,user,password); //设置为自动提交 conn.setAutoCommit(true);// 建立Statement对象 stmt =conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); }// System.out.println("hello"); } //查询语句方法 public ResultSet executeQuery(String sql){ try { rs = stmt.executeQuery(sql); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return rs; } //下面测试 public static void main(String[] args){ String sql = "select * from userinfo"; ResultSet rs = new Dbconn().executeQuery(sql); try { while(rs.next()){ System.out.println(rs.getString(1)+" "+rs.getString(2)+" "+rs.getString(3)+" "+rs.getString(4)); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } System.out.println("henolks"); } }
下面随便用一个jsp页面来测试一下:
View Code
Insert title herehttp://www.usreplica.me
http://www.ukreplica.me
http://www.watch527.com