java连接oracle的简单实例

连接oracle的时候，要导入oracle驱动的jar包。

连接的时候，有statement和preparedstatement两种，从代码中可以看出不同。

example:

package com.jdbc.oracle;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class cn1 {

    /**
     * @param args
     */
    public static void main(String[] args) {
        Connection conn = null;
        //Statement stmt = null;
        PreparedStatement ps = null;
        ResultSet rs = null;
        int rowcount = 0;
        
        try {
            //注册数据库驱动程序为Oracle驱动
            Class.forName("oracle.jdbc.driver.OracleDriver");
        } catch (ClassNotFoundException e) {
            //这样写是为了方便调试程序，出错打印mydb()就知道在什么地方出错了
            e.printStackTrace();
            System.err.println("mydb(): " + e.getMessage());
        }
        
        try {
            conn = DriverManager.getConnection("jdbc:oracle:thin:@172.21.1.11:1524:vasd", "chnlmgr", "chnlmgr");
        } catch (SQLException e) {
            System.err.println("conn:"+e.getMessage());
        }
        
        if (conn != null) {
            System.out.println("connection successful");
        } else {
            System.out.println("connection failure");
        }
        
        /*
        try {
            stmt = conn.createStatement();
        } catch (SQLException e) {
            e.printStackTrace();
        }*/
        
        try {
            //rs = stmt.executeQuery("select * from PO_USER_BASE_INFO where username='guojing'");
            StringBuffer sql = new StringBuffer();
            sql.append("select * from PO_USER_BASE_INFO where ");
            sql.append("username = ?");
            ps = conn.prepareStatement(sql.toString());
            ps.setString(1, "guojing");
            rs = ps.executeQuery();
            while (rs.next()) {
                System.out.println(rs.getString("USERNAME"));
            }
            
            rs.close();
            //stmt.close();
            ps.close();
            conn.close();
        } catch (SQLException e) {
            e.printStackTrace();
        }
        
    }
}