src/com/so/system/utils/FnsUtils.java

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

package com.so.system.utils;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

import com.so.utils.DbUtil;


public class FnsUtils {
	
	/**
	 * 测试方法
	 * @param args
	 */
	public static void main(String[] args) {
		List<Map<String, Object>> selectListFromTable = selectTableList("college_name", "sc_college_info");
		for (Map<String, Object> map : selectListFromTable) {
			System.out.println(map.get("id"));
			System.out.println(map.get("college_name"));
			String fieldNameById = getFieldNameById("EF143FC22B9E4BBEBA7CAD6C44A0912C", "college_name", "sc_college_info");
			System.out.println("test:"+fieldNameById);
		}
	}
	
	/**
	 * 根据id 字段名，表名返回字段值
	 * @param id
	 * @param field
	 * @param tableName
	 * @return
	 */
	public static String getFieldNameById(String id,String field,String tableName){
		Connection con = null;
		PreparedStatement pstmt = null;
		ResultSet rs = null;
		String rString = "";
		try {
			con = DbUtil.getDbUtil().getCon();
			StringBuffer stringBuffer = new StringBuffer();
			stringBuffer.append("select "+field);
			stringBuffer.append(" from "+tableName);
			stringBuffer.append(" where id='"+id+"'");
			String sql = stringBuffer.toString();
			System.out.println(sql);
			pstmt=con.prepareStatement(sql);
			rs=pstmt.executeQuery();
			if(rs.next()){
				rString = rs.getString(field);
			}
		}catch (Exception e) {
			e.printStackTrace();
		}finally {
			close(con, pstmt, rs);
		}