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();
  
  
  }
  
  
  }
  
  
  }