?? databaseconnection.java
字號:
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);
}
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -