database.java

基于JAVA的一个注册系统 最初只是为了公司做演示使用

package net.yefei.cmn.db;
import java.io.*;
import java.sql.*;
/*
* @author ye fei
* @version 1.00, 2003/04/15
* @copyright www.studyjava.com
*/

public class DataBase {
  private static DataBase m_instance;
  final static String SQL_SELECT = "SELECT";
  final static String SQL_UPDATE = "UPDATE";
  final static String SQL_INSERT = "INSERT";
  final static String SQL_DELETE = "DELETE";
  private Connection Connect;
  public DataBase() {

  }

  /*static synchronized public DataBase getInstance()
          {
                  if (m_instance == null)
                  {
                          m_instance = new DataBase();
                  }
                  return m_instance;
          }
*/
        public Connection getConnection()
                  {
                    JDBCManager dbx = new JDBCManager();
              try{
                      dbx.setup(new File("database.xml"));
                      Connect= dbx.getConnection();
                      System.out.println("Database connected successfully");

              }catch(Exception e){
                      e.printStackTrace();
                      return null;
              }
                    return Connect;
                  }
  public  void close(){
     try{

       Connect.close();
System.out.println("Database close successfully");
    }catch(Exception e){

       e.printStackTrace();

            }

  }
}