java比较一个完美的JDBC数据库访问

一个比较完美的数据库访问示例

package com.jdbc.test;

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

public class PerfectJDBC {

	public static void main(String[] args){
		
		String url ="jdbc:oracle:thin:@192.168.1.101:1521:orcl"; //数据库连接字符串
		String username = "scott"; //数据用户名
		String password = "tiger"; //数据库密码
		Connection con = null;
		Statement stmt = null;
		ResultSet rs=null;
	
		try {
			Class.forName("oracle.jdbc.driver.OracleDriver");
			//new oracle.jdbc.driver.OracleDriver();
			con=DriverManager.getConnection(url,username,password);
			
			stmt= con.createStatement(); //创建语句
			
			rs = stmt.executeQuery("select * from emp"); //结果集游标
			while(rs.next()){
				System.out.println(rs.getString("ename"));
			}
			
		} catch (ClassNotFoundException e) {
			e.printStackTrace(); //log4j 保存错误信息到日记里面
		}catch(SQLException e){
			e.printStackTrace();
		}
		finally{
			try {
				if(con!=null){
					con.close();
					con=null;
				}
				if(stmt!=null){
					stmt.close();
					stmt=null;
				}
				if(rs!=null){
					rs.close();
				}
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}
			
		
	
	}
}