dbmanager.java

一个仿造淘宝的jsp网站。功能比较完善

package com.jc.taobao.gjj.db;

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

public class DBManager {
	private Connection con;

	private Statement stat;

	private ResultSet rs;

	public DBManager() {
		con = DBAccess.getCon();
	}

	public ResultSet getRs(String sql) {//返回查询结果
		try {
			stat = con.createStatement();
			rs = stat.executeQuery(sql);
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return rs;
	}

	public int updb(String sql) {//返回增删改结果
		int count = 0;
		try {
			stat = con.createStatement();
			count = stat.executeUpdate(sql);
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return count;
	}

	public void destory() {//关闭
		try {
			con.close();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
}