dbconn.java

在线考试系统的具体实现 利用JSP+myeclipse6.6+tomcat5。5.27

package org.mmxbb.exam.util;

import java.sql.*;
import javax.naming.Context;
import javax.naming.InitialContext;
import javax.sql.DataSource;

public class DBConn {
  //DataSource ds = null;
  Connection conn = null;

  public DBConn() {
  }

  /**
   * <li>get the connection from lookup DataSource
   * @return Connection
   */
  public Connection getConnection() {
    try {
    	String url = "jdbc:mysql://localhost:3306/exam?useUnicode=true&amp;characterEncoding=utf-8";
    	String driver = "com.mysql.jdbc.Driver" ; 
    	Class.forName(driver);
    	conn = DriverManager.getConnection(url,"root","123");
//   	DriverManager = conn.createStatement();
//    	 Context initCtx = new InitialContext();
//    	 Context envCtx = (Context)initCtx.lookup("java:comp/env");
//       ds = (DataSource)envCtx.lookup("jdbc/exam");
//       conn=ds.getConnection();
      	
    } catch (Exception e) {
      System.err.println("getConnection error: " + e);
      return null;
    }
    return conn;
  }

    
  /**
   * return connection to pool
   */
  public void close() {
    try {
      conn.close();
    } catch (Exception e) {
      e.printStackTrace();
    }
  }
  
  public static void main(String args[])
  {
	  String sql ="" ;
	  DBConn db = new DBConn();
	  db.getConnection();
	  System.out.println("connectted");
  }
}