connectionpool.java

一个MMORPG手机游戏的服务器端程序源代码

package zsw_mmorpg.server;

import java.util.*;
import java.sql.*;
/**
 * 数据库连接池
 **/
public class ConnectionPool{
  static LinkedList list = new LinkedList();
  static ConnectionPool myself;
  static String url;
  static String user;
  static String password;
  static{
    myself = new ConnectionPool();
    try{
      //Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
      //url="jdbc:microsoft:sqlserver://JIN-4870E54F39C:1433;DatabaseName=abdb";
      Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
      url="jdbc:odbc:shenzhou";
    }
    catch(Exception e)
    {
     e.printStackTrace();
    }
    user="zsw";
    password="zsw";
  }
  private ConnectionPool(){}
  public static ConnectionPool getInstance(){
    return myself;
  }

  synchronized public Connection getConnection(){
    Connection conn = null;
    if(list.size() == 0){
      try{
        conn = DriverManager.getConnection(url, user, password);
      }
      catch(SQLException e){
        e.printStackTrace();
      }
    }
    else{
      conn=(Connection)list.removeFirst();
    }
    return conn;
  }
  synchronized public void releaseConnection(Connection conn){
    if(conn instanceof Connection){
      list.addFirst(conn);
    }
  }
}