jdbcutil.java

电信用户自服务系统

package tarena.netctoss.util;
import java.sql.*;

public class JdbcUtil {
	
	static {
		try {
	//		Class.forName("oracle.jdbc.driver.OracleDriver");
			Class.forName("com.mysql.jdbc.Driver");
		} catch (Exception e) {
			e.printStackTrace();
		}
	}
	
	public static Connection getConnection(){
		Connection con=null;
		try{
			con=DriverManager.getConnection("jdbc:mysql://192.168.0.244:3306/netctoss","root","6585275");
		//	con=DriverManager.getConnection("jdbc:oracle:thin:@127.0.0.1:1521:Lirael","system","manager");
			System.out.println(con);
		}catch(Exception e){
			e.printStackTrace();
		}
		return con;
	}
	
	public static void printRs(ResultSet rs){
		if(rs!=null){
			try{
				ResultSetMetaData rm=rs.getMetaData();
				int num=rm.getColumnCount();
				StringBuffer sb=new StringBuffer();
				for(int i=1;i<=num;i++){
					int size=rm.getColumnDisplaySize(i);
					String value=rm.getColumnName(i);
					if(value==null){
						value="null";
					}
					int b=(size-value.length())/2;
					if(b>0){
						for(int j=0;j<b;j++){
							sb.append(" ");
						}
						sb.append(value);
						for(int j=0;j<b+(size-value.length())%2;j++){
							sb.append(" ");
						}
						if((size-value.length())%2!=0){
							sb.append(" ");
						}
					}else{
						sb.append("========");
					}
				}
				sb.append("\n");
				System.out.println(sb.toString());
				sb.delete(0,sb.capacity());
				while(rs.next()){
					for(int i=1;i<=num;i++){
						int size=rm.getColumnDisplaySize(i);
						String value=rs.getString(i);
						if(value==null){
							value="null";
						}
						int b=(size-value.length())/2;
						if(b>0){
							for(int j=0;j<b;j++){
								sb.append(" ");
							}
							sb.append(value);
							for(int j=0;j<b+(size-value.length())%2;j++){
								sb.append(" ");
							}
							if((size-value.length())%2!=0){
								sb.append(" ");
							}
						}else{
							sb.append("========");
						}
					}
					sb.append("\n");
				}
				System.out.println(sb.toString());
			}catch(Exception e){
				e.printStackTrace();
			}
		}
	}
	
	public static void release(ResultSet rs,Statement stmt,Connection con){
		if(rs!=null){
			try{
				rs.close();
			}catch(Exception e){
				e.printStackTrace();
			}
		}
		if(stmt!=null){
			try{
				stmt.close();
			}catch(Exception e){
				e.printStackTrace();
			}
		}
		if(con!=null){
			try{
				con.close();
			}catch(Exception e){
				e.printStackTrace();
			}
		}
	}
	public static void release(Object o){
		if(o instanceof ResultSet){
			try{
				((ResultSet)o).close();
			}catch(Exception e){
				e.printStackTrace();
			}
		}
		if(o instanceof Statement){
			try{
				((Statement)o).close();
			}catch(Exception e){
				e.printStackTrace();
			}
		}
		if(o instanceof Connection){
			try{
				((Connection)o).close();
			}catch(Exception e){
				e.printStackTrace();
			}
		}
	}
	
}