private int nestedCount=0;
public void valueChanged(ListSelectionEvent evt)
{
if (nestedCount>0) return;
nestedCount++;
String selList=(String)lstylrfwzl.getSelectedValue();
int selList_jiequ_i=selList.indexOf("街区");
int selList_donghao_i=selList.indexOf("栋");
int selList_fanghao_i=selList.indexOf("号");
String selList_jiequ=selList.substring(0,selList_jiequ_i + 2);
String selList_donghao=selList.substring(selList_jiequ_i + 2,selList_donghao_i);
String selList_fanghao=selList.substring(selList_donghao_i + 1,selList_fanghao_i);
String sql11="select * from weiming.酒钢商业用房基本资料库 where 街区=\'" + selList_jiequ + "\' and 栋号=\'" + selList_donghao + "\' and 房号=\'" + selList_fanghao + "\'";
try
{
ResultSet rs_detail=db_jiequ.rs_jiequ(sql11);
if (rs_detail.next())
{
/*
Object get_xiaoqu=(Object)rs_detail.getString("小区");
Object get_jiequ=(Object)rs_detail.getString("街区");
Object get_donghao=(Object)rs_detail.getString("栋号");
Object get_fwzk=(Object)rs_detail.getString("房屋状况");
Object get_syzt=(Object)rs_detail.getString("使用状态");
comxiaoqu.setSelectedItem(get_xiaoqu);
comjiequ.setSelectedItem(get_jiequ);
comdonghao.setSelectedItem(get_donghao);
comfwzk.setSelectedItem(get_fwzk);
comsyzt.setSelectedItem(get_syzt);
*/
txtfanghao.setText(String.valueOf(rs_detail.getInt("房号")));
txtjzmj.setText(String.valueOf(rs_detail.getInt("建筑面积")));
txtzjbz.setText(String.valueOf(rs_detail.getInt("租金标准")));
txtsymj.setText(String.valueOf(rs_detail.getInt("使用面积")));
}
}
catch(Exception ex)
{
System.out.println(ex.getMessage());
System.out.println(sql11);
}
nestedCount--;
}
public void valueChanged(ListSelectionEvent evt)
{
if (nestedCount>0) return;
nestedCount++;
String selList=(String)lstylrfwzl.getSelectedValue();
int selList_jiequ_i=selList.indexOf("街区");
int selList_donghao_i=selList.indexOf("栋");
int selList_fanghao_i=selList.indexOf("号");
String selList_jiequ=selList.substring(0,selList_jiequ_i + 2);
String selList_donghao=selList.substring(selList_jiequ_i + 2,selList_donghao_i);
String selList_fanghao=selList.substring(selList_donghao_i + 1,selList_fanghao_i);
String sql11="select * from weiming.酒钢商业用房基本资料库 where 街区=\'" + selList_jiequ + "\' and 栋号=\'" + selList_donghao + "\' and 房号=\'" + selList_fanghao + "\'";
try
{
ResultSet rs_detail=db_jiequ.rs_jiequ(sql11);
if (rs_detail.next())
{
/*
Object get_xiaoqu=(Object)rs_detail.getString("小区");
Object get_jiequ=(Object)rs_detail.getString("街区");
Object get_donghao=(Object)rs_detail.getString("栋号");
Object get_fwzk=(Object)rs_detail.getString("房屋状况");
Object get_syzt=(Object)rs_detail.getString("使用状态");
comxiaoqu.setSelectedItem(get_xiaoqu);
comjiequ.setSelectedItem(get_jiequ);
comdonghao.setSelectedItem(get_donghao);
comfwzk.setSelectedItem(get_fwzk);
comsyzt.setSelectedItem(get_syzt);
*/
txtfanghao.setText(String.valueOf(rs_detail.getInt("房号")));
txtjzmj.setText(String.valueOf(rs_detail.getInt("建筑面积")));
txtzjbz.setText(String.valueOf(rs_detail.getInt("租金标准")));
txtsymj.setText(String.valueOf(rs_detail.getInt("使用面积")));
}
}
catch(Exception ex)
{
System.out.println(ex.getMessage());
System.out.println(sql11);
}
nestedCount--;
}
解决方案 »
- 求为什么执行不下去
- 新手问个eclipse的问题
- 怎么会是这种错误呢,一个简单的Server,Client
- 为何执行update语句去更新ACCESS时,程序没错,却更新不了
- 【java解惑,基础好的高手进】二进制转换和short类型转换为int类型的问题。
- 请问能否给个POI的API文档的在线网址
- 对象的内容可以在被调用的方法中改变,但对象的引用是永远不会改变的。"请大家给解释一下"
- JCreator Pro与jbuilder有什么区别啊?
- 请各位进来帮忙解答
- java中将final数值定义为static和非static的区别
- 哪位老兄能告诉我一个能计算出两个日期之间的天数比较简单的方法?
- 我用java开发的俄罗斯方块有一点问题????想找个人帮忙,
找到触发事件ListSelectionEvent 的地方再想彻底的解决办法
错误为:
[Oracle][ODBC]Invalid column number <2>.[Oracle][ODBC]Invalid column number <2>.[Oracle][ODBC]Invalid column number <2>.[Oracle][ODBC]Invalid column number <2>.[Oracle][ODBC]Invalid column number <2>.[Oracle][ODBC]Invalid column number <2>.[Oracle][ODBC]Invalid column number <2>.[Oracle][ODBC]Invalid column number <2>.[Oracle][ODBC]Invalid column number <2>.[Oracle][ODBC]Invalid column number <2>.[Oracle][ODBC]Invalid column number <2>.[Oracle][ODBC]Invalid column number <2>.[Oracle][ODBC]Invalid column number <2>.[Oracle][ODBC]Invalid column number <2>.[Oracle][ODBC]Invalid column number <2>.[Oracle][ODBC]Invalid column number <2>.[Oracle][ODBC]Invalid column number <2>.[Oracle][ODBC]Invalid column number <2>.[Oracle][ODBC]Invalid column number <2>.[Oracle][ODBC]Invalid column number <2>.[Oracle][ODBC]Invalid column number <2>.[Oracle][ODBC]Invalid column number <2>.[Oracle][ODBC]Invalid column number <2>.[Oracle][ODBC]Invalid column number <2>.[Oracle][ODBC]Invalid column number <2>.[Oracle][ODBC]Invalid column number <2>.[Oracle][ODBC]Invalid column number <2>.[Oracle][ODBC]Invalid column number <2>.[Oracle][ODBC]Invalid column number <2>.[Oracle][ODBC]Invalid column number <2>.[Oracle][ODBC]Invalid column number <2>.[Oracle][ODBC]Invalid column number <2>.[Oracle][ODBC]Invalid column number <2>.[Oracle][ODBC]Invalid column number <2>.[Oracle][ODBC]Invalid column number <2>.[Oracle][ODBC]Invalid column number <2>.[Oracle][ODBC]Invalid column number <2>.[Oracle][ODBC]Invalid column number <2>.[Oracle][ODBC]Invalid column number <2>.[Oracle][ODBC]Invalid column number <2>.[Oracle][ODBC]Invalid column number <2>.[Oracle][ODBC]Invalid column number <2>.[Oracle][ODBC]Invalid column number <2>.[Oracle][ODBC]Invalid column number <2>.[Oracle][ODBC]Invalid column number <2>.[Oracle][ODBC]Invalid column number <2>.[Oracle][ODBC]Invalid column number <2>.java.sql.SQLException: [Oracle][ODBC][Ora]ORA-01000: 超出打开光标的最大数java.sql.SQLException: [Oracle][ODBC][Ora]ORA-01000: 超出打开光标的最大数java.sql.SQLException: [Oracle][ODBC][Ora]ORA-01000: 超出打开光标的最大数java.sql.SQLException: [Oracle][ODBC][Ora]ORA-01000: 超出打开光标的最大数java.sql.SQLException: [Oracle][ODBC][Ora]ORA-01000: 超出打开光标的最大数java.sql.SQLException: [Oracle][ODBC][Ora]ORA-01000: 超出打开光标的最大数
能正常运行吗?我是指在数据库中直接运行
txtfanghao.setText(String.valueOf(rs_detail.getInt("房号")));
txtjzmj.setText(String.valueOf(rs_detail.getInt("建筑面积")));
txtzjbz.setText(String.valueOf(rs_detail.getInt("租金标准")));
txtsymj.setText(String.valueOf(rs_detail.getInt("使用面积")));