lab7.java

JdbcUtil

package com.jdbclab;
import java.sql.*;

public class Lab7
{
	public static void main(String[] args){
	   Connection con = null;
	   PreparedStatement ps = null;
	   ResultSet rs = null;
	   String sql = 
		   "select * from t_sd0709_test where id>?";
	   try{
	     con = JdbcUtil.getConnection();
		
		 ps = con.prepareStatement(sql);
		 ps.setInt(1,0);
		 rs = ps.executeQuery();

		 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){}
	}
}