|
楼主 |
发表于 2014-9-19 12:01:53
|
显示全部楼层
在数据库中执行了,可以查询出数据,并且设置了源码路径了,没有报错。
public static Table xiangmlxsqs(String rowid){
//项目立项申请书
String mssql = "select fid,tfXiangMBH,tfXiangMMC,tfXiangMJL,tfTouZZE,tfJiTBK,tfZiCZJ,tfXiangMLXDBYX,tfXiangMJSDKHX,tfXiangMZYNRHZTMB,tfTouZJHJMX,tfXiaoZCYJZZ,tfCaiWBYJ,tfGongSLDBZYJ,tfBeiZ,tfFuJ from Tchuangxkfxmlxsqs where FID='"+rowid+"'";
HashMap<String,String> sqlMap = new HashMap<String,String>();
sqlMap.put(SQL.DEFAULT_DB_NAME,mssql);
sqlMap.put(DatabaseProduct.MSSQL.name(),mssql);
sqlMap.put(DatabaseProduct.SYBASE.name(),mssql);
return SQL.select(sqlMap,null,"/tedawired/xxgl/data");
}
public static Table xiangmlxsqs2(String tfChuangXKFXMID){
//项目立项申请书
String mssql = "select tfXiangMJDMC,tfJiHKSSJ,tfJiHWCSJ,tfZeRR from txiangmztjdjlcb where tfChuangXKFXMID='"+tfChuangXKFXMID+"'";
System.out.println(mssql);
HashMap<String,String> sqlMap = new HashMap<String,String>();
sqlMap.put(SQL.DEFAULT_DB_NAME,mssql);
sqlMap.put(DatabaseProduct.MSSQL.name(),mssql);
sqlMap.put(DatabaseProduct.SYBASE.name(),mssql);
return SQL.select(sqlMap,null,"/tedawired/xxgl/data");
}
|
|