db_conn.java

在线考试系统

package com.gton.bean.util;

import java.io.PrintWriter;
import java.sql.*;

public class DB_Conn {
	private  Connection conn=null;                          //数据库连接对象
    public Statement sm=null;                               //数据库语句对象
    private PrintWriter out = null;

   // private String dbUrl =  "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=exam";
   // private String dbUser="examuser";
    //private String dbPwd="user";
    // 建立数据库连接
    public void ConnectDB()
    {
    	 try 
    	 {
    		 Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
    		 conn=DriverManager.getConnection("jdbc:odbc:Exam");  //获得数据库连接
    		// Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
    		// conn=DriverManager.getConnection(dbUrl,dbUser,dbPwd);
        	 sm=conn.createStatement();
         } 
    	 catch(Exception e)
         {
    		 e.printStackTrace();
        	 out.print("数据库连接失败!");
    	 }
    }

    public void CloseDB()
    {
    	try {
			if (sm != null) 
			{
				sm.close();
			}
			if (conn != null) 
			{
			conn.close();
    	    }
		}
    	catch (SQLException SqlE) 
		{
			SqlE.printStackTrace();
			out.print("数据库关闭失败！");
		}

   }
}