dataconnect.java

酒店信息管理系统包括客户的信息

package hotelinformationmanagesystem;

import java.sql.ResultSet;
import java.io.IOException;
import java.sql.SQLException;
import java.sql.Statement;
import java.sql.Connection;
import java.sql.DriverManager;

/**
 * <p>Title: 酒店信息管理系统</p>
 *
 * <p>Description: The Management Information System of Hotel</p>
 *
 * <p>Copyright: Copyright (c) 2007</p>
 *
 * <p>Company: JSP</p>
 *
 * @author 江世澎
 * @version 1.0
 */
public class DataConnect {

    public static String url = "JDBC:ODBC:HIMS";

    public static Connection con1;
    public static Connection con2;
    public static Connection con3;
    public static Connection con4;

    public static String sql1;
    public static String sql2;
    public static String sql3;
    public static String sql4;

    public static Statement stmt1;
    public static Statement stmt2;
    public static Statement stmt3;
    public static Statement stmt4;

    public DataConnect() {
        try {
            jbInit();
        } catch (Exception ex) {
            ex.printStackTrace();
        }
    }

    public void Connnect() {
        try {
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); //装入驱动程序
        } catch (java.lang.ClassNotFoundException e) {
            System.err.println("ClassNotFoundException");
            System.err.println(e.getMessage());
        }
    }

    private void jbInit() throws Exception {
    }

}