db.java

trainticket 运行平台 Windows XP

package database;
import java.sql.*;
import java.util.*;

//连接数据库,实现数据处理层
public class DB
{
	Connection con=null;
	Statement stmt=null;
	//ResultSet rs=null;
	//ResultSetMetaData rsmd=null;
	String connectString=null;
	
	//在构造方法中注册Access驱动程序，创建连接对象
	public DB()
	{
		try
		{
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
			connectString="jdbc:odbc:train";
			con=DriverManager.getConnection(connectString);
			System.out.println("连接数据库成功...");
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}	
	}
	
	//返回连接对象
	public Connection getConnection()
	{
		return(con);	
	} 
	
	//返回Statement
	public Statement getStatement()
	{
		try
		{
			stmt=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
			return(stmt);	
		}
		catch(Exception e)
		{
			return(null);	
		}
	}
}