java中的jdbc

package jdbc;

import java.io.IOException;
import java.sql.Connection;
import java.sql.Driver;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Properties;

/*

• 1.硬编码问题(不便于后期维护)

• 2.异常捕获
  */
  public class JDBCDemo02 {
  public static void main(String[] args) {
  Properties pro=new Properties();
  try {
  pro.load(Thread.currentThread().getContextClassLoader().getResourceAsStream(“db.properties”));
  } catch (IOException e) {
  e.printStackTrace();
  }

   //1.加载驱动
   try {
   	Class.forName(pro.getProperty("driver"));
   } catch (ClassNotFoundException e) {
   	e.printStackTrace();
   }
   
   Connection conn=null;
   Statement state=null;
   ResultSet result=null;
   //2.创建连接
   try {
   	conn=DriverManager.getConnection(
   			pro.getProperty("url"), 
   			pro.getProperty("name"), 
   			pro.getProperty("pwd"));
   	//3.创建处理块
   	state=conn.createStatement();
   	//4.准备sql
   	String sql="select deptno,dname,loc from dept";
   	//5.执行sql,接受结果集
   	result=state.executeQuery(sql);
   	//6.处理
   	while(result.next()){
   		System.out.print(result.getObject(1)+"\t");  //字段索引从1开始
   		System.out.print(result.getObject(2)+"\t");  //字段索引从1开始
   		System.out.println(result.getObject(3));  //字段索引从1开始
   	}
   } catch (SQLException e) {
   	e.printStackTrace();
   }finally{
   	//关闭
   	try {
   		if(result!=null){
   		result.close();
   		}
   	} catch (SQLException e) {
   		// TODO Auto-generated catch block
   		e.printStackTrace();
   	}
   	try {
   		if(state!=null){
   			state.close();
   		}
   	} catch (SQLException e) {
   		// TODO Auto-generated catch block
   		e.printStackTrace();
   	}
   	try {
   		if(conn!=null){
   			conn.close();
   		}
   	} catch (SQLException e) {
   		// TODO Auto-generated catch block
   		e.printStackTrace();
   	}
   }
  

  }
  }