处理JDBC返回值类-JdbcExecute.java(请看上一篇)
来源:互联网 发布:linux计划任务每5分钟 编辑:程序博客网 时间:2024/04/28 03:51
package ht.chart.fusioncharts.dao;import ht.chart.utils.ConvertUtil;import java.sql.Connection;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;import java.util.List;import java.util.Map;public class JdbcExecute {/** * @param args */public static void main(String[] args) {// TODO Auto-generated method stubString sql = "SELECT MAX(CASE WHEN a.COMMONDATAATTRCODE = 'departname' THEN B.COMMONDATAVALUE ELSE '' END) as departname, MAX( CASE WHEN a.COMMONDATAATTRCODE = 'count' THEN B.COMMONDATAVALUE ELSE '' END) as count,B.COMMONDATAVALUENO FROM COMMONDATAATTR a JOIN COMMONDATAVALUE b ON A.COMMONDATAATTRID = B.COMMONDATAATTRID group by B.COMMONDATAVALUENO";JdbcExecute exec = new JdbcExecute();List<Map> lst = exec.getResultList(sql);for(Map map : lst){System.out.println (map.get("DEPARTNAME"));}System.out.println(lst);}public List<Map> getResultList(String sqlText) {Statement st = null;ResultSet rs = null;Connection conn = null;List rlist = null;try {conn = JdbcConnecton.getConnection();st = conn.createStatement();rs = st.executeQuery(sqlText);rlist = ConvertUtil.rs2ListMap(rs);} catch (Exception e) {// TODO Auto-generated catch blocke.printStackTrace();} finally {JdbcConnecton.close(conn, st, rs);}return rlist;}public Map getResultMap (String sqlText) throws SQLException{Statement st = null;ResultSet rs = null;Connection conn = null;Map map = null;try {conn = JdbcConnecton.getConnection();st = conn.createStatement();rs = st.executeQuery(sqlText);map = ConvertUtil.rs2Map(rs); } catch (ClassNotFoundException e){e.printStackTrace(); }finally {JdbcConnecton.close(conn, st, rs); }return map;}}