lab8.java

JdbcUtil

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

public class Lab8
{
	public static void main(String[] args){
	  if(args.length!=1){
	    System.out.println(
		  "Usage: java com.jdbclab.Lab8 table-name");
		return;
	  }
	  Connection con = null;
	  PreparedStatement ps = null;
	  ResultSet rs = null;
	  String table = args[0];
	  String sql = "select * from "+table;
	  try{
	    con = JdbcUtil.getConnection();
		ps = con.prepareStatement(sql);
		rs = ps.executeQuery();
		JdbcUtil.printRs(rs);
        /*ResultSetMetaData meta = rs.getMetaData();
        int num = meta.getColumnCount();
		StringBuffer sb = new StringBuffer();
		sb.append("------- resultSet ---------");
		while(rs.next()){
		  for(int i=1;i<=num;i++){
		    sb.append(meta.getColumnName(i)+"=");
			sb.append(rs.getString(i)+"  ");
			sb.append(meta.getColumnTypeName(i)+"\n");
		  }
		  sb.append("=================\n");
		}
	    System.out.println(sb.toString());*/
	  }catch(Exception e){
	    e.printStackTrace();
	  }finally{
	    JdbcUtil.release(rs,ps,con);
	  }
	}
}