condb.java

来自「一个小型的BBS系统」· Java 代码 · 共 45 行

package bean.condb;

import java.sql.*;

public class Condb {
	Connection con;
//	Statement stmt;
//	ResultSet rs;
	public Condb(){
		try{
		Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
		}catch(ClassNotFoundException e){
			System.out.println(e.toString());
		}
	};
	public Connection con(){
		try{
			con = java.sql.DriverManager.getConnection("jdbc:odbc:bbs");
			
		}catch(Exception e){
			System.out.println(e.toString());
		}
		return con;
	}
	public void conclose(){
		try{
			con.close();
		}catch(Exception e){
			System.out.println(e.toString());
		}
	}
/*	public ResultSet Query(){
		String sql="select * from answer";
		
		try{
			stmt = con.createStatement(java.sql.ResultSet.TYPE_SCROLL_INSENSITIVE,java.sql.ResultSet.CONCUR_READ_ONLY);
			rs = stmt.executeQuery(sql);
			
		}catch(SQLException s){
			System.out.println(s.toString());
		}
		return rs;
	}*/
}