package com.itsv.gankao.common;
import java.sql.*;

public abstract class JspBean {
  public JspBean() {
  }

  WebSiteSrc property = new WebSiteSrc();

  //private final String url="jdbc:microsoft:sqlserver://192.168.0.2:1433;DatabaseName=cpsystem";
  private final String url= property.DBConnection_Test;
  private final String user=property.DBUser_Test;
  private final String password = property.DBPassword_Test;

  public Connection conn_ = null;

  protected final void initDataBase(){
    try {
      Class.forName(property.DBDriver_Test).newInstance();
      conn_ = DriverManager.getConnection(url, user, password);
    }
    catch (Exception e) {
      e.printStackTrace();
    }
  }

  protected final void closeConn()
      throws java.sql.SQLException{
    if (conn_ != null){
        conn_.close();
        conn_ = null;
    }
  }

}