dbcon.java

jsp+javabean的一个在线考试系统的设计（包含教学文档）

package doc;

import java.sql.*;

public class Dbcon(){	
    private static final DRIVER="sun.jdbc.odbc.JdbcOdbcDriver";
	private static final USERNAME="xiaoyan";
	private static final PASSWORD="";
	
	private Connection con=null;
	private Statement st=null;
	private ResultSet rs=null;
	
	
	public Dbcon(){
		try{
			Driver Driverdbcon=(Driver)Class.forName(DRIVER).newInstance();
		}
		catch (ClassNotFoundException e) {
            System.err.println("JinghuaConn():" + e.toString());
        }
        catch (Exception e) {
            System.err.println("JinghuaConn():" + e.toString());
        }

	}
	
	public Connection getCon(){
		try {

            con = DriverManager.getConnection("jdbc:odbc:grad",USERNAME,PASSWORD);

        }

        catch (Exception e) {
            con = null;
        }

        return con;
	}
	
	 public void closeStmt() {
        try {
            stmt.close();
        }
        catch (SQLException e) {
            e.printStackTrace();
        }
    }

    public void closeConn() {
        try {
            con.close();
        }
        catch (SQLException e) {
            e.printStackTrace();
        }
    }

}