|
马上注册,结交更多好友,享用更多功能,让你轻松玩转社区。
您需要 登录 才可以下载或查看,没有账号?注册账号
×
在用友NC及IUFO二次开发中,如何才能在程序中获取到中间件设置的数据源呢。原设置界面如下图所示:
取数据源代码:
1、引入包:import nc.vo.iufo.pub.DataManageObjectIufo;
2、写一个类继承自:public class IufoZD extends DataManageObjectIufo
3、方法中直接调用:
Connection con = null;
con = getConnection();
4、指定数据源:DataManageObjectIufo.IUFO_DATASOURCE
/*
* 测试 数据连接
*/
public String t1() throws java.sql.SQLException {
String dbType = GlobalValue.DATABASE_TYPE;
String sql = "";
if (dbType.equalsIgnoreCase(IDatabaseType.DATABASE_ORACLE)) {
sql = "select unit_name from iufo_unit_info t";
} else if (dbType.equalsIgnoreCase(IDatabaseType.DATABASE_SQLSERVER)) {
sql = "select unit_name from iufo_unit_info t";
} else if (dbType.equalsIgnoreCase(IDatabaseType.DATABASE_DB2)) {
sql = "select unit_name from iufo_unit_info t";
}
Connection con = null;
Statement stmt = null;
ResultSet rs = null;
try {
con = getConnection();
stmt = con.createStatement();
rs = stmt.executeQuery(sql);
String strNameValue = "读到IUFO表数据:";
while (rs.next()) {
strNameValue = strNameValue + " ; "
+ rs.getString("unit_name").toString();
}
return strNameValue;
} finally {
if (rs != null) {
try {
rs.close();
} catch (Exception e) {
}
}
if (stmt != null) {
try {
stmt.close();
} catch (Exception e) {
}
}
if (con != null) {
try {
con.close();
} catch (Exception e) {
}
}
}
} |
|