...
String sql = "select RMS_BTS.ZH_LABEL,RMS_CELL.ZH_LABEL,RMS_ANTENNA.ZH_LABEL,RMS_BTS.INT_ID,RMS_CELL.RELATED_BTS_JTGF,RMS_CELL.CI,"
+ " RMS_ANTENNA.CELL_CI from RMS_BTS,RMS_CELL,RMS_ANTENNA "
+ " where RMS_ANTENNA.CELL_CI=RMS_CELL.CI "
+ " and RMS_CELL.RELATED_BTS_JTGF=RMS_BTS.INT_ID "
+ " and RMS_BTS.ZH_LABEL= '" + name + "'";...rs = stmt.executeQuery(sql);while(rs.next()){
System.out.println(rs.getString("?"));
System.out.println(rs.getString("?"));
System.out.println(rs.getString("?"));
System.out.println(rs.getInt("?"));
System.out.println(rs.getInt("?"));
System.out.println(rs.getString("?"));
System.out.println(rs.getString("?"));
}while (rs.next()) {
[color=#FFFF00]System.out.println(rs.getString("ZH_LABEL")); System.out.println(rs.getString("ZH_LABEL"));
System.out.println(rs.getString("ZH_LABEL"));
System.out.println(rs.getInt("INT_ID"));
System.out.println(rs.getInt("RELATED_BTS_JTGF")); System.out.println(rs.getString("CI"));
System.out.println(rs.getString("CELL_CI")); // eoms.add(rs.getString("ZH_LABEL"));
}[/color]结果是:
昌平天通苑北二区DCS
昌平天通苑北二区DCS
昌平天通苑北二区DCS
56165981
56165981
12731
12731
昌平天通苑北二区DCS
昌平天通苑北二区DCS
昌平天通苑北二区DCS
56165981
56165981
12732
12732
昌平天通苑北二区DCS
昌平天通苑北二区DCS
昌平天通苑北二区DCS
56165981
56165981
12733
12733从oracle数据库中关联查询的信息如下:
ZH_LABEL ZH_LABEL ZH_LABEL INT_ID RELATED_BTS_JTGF CI CELL_CI
----------- ------------ ----------- --------- ------------------- ----- ----------
昌平天通苑北二区DCS 昌平天通苑北二区DCS1 28 56165981 56165981 12731 12731
昌平天通苑北二区DCS 昌平天通苑北二区DCS2 28 56165981 56165981 12732 12732
昌平天通苑北二区DCS 昌平天通苑北二区DCS3 28 56165981 56165981 12733 12733 问题:
while(rs.next()){
System.out.println(rs.getString("?"));
System.out.println(rs.getString("?"));
System.out.println(rs.getString("?"));
System.out.println(rs.getInt("?"));
System.out.println(rs.getInt("?"));
System.out.println(rs.getString("?"));
System.out.println(rs.getString("?"));
}问号里面怎么写啊,有谁会改改,贴上来,谢谢谢谢!
String sql = "select RMS_BTS.ZH_LABEL,RMS_CELL.ZH_LABEL,RMS_ANTENNA.ZH_LABEL,RMS_BTS.INT_ID,RMS_CELL.RELATED_BTS_JTGF,RMS_CELL.CI,"
+ " RMS_ANTENNA.CELL_CI from RMS_BTS,RMS_CELL,RMS_ANTENNA "
+ " where RMS_ANTENNA.CELL_CI=RMS_CELL.CI "
+ " and RMS_CELL.RELATED_BTS_JTGF=RMS_BTS.INT_ID "
+ " and RMS_BTS.ZH_LABEL= '" + name + "'";...rs = stmt.executeQuery(sql);while(rs.next()){
System.out.println(rs.getString("?"));
System.out.println(rs.getString("?"));
System.out.println(rs.getString("?"));
System.out.println(rs.getInt("?"));
System.out.println(rs.getInt("?"));
System.out.println(rs.getString("?"));
System.out.println(rs.getString("?"));
}while (rs.next()) {
[color=#FFFF00]System.out.println(rs.getString("ZH_LABEL")); System.out.println(rs.getString("ZH_LABEL"));
System.out.println(rs.getString("ZH_LABEL"));
System.out.println(rs.getInt("INT_ID"));
System.out.println(rs.getInt("RELATED_BTS_JTGF")); System.out.println(rs.getString("CI"));
System.out.println(rs.getString("CELL_CI")); // eoms.add(rs.getString("ZH_LABEL"));
}[/color]结果是:
昌平天通苑北二区DCS
昌平天通苑北二区DCS
昌平天通苑北二区DCS
56165981
56165981
12731
12731
昌平天通苑北二区DCS
昌平天通苑北二区DCS
昌平天通苑北二区DCS
56165981
56165981
12732
12732
昌平天通苑北二区DCS
昌平天通苑北二区DCS
昌平天通苑北二区DCS
56165981
56165981
12733
12733从oracle数据库中关联查询的信息如下:
ZH_LABEL ZH_LABEL ZH_LABEL INT_ID RELATED_BTS_JTGF CI CELL_CI
----------- ------------ ----------- --------- ------------------- ----- ----------
昌平天通苑北二区DCS 昌平天通苑北二区DCS1 28 56165981 56165981 12731 12731
昌平天通苑北二区DCS 昌平天通苑北二区DCS2 28 56165981 56165981 12732 12732
昌平天通苑北二区DCS 昌平天通苑北二区DCS3 28 56165981 56165981 12733 12733 问题:
while(rs.next()){
System.out.println(rs.getString("?"));
System.out.println(rs.getString("?"));
System.out.println(rs.getString("?"));
System.out.println(rs.getInt("?"));
System.out.println(rs.getInt("?"));
System.out.println(rs.getString("?"));
System.out.println(rs.getString("?"));
}问号里面怎么写啊,有谁会改改,贴上来,谢谢谢谢!
解决方案 »
- 急,求解
- 我在客户端调用的时候,web service服务端报异常?
- 有谁用c语言开发手机软件的吗
- log4j:WARN No appenders could be 。。。。
- WebLogic 7.0 的 classPath 问题~?实在是搞不定了~!
- 一个EJB发布问题,急~
- 在网页中怎样从https方式变为http方式?
- servlet调用local接口sessionbean weblogic服务,出现异常,急
- 紧急求助:安装j2sdk-1_4_1_02-windows-i586.exe,出现提示信息:此Java(TM)平台不支持此计算机上的操作系统的Service Pack。请从Microso
- 刚装完的jBuilder8不能输入五笔,用拼音输入汉字又行,你们见过这种情况吗?
- (在线等)XML解析的问题
- 麻烦大家帮忙看下此问题,java基础吧。
rs.next()是用来取结果——实例化、并自增的。
rs.next()是用来取结果——实例化、并自增的。
throws SQLException以 Java 编程语言中 String 的形式检索此 ResultSet 对象的当前行中指定列的值。 参数:
columnIndex - 第一个列是 1,第二个列是 2,……
返回:
列值;如果值为 SQL NULL,则返回值为 null
抛出:
SQLException - 如果发生数据库访问错误
rs.getInt(),也一样,只是rs.getInt()只能用来读取int型的数据!
如果是int类型用rs.getInt("列名")
select RMS_BTS.ZH_LABEL,RMS_CELL.ZH_LABEL...
哥哥,两张表,ZH_LABEL是描述名称,带着表名就不对,编译通不过,不带表名就是这样:
...while (rs.next()) {
System.out.println(rs.getString("ZH_LABEL"));
System.out.println(rs.getString("ZH_LABEL"));
System.out.println(rs.getString("ZH_LABEL"));
...结果:
昌平天通苑北二区DCS
昌平天通苑北二区DCS
昌平天通苑北二区DCS好吧我用这个
while (rs.next()) {
System.out.println(rs.getString("RMS_BTS.ZH_LABEL"));
System.out.println(rs.getString("RMS_CELL.ZH_LABEL"));
System.out.println(rs.getString("RMS_ANTENNA.ZH_LABEL"));
...报错...
我觉得rs.getString(1),rs.可行.试试
sql关联查询得用心学啊,奶奶滴谢谢.
从oracle数据库中关联查询的信息如下:
ZH_LABEL ZH_LABEL ZH_LABEL INT_ID RELATED_BTS_JTGF CI CELL_CI
----------- ------------ ----------- --------- ------------------- ----- ----------
昌平天通苑北二区DCS 昌平天通苑北二区DCS1 28 56165981 56165981 12731 12731
昌平天通苑北二区DCS 昌平天通苑北二区DCS2 28 56165981 56165981 12732 12732
昌平天通苑北二区DCS 昌平天通苑北二区DCS3 28 56165981 56165981 12733 12733
你没发现 ZH_LABEL ZH_LABEL ZH_LABEL 一样吗?要不然我问这个问题干什么?
已经解决了,就取列数得了
谢谢 !