package databaseoperate;

/**
 * <p>Title: </p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2005</p>
 *
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */
/////////////////////////////////////////////////////////
//connect to the database of LibrarySystem
/////////////////////////////////////////////////////////
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import java.sql.Connection;
import java.sql.CallableStatement;
//import java.sql.SQLException;
import java.util.*;
import java.net.URL;

public class DatabaseConnection {

        public static Connection connection=null ;
        public static Statement statement=null ;
        public static CallableStatement callableStatement=null;


        public DatabaseConnection()
        {
                try
                {
                        Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); // 實例化JDBC-ODBC橋的驅動
                        String url = "jdbc:odbc:LibraryDatabase"; // 設置連接字符串
                        connection = DriverManager.getConnection(url); // 連接數據庫
                                                                          // 創建Statement接口對象
                        statement = connection.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
                                                   ResultSet.CONCUR_UPDATABLE);
                }
                catch(Exception e)
                {
                        System.out.println(e);
                }
        }
}