处理JDBC返回值类-JdbcExecute.java

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 stub  
        String 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