...
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("?"));
}问号里面怎么写啊,有谁会改改,贴上来,谢谢谢谢!
解决方案 »
- java 大量数据导出为Excel 内存溢出
- 关于Spring 基于借口的AOP报错
- JMS来实现远程方法调用
- 请教性能优化,静态方法局部对象是否被回收?
- junit测试某一个方法,是不是在被测试的方法中不抛出异常,就算通过(显示绿条)???
- apache-cxf-2.1.3自带例子callback的basic_callback.wsdl在myeclipse 6.5工具中报错,请问如何解决?
- 帮兄弟找个工作,首月工资作感谢!!!
- 有人熟悉ANT吗?
- 什么时候用ejb才是效率最高的?
- 如何用简单的方式将某个指定目录下的几十个jar文件在CLASSPATH变量中注册?(50)
- (在线等)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 一样吗?要不然我问这个问题干什么?
已经解决了,就取列数得了
谢谢 !