package com.sys.datagrid;import java.io.*;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import com.sys.util.db.DBSet;
import com.sys.util.db.ExecSQL;public class Test { private void getPieDataSet() {
String sql ="select to_char('未批准') as 项目状态, to_char('真上市') as 投资主体,to_char('0默认是零')||' ' as 财务类别 from p_project p, cls_proclass l, sys_corp s , erp_unit eu,cls_jsfw cj where p.project_id = l.proclass_id and eu.corp_id=s.corp_id and eu.corp_id=p.corp_id and cj.jsfw_id=l.proclass_id";
DBSet db = new DBSet();
Connection conn = db.getDBConnect();
ExecSQL esql = new ExecSQL(conn);
ResultSet rs = esql.getResultSetQuery(sql);
try {
while (rs.next()) {
System.out.println("vvvvvvvvvvvvvvvvvvvvvvvvvvv");
String vs = rs.getString(1);
String vs1=rs.getString(2);
String vs2=rs.getString(3);
System.out.println("vs"+vs);
System.out.println("vs1"+vs1);
System.out.println("vs2"+vs2);
System.out.println("vvvvvvvvvvvvvvvvvvvvvvvvvvv");
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
public static void main(String args[]){
Test t = new Test();
t.getPieDataSet();
}}
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import com.sys.util.db.DBSet;
import com.sys.util.db.ExecSQL;public class Test { private void getPieDataSet() {
String sql ="select to_char('未批准') as 项目状态, to_char('真上市') as 投资主体,to_char('0默认是零')||' ' as 财务类别 from p_project p, cls_proclass l, sys_corp s , erp_unit eu,cls_jsfw cj where p.project_id = l.proclass_id and eu.corp_id=s.corp_id and eu.corp_id=p.corp_id and cj.jsfw_id=l.proclass_id";
DBSet db = new DBSet();
Connection conn = db.getDBConnect();
ExecSQL esql = new ExecSQL(conn);
ResultSet rs = esql.getResultSetQuery(sql);
try {
while (rs.next()) {
System.out.println("vvvvvvvvvvvvvvvvvvvvvvvvvvv");
String vs = rs.getString(1);
String vs1=rs.getString(2);
String vs2=rs.getString(3);
System.out.println("vs"+vs);
System.out.println("vs1"+vs1);
System.out.println("vs2"+vs2);
System.out.println("vvvvvvvvvvvvvvvvvvvvvvvvvvv");
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
public static void main(String args[]){
Test t = new Test();
t.getPieDataSet();
}}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货