lab6.java

JdbcUtil

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.加载驱动
	    //2.获取连接
	    con = JdbcUtil.getConnection();
		//3.获取Statement对象
        stmt = con.createStatement();
		//4.操作数据库
        String sql = 
		  "select * from t_sd0709_test where id>0";
		rs = stmt.executeQuery(sql);
        StringBuffer sb = new StringBuffer();
		sb.append("   结果集  \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);
	  }
    }
}