database.java

JSP开发的学习系统

package grad.util;
/**
 * <p>Title:数据库连接专用包 </p>
 * @version 1.0
 */
import java.sql.*;
public class DataBase {
  public Connection conn;
  public DataBase() {
      this.connect();
  }
  public boolean connect(){

      /*   try{//  连接mysql数据库
           Class.forName("org.gjt.mm.mysql.Driver").newInstance();
           String url ="jdbc:mysql://localhost/teachonline?user=wxy&useUnicode=true&characterEncoding=8859_1";
           conn=DriverManager.getConnection(url);
           stmt = conn.createStatement ();
          }catch(Exception ee){
           System.out.println("connect db error:"+ee.getMessage());
           return false;
          }
         */
        /*//利用tomcat连接池配置，连接sql server数据库
         try{
          ctx = new InitialContext();
           if (ctx == null)
             throw new Exception("没有匹配的上下文环境");
           ds = (DataSource) ctx.lookup("java:comp/env/jdbc/SqlServermidp");
           if (ds == null)
             throw new Exception("没有匹配的数据库");
           conn = ds.getConnection();
           stmt=conn.createStatement();
         }catch(Exception ee){
          System.out.println("connect db error:"+ee.getMessage());
          return false;
         }
         */
      try{//用jdbc直接连接sqlserver数据库
           Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
           String url="jdbc:microsoft:sqlserver://localhost:1305;DatabaseName=teachonline";
           String user="sa";
           String password="";
            conn= DriverManager.getConnection(url,user,password);
           }catch(Exception ee){
             System.out.println("connect db error:"+ee.getMessage());
            return false;
          }
         return true;
       }
}