package pw.goyd.db;



import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;



import pw.goyd.game.constant.setting.ServerSetting;



/*

  废弃了 用mybatis代替

  @author StanWind

 

 */

public class DBUtil implements ServerSetting {





// 获取数据库连接

public static Connection getConnection() {

Connection conn = null;

try {

Class.forName("com.mysql.jdbc.Driver");

conn = DriverManager.getConnection("jdbc:mysql://" + M_ADDR + ":"

• M_PORT + "/" + M_DBNAME, M_ROOT, M_PWD);
  
  } catch (ClassNotFoundException e) {
  
  e.printStackTrace();
  
  } catch (SQLException e) {
  
  e.printStackTrace();
  
  }
  
  return conn;
  
  }
  
  
  
  // 关闭所有资源
  
  public static void closeAll(ResultSet rs, Statement stmt, Connection conn) {
  
  try {
  
  if (rs != null)
  
  rs.close();
  
  if (stmt != null)
  
  stmt.close();
  
  if (conn != null)
  
  conn.close();
  
  } catch (SQLException e) {
  
  e.printStackTrace();
  
  }
  
  }
  
  }
  

搜索