persondao.java

来自「java源代码」· Java 代码 · 共 46 行

package com.soft136.struts.DAO;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import oracle.jdbc.rowset.OracleCachedRowSet;

public class PersonDAO {

	public static Connection getConnection() throws ClassNotFoundException,
			SQLException {
		Connection conn = null;
		Class.forName("oracle.jdbc.driver.OracleDriver");
		String url = "jdbc:oracle:thin:@192.168.1.250:1521:COACH";
		conn = DriverManager.getConnection(url, "KIND", "KIND");
		return conn;
	}

	public OracleCachedRowSet getData() throws ClassNotFoundException,
			SQLException {

		Connection conn = null;
		PreparedStatement ps = null;
		ResultSet rs = null;
		try {
			conn = getConnection();
			ps = conn
					.prepareStatement("SELECT ID,PHONE,NAME,TIME,CONTENT,RESOLVED FROM APPEALS");
			rs = ps.executeQuery();
			OracleCachedRowSet ocs = new OracleCachedRowSet();
			ocs.populate(rs);
			return ocs;

		} finally {
			if (conn != null) {
				conn.close();
			}
			if (ps != null) {
				ps.close();
			}
		}
	}
}