databaseconnection.java~6~

本系统图书馆管理系统

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);
                }
        }
}