数据库的相关操作：如连接、查询、添加、删除、修改、分页显示_JSP技巧

数据库的相关操作：如连接、查询、添加、删除、修改、分页显示

package study.database;

/**

* <p>Title: JSP模式学习</p>

* <p>Description: 数据库的相关操作：如连接、查询、添加、删除、修改</p>

* <p>Copyright: Copyright (c) 2004</p>

* <p>Company: </p>

* @author 李艳生

* @version 1.0

*/

import java.sql.*;

import java.io.*;

import java.util.*;

public class Operation {

//数据库驱动程序

private String strDriver = "";

//数据库连接字符串

private String strURL = "";

//数据库用户名

private String username = "";

//数据库密码

private String password = "";

private Connection conn = null;

private Statement stmt = null;

ResultSet rs = null;

/** 读到数据库配置信息

*/

private void loadProp(){

InputStream is = getClass().getResourceAsStream("/setup.txt");

Properties props = new Properties();

try{

props.load(is);

}catch(Exception e){

System.err.println("不能读取配置文件. 请确保setup.txt在classes指定的路径中");

}

Enumeration propNames = props.propertyNames();

while (propNames.hasMoreElements()) {

String name = (String) propNames.nextElement();

if (name.endsWith(".driver")) {

String poolName = name.substring(0, name.lastIndexOf("."));

strDriver = props.getProperty(poolName + ".driver");

strURL = props.getProperty(poolName + ".url");

username = props.getProperty(poolName + ".user");