databasebean.java

简易商品管理系统代码

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);
	}
}