getdataformstring.java

来自「用JSP JAVA 做的 系统 只是初来扎到还望西黄！别乱来哦！」· Java 代码 · 共 82 行

package com.chis.util;

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

import com.stframe.form.DataForm;

/**
 * 处理fck不能获取getobject（）的问题
 * @author Administrator
 *
 */
public class GetDataFormString {
	public String query = null; 

	public ResultSet rs;
	
	public ResultSetMetaData rsmd;

	
	public DataForm getdf(Connection con,String id,String type) {

		query = "select * from "+type+" where ID='" + id + "'";


		try {
			Statement sm = con.createStatement(); // 创建Statement
			rs = sm.executeQuery(query); // 使用Statment对象执行语句
		} catch (Exception e) {
			e.printStackTrace();
		}

		DataForm newdata = new DataForm(type);
		try {
			rsmd = rs.getMetaData();
			int numCols = rsmd.getColumnCount();
			boolean flag = rs.next();
			while (flag) {
				if(type.equals("SYS_NOTICE")){
					newdata.set("ID", rs.getString(1));
					newdata.set("CORP_ID", rs.getString(2));
					newdata.set("ISSUE_USER_NAME", rs.getString(3));
					newdata.set("ISSUE_DATE", rs.getString(4));
					newdata.set("TITLE", rs.getString(5));
					newdata.set("CONTENT", rs.getString(6));
					newdata.set("REMARKS", rs.getString(7));
				}else if(type.equals("SYS_UPLOAD_REPORT")){
					newdata.set("ID", rs.getString(1));
					newdata.set("CORP_ID", rs.getString(2));
					newdata.set("UPLOAD_USER_ID", rs.getString(3));
					newdata.set("UPLOAD_DATE", rs.getString(4));
					newdata.set("TITLE", rs.getString(5));
					newdata.set("CONTENT", rs.getString(6));
					newdata.set("FILE_NAME", rs.getString(7));
					newdata.set("PATH", rs.getString(8));
					newdata.set("RECV_USER_ID", rs.getString(9));
					newdata.set("READ_DATE", rs.getString(10));
					newdata.set("STATUS", rs.getString(11));
					newdata.set("REMARKS", rs.getString(12));
				}else if(type.equals("SYS_INFO")){
					newdata.set("ID", rs.getString(1));
					newdata.set("CORP_ID", rs.getString(2));
					newdata.set("ISSUE_USER_NAME", rs.getString(3));
					newdata.set("ISSUE_DATE", rs.getString(4));
					newdata.set("TYPE", rs.getString(5));
					newdata.set("TITLE", rs.getString(6));
					newdata.set("CONTENT", rs.getString(7));
					newdata.set("REMARKS", rs.getString(8));
				}
				flag = rs.next();
			}
		} catch (Exception e) {
			e.printStackTrace();
			System.out.println(e.getMessage());
		}

		return newdata;
	}
}