databasebean.java

来自「JDBC数据库高级编程源代码」· Java 代码 · 共 34 行

package jdbcbook.ch08;

import java.sql.*;

/**
 * 数据库处理Bean
 */
public class DatabaseBean
{
	private static final String user = "product";
	private static final String password = "product";

	// 取得一个数据库的连接
	public static Connection getConnection( ) throws SQLException
	{
		return jdbcbook.pub.db.DatabaseBean.getConnection( user, password );
	}

	// 取得某个表中可应用的主键
	public static int getMaxID( String tablename ) throws SQLException
	{
		Connection conn = getConnection( );
		int nMaxID = jdbcbook.pub.db.DatabaseBean.getMaxID( conn, tablename );
		conn.close();
		return nMaxID;
	}

	// 关闭连接，释放资源
	public static void close( ResultSet rs, Statement st, Connection conn )
	{
		jdbcbook.pub.db.DatabaseBean.close( rs, st, conn );
	}
}