jdbcutil.java

基于java的物资管理系统非常好用啊相当简单

package com.university.goodsmanager.dao.util;
import java.sql.*;
public class JdbcUtil {
	static {
		try {
			Class.forName("oracle.jdbc.driver.OracleDriver");
		} catch (ClassNotFoundException e) {
			e.printStackTrace();
		}
	}
	public static Connection getConnection() throws Exception{
		Connection con=null;
		con=DriverManager.getConnection("jdbc:oracle:thin:@192.168.0.23:1521:tarena","asd0701","asd0701");
		return con;
	}
	
	public static void close(ResultSet rs,Statement stmt,Connection con){
		try {
			if(rs!=null)rs.close();
			if(stmt!=null)stmt.close();
			if(con!=null)con.close();
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}
	public static void close(Object o){
		try {
			if(o!=null){
				if(o instanceof ResultSet){
					((ResultSet)o).close();
				}else if(o instanceof Statement){
					((Statement)o).close();
				}else if(o instanceof Connection){
					((Connection)o).close();
				}
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}
}