database.java

是适合于使用的管理系统 可以在现实中使用

package mysiloer;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import javax.swing.JOptionPane;

/**
 * <p>Title: MySiloer</p>
 * <p>Description: </p>
 * <p>Copyright: Copyright (c) 2005</p>
 * <p>Company: yskey</p>
 * @author 杨涛
 * @version 1.0
 */

public class DataBase {

  public Connection connection;

  public DataBase() {
    try{
    Class.forName(Type.DRIVERNAME).newInstance();
    connection = DriverManager.getConnection(Type.URL, Type.USERNAME, Type.PWD);
    System.out.print("OK");     }
    catch(ClassNotFoundException e){
      System.out.println("找不到类:  "+ Type.DRIVERNAME);
    }
    catch(SQLException ex1){
      JOptionPane.showMessageDialog(null, "数据库连接失败！！！");
      System.out.println("连接数据库失败:  "+ex1.toString());
      System.exit(1);
    }
    catch(Exception ex){
      System.out.println(ex.toString());
    }
  }
  public Connection getConnection(){
    return connection;
  }
}