conndb1.java

《Web程序测试实训教程（Java版）》-徐民鹰-源代码

package com;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;

public class ConnDB1 {
    //The Data Source name is "smis" 
	static String url = "jdbc:odbc:BookStore"; 
	protected static Connection aConnection;
	static Statement aStatement; 
	
	public static void initialize()
	{
		try
 		{   
			// load the jdbc - odbc bridge driver for Windows
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
			// create connection instance     
			aConnection = DriverManager.getConnection(url, "", "");
			// create statement object instance for this connection
			aStatement = aConnection.createStatement();
		}
		catch (ClassNotFoundException e)
			{System.out.println(e);}
		catch (SQLException e)
			{ System.out.println(e);	} 
	}
	
    // close the database connection
	public static void terminate()
	{
		try
 		{ 	// close everything
			aStatement.close();
			aConnection.close();
		}
		catch (SQLException e)
			{ System.out.println(e);	} 
	}

}