jdbcutil.java

航空售票系统的代码

package com.tarena.abs.dao;
import java.sql.*;

public class JdbcUtil{
	//加载驱动，创建连接，释放资源
	private static final String driver = "com.mysql.jdbc.Driver";
	private static final String url="jdbc:mysql://127.0.0.1:3306/zk";
	private static final String username="root";
	private static final String pwd="root";


	static{
		try{
			Class.forName(driver);
		}catch(Exception e){
			e.printStackTrace();
		}
	}

	public static Connection getConnection(){
		Connection con = null;
		try{
			con = DriverManager.getConnection(url,username,pwd);
		}catch(Exception e){
			e.printStackTrace();
		}
		return con;
	}

	public static void release(ResultSet rs,Statement stmt,Connection con){

		try{if(rs!=null)rs.close();}catch(Exception e){e.printStackTrace();}
		try{if(stmt!=null)stmt.close();}catch(Exception e){e.printStackTrace();}
		try{if(con!=null)con.close();}catch(Exception e){e.printStackTrace();}
				if(rs==null)System.out.println("rs==null"+"util");
	}
	public static void release(Object o){
	try{
		if(o instanceof ResultSet){
			((ResultSet)o).close();
		}else if(o instanceof Statement){
			((Statement)o).close();
		}else if(o instanceof Connection){
			((Connection)o).close();
		}
	}catch(Exception e){
		e.printStackTrace();
	}
	}
	public static void printRs(ResultSet rs){
		if(rs==null) return;
	try{
		ResultSetMetaData md = rs.getMetaData();
		int colmun = md.getColumnCount();
		StringBuffer sb = new StringBuffer();
		for(int i=1; i<=colmun; i++){
			sb.append(md.getColumnName(i)+"\t");
		}
		sb.append("\n");
		sb.append("-----------------------------\n");

			while(rs.next()){
				for(int i=1; i<=colmun; i++){
					sb.append(rs.getString(i)+"\t");
				}
				sb.append("\n");
			}
			System.out.println(sb.toString());
	}catch(Exception e){
		e.printStackTrace();
	}
	}
}