conn.java

来自「实现了一些关与股票的功能 希望对大家有一些帮助」· Java 代码 · 共 48 行

package model;

import java.sql.CallableStatement;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
//import oracle.jdbc.OracleDriver;
public class Conn {

	private Connection conn;
	
	public Conn() throws ClassNotFoundException, SQLException {
		this("scott","tiger");
	}

	public Conn(String username, String password) throws ClassNotFoundException, SQLException {
		String classStr = "oracle.jdbc.OracleDriver";
		String urlStr="jdbc:oracle:thin:@localhost:1521:myoracle";
		Class.forName(classStr);
		conn = DriverManager.getConnection(urlStr,username,password);		
	}

	public Connection getConnection(){
		return conn;
	}
	
	public static void close(ResultSet rs,PreparedStatement ps,CallableStatement cs,Statement st,Connection conn) throws SQLException{
		if(rs != null){
			rs.close();
		}
		if(ps != null){
			ps.close();
		}
		if(cs != null){
			cs.close();
		}
		if(st != null){
			st.close();
		}
		if(conn != null){
			conn.close();
		}
	}
	
}