businesstypedao.java

教你一天学会struts

package com.soft136.strutsoneday.dao;

import java.sql.*;

import javax.sql.rowset.CachedRowSet;
import com.sun.rowset.CachedRowSetImpl;

public class BusinessTypeDAO {

	public CachedRowSet getBusinessType() throws SQLException,
			ClassNotFoundException {
		Connection conn = null;
		PreparedStatement ps = null;
		ResultSet rs = null;
		try {
			Class.forName("com.mysql.jdbc.Driver");
			conn = DriverManager.getConnection(
					"jdbc:mysql://localhost:3306/soft136", "root", "123456");
			ps = conn.prepareStatement("SELECT ID,NAME FROM BUSINESSTYPE");
			rs = ps.executeQuery();
			CachedRowSet crs = new CachedRowSetImpl();
			crs.populate(rs);
			return crs;
		} finally {
			if (ps != null) {
				ps.close();
			}
			if (conn != null) {
				conn.close();
			}
		}
	}

	public CachedRowSet getBusinessTypeDetail(int businessTypeId)
			throws SQLException, ClassNotFoundException {
		Connection conn = null;
		PreparedStatement ps = null;
		ResultSet rs = null;
		try {
			Class.forName("com.mysql.jdbc.Driver");
			conn = DriverManager.getConnection(
					"jdbc:mysql://localhost:3306/soft136", "root", "123456");
			if (businessTypeId == 0) {
				ps = conn
						.prepareStatement("SELECT DETAILID,BUSINESSTYPEID,DETAILNAME FROM BUSINESSTYPEDETAIL");
			} else {
				ps = conn
						.prepareStatement("SELECT DETAILID,BUSINESSTYPEID,DETAILNAME FROM BUSINESSTYPEDETAIL WHERE BUSINESSTYPEID=?");
				ps.setInt(1, businessTypeId);
			}
			rs = ps.executeQuery();
			CachedRowSet crs = new CachedRowSetImpl();
			crs.populate(rs);
			return crs;
		} finally {
			if (ps != null) {
				ps.close();
			}
			if (conn != null) {
				conn.close();
			}
		}
	}

}