oracle入门之jdbc

编程工具：eclipse neno
需要的jar包：ojdbc6.jar
一、首先新建一个web项目，名称为oraclejdbc（随便取名字）

二、导入jar包，jar包的位置在oracle安装好后的位置，比如我的jar包位置在这里：F:\app\hp\product\11.2.0\dbhome_1\jdbc\lib
直接复制到web项目中的lib下就可以了
三、如上图所示，在src下新建一个测试包com.oracle.test，在包下新建一个类jdbcTest.java

package com.oracle.test;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Date;

public class jdbcTest {
    private String driverName = "oracle.jdbc.OracleDriver";
    private String url = "jdbc:oracle:thin://localhost:1521/orcl";
    private String username ="lisi";
    private String password = "123";
    private Connection conn = null;
    private PreparedStatement pstmt = null;
    private ResultSet rs = null;
    public jdbcTest(){
        try {
            Class.forName(driverName);
        } catch (ClassNotFoundException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
    }
    //连接oracle数据库
    public Connection getConn(){
        try {
             conn = DriverManager.getConnection(url, username, password);
        } catch (SQLException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
        return conn;
    }
    /**
     * 查找老师
     */
    public void selTeachers(){
        conn = getConn();
        String sql = "select teachername,to_char(joindate,'yyyy-mm-dd hh24:mi:ss') as joindate_str,info from teacher order by teacherid desc";
        try {
            pstmt = conn.prepareStatement(sql);
            rs = pstmt.executeQuery();
            while(rs.next()){
                String name = rs.getString("teachername");
                String joindate = rs.getString("joindate_str");
                String info = rs.getString("info");
                System.out.println(name+":"+joindate+":"+info);
            }
        } catch (SQLException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }finally{
            closeAll();
        }
    }
    /**
     * 查找老师(分页)
     */
    public void selTeachers(int pageindex,int pagesize){
        conn = getConn();
        String sql = "select * from(select rownum num, teacherid, teachername,"+
        "to_char(joindate,'yyyy-mm-dd hh24:mi:ss') as joindate_str,info from teacher where rownum<=? order by teacherid desc) ss where num>?";
        try {
            pstmt = conn.prepareStatement(sql);
            pstmt.setInt(1, pageindex*pagesize);
            pstmt.setInt(2, (pageindex-1)*pagesize);
            rs = pstmt.executeQuery();
            while(rs.next()){
                String name = rs.getString("teachername");
                String joindate = rs.getString("joindate_str");
                String info = rs.getString("info");

                System.out.println(name+":"+joindate+":"+info);
            }
        } catch (SQLException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }finally{
            closeAll();
        }
    }
    /**
     * 增加老师
     */
    public void insertTeacher(){
        conn = getConn();
        String sql = "insert into teacher (teacherid,teachername,joindate,info) values(seq_teacher.nextval,?,to_date(?,'yyyy-mm-dd'),?)";
        try {
            pstmt = conn.prepareStatement(sql);
            pstmt.setString(1, "呵呵1");
            pstmt.setString(2, "2016-9-9");
            pstmt.setString(3, "hehehehehe");
            int result = pstmt.executeUpdate();
            System.out.println(result);
        } catch (SQLException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
    }
    /**
     * 关闭资源
     */
    public void closeAll(){
            try {
                if(rs!=null){
                    rs.close();
                }
                if(pstmt!=null){
                    pstmt.close();
                }
                if(conn!=null){
                    conn.close();
                }
            } catch (SQLException e) {
                // TODO Auto-generated catch block
                e.printStackTrace();
            }
    }
    //测试
    public static void main(String[] args) {
        jdbcTest t = new jdbcTest();
        t.selTeachers(2, 2);
    }
}

到这里就完成了oracle jdbc的入门程序