package yinhang;
import yinhang.ZhangHu;
import com.sina.wangjiajuan.Tool;
import java.sql.*;
public class DBZhuanZhang implements DBZhuanZhangJieKou{ @Override
public void DBtransfer(ZhangHu o,ZhangHu b,int money) {
// TODO Auto-generated method stub
Connection conn=Tool.getConnection();
Statement st=null;
ResultSet rs=null;
try {
int IDo=o.getID();
int IDb=b.getID();
String sql="select YuEr from zhanghu where ID="+IDo;
String sql1="select YuEr from zhanghu where ID="+IDb;
st=conn.createStatement();
rs=st.executeQuery(sql);
int YuEro=0;
while(rs.next()){
YuEro=rs.getInt(1); ??????
}
rs=st.executeQuery(sql1);
int YuErb=0;
while(rs.next()){
YuErb=rs.getInt(1);
}
if(YuEro <money){
System.out.print("yu er buzu");
}else {
YuEro-=money;
YuErb+=money;
String sql2="update zhanghu set YuEr="+YuEro+"where ID="+IDo;
String sql3="update zhanghu set YuEr="+YuErb+"where ID="+IDb;
st.executeUpdate(sql2);
st.executeUpdate(sql3);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}}问题在???处,为何getInt(1),而我的表结构是YuEr是第二个字段,不应该是getInt(2),但是;用了之后,报“无效的列索引”,why????????
import yinhang.ZhangHu;
import com.sina.wangjiajuan.Tool;
import java.sql.*;
public class DBZhuanZhang implements DBZhuanZhangJieKou{ @Override
public void DBtransfer(ZhangHu o,ZhangHu b,int money) {
// TODO Auto-generated method stub
Connection conn=Tool.getConnection();
Statement st=null;
ResultSet rs=null;
try {
int IDo=o.getID();
int IDb=b.getID();
String sql="select YuEr from zhanghu where ID="+IDo;
String sql1="select YuEr from zhanghu where ID="+IDb;
st=conn.createStatement();
rs=st.executeQuery(sql);
int YuEro=0;
while(rs.next()){
YuEro=rs.getInt(1); ??????
}
rs=st.executeQuery(sql1);
int YuErb=0;
while(rs.next()){
YuErb=rs.getInt(1);
}
if(YuEro <money){
System.out.print("yu er buzu");
}else {
YuEro-=money;
YuErb+=money;
String sql2="update zhanghu set YuEr="+YuEro+"where ID="+IDo;
String sql3="update zhanghu set YuEr="+YuErb+"where ID="+IDb;
st.executeUpdate(sql2);
st.executeUpdate(sql3);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}}问题在???处,为何getInt(1),而我的表结构是YuEr是第二个字段,不应该是getInt(2),但是;用了之后,报“无效的列索引”,why????????
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货