jdbc对oracle数据库操作

jdbc连接数据源 对数据可进行相应的操作

第一步：配置好jdb数据源

public class JdbcSuccess {  
    //驱动，URL，用户名，密码  
    private static final String driver = "oracle.jdbc.driver.OracleDriver";  
    private static final String url = "jdbc:oracle:thin:@localhost:1521:orcl";  
    private static final String username = "chen";  
    private static final String password = "123456";  
  
    public static Connection getConnection() {  
        Connection connection = null;  
        try {  
            // 加 载驱动  
            Class.forName(driver);  
            // 通过驱动管理类获取数据库连接  
            connection = DriverManager.getConnection(url, username, password);  
            // 关闭连接  
            //connection.close();  
        } catch (ClassNotFoundException e) {  
            e.printStackTrace();  
        } catch (Exception e) {  
            e.printStackTrace();  
        }  
        return connection;  
    }  
  
	public static void release(Connection connection, Statement stm, ResultSet rs) {
		  if(null!=rs){  
	            try {  
	                rs.close();  
	            } catch (SQLException e) {  
	                e.printStackTrace();  
	            }finally{  
	                rs=null;  
	            }  
	            if(null!=stm){  
	                try {  
	                	stm.close();  
	                } catch (SQLException e) {  
	                    e.printStackTrace();  
	                }finally{  
	                	stm=null;  
	                }  
	            }  
	            if(null!=connection){  
	                try {  
	                	connection.close();  
	                } catch (SQLException e) {  
	                    e.printStackTrace();  
	                }finally{  
	                	connection=null;  
	                }  
	            }  
	        }  
		
	}  
	
	 // 测试oracle连接是否成功  
    public static void main(String[] args) {  
        Connection connection = JdbcSuccess.getConnection();  
        if (connection != null) {  
            System.out.println("连接oracle数据库成功:" + connection);  
        } else {  
            System.out.println("连接oracle数据库失败!!!");  
        }  
  
    }


}  

配置完成后 可进行测试 查看连接成功

第二步：编写测试类 进行数据可操作

public void myOracleUtilTest(){  
        Connection connection=JdbcSuccess.getConnection();  
        Statement stm=null;  
        ResultSet rs=null;  
        try {  
            stm= connection.createStatement();  
            String sql = 
            "数据库操作";
            rs=stm.executeQuery(sql);
            Integer klgfs = null;
            while(rs.next()){
            	klgfs = rs.getInt(1);
            	System.out.println(klgfs);
            }
          
    }