databaseconnection.java~1~

本系统图书馆管理系统

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.SQLException;

public class DatabaseConnection {

        public static Connection connection ;
        public static Statement statement ;

        public DatabaseConnection()
        {
                try
                {
                        Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); // 实例化JDBC-ODBC桥的驱动
                String url = "jdbc:odbc:LibrarySystem"; // 设置连接字符串
                connection = DriverManager.getConnection(url); // 连接数据库
                // 创建Statement接口对象
                statement = connection.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
                                                   ResultSet.CONCUR_UPDATABLE);

                }

                catch(Exception e)
                {
                        System.out.println(e);
                }
        }
}