package com.jdbclab;
import java.sql.*;
public class Lab6
{
	public static void main(String[] args){
	  Connection con = null;
	  Statement stmt = null;
	  ResultSet rs = null;
	  try{
	    //1.加載驅(qū)動
	    //2.獲取連接
	    con = JdbcUtil.getConnection();
		//3.獲取Statement對象
        stmt = con.createStatement();
		//4.操作數(shù)據(jù)庫
        String sql = 
		  "select * from t_sd0709_test where id>0";
		rs = stmt.executeQuery(sql);
        StringBuffer sb = new StringBuffer();
		sb.append("   結(jié)果集  \n");
		while(rs.next()){
		  sb.append("id="+rs.getInt(1)+"  ");
		  sb.append("name="+rs.getString(2)+"\n");
		}
		System.out.println(sb.toString());
		
	  }catch(Exception e){
	    e.printStackTrace();
	  }finally{
		JdbcUtil.release(rs,stmt,con);
	  }
    }
}