oracle入门之jdbc

来源：互联网发布：新版本麦克雷伤害数据编辑：程序博客网时间：2024/06/18 15:02

编程工具：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的入门程序

0 0