lab9.java

JdbcUtil

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

public class Lab9
{
	public static void main(String[] args){
	   Connection con = null;
	   ResultSet rs = null;
	   try{
	     con = JdbcUtil.getConnection();
		 DatabaseMetaData md = con.getMetaData();
		 StringBuffer sb = new StringBuffer();
		 sb.append("DB major version:"+
			 md.getDatabaseMajorVersion()+"\n");
		 sb.append("Driver name:"+
			 md.getDriverName()+"\n");
		 System.out.println(sb.toString());
		 String[] types = {"TABLE"};
		 rs = md.getTables(null,null,"%STUDENT%",types);
		 JdbcUtil.printRs(rs);
	   }catch(Exception e){
	     e.printStackTrace();
	   }finally{
	     JdbcUtil.release(rs);
		 JdbcUtil.release(con);
	   }
	
	}
}