67,513
社区成员
发帖
与我相关
我的任务
分享
String sql4="select b_id from boss_info where username='"+username+"'";
rs2=stmt.executeQuery(sql4);
if(rs2.next()){
Integer bb_id=rs2.getInt("b_id");
String sql3=" insert into hotel_info(h_id,b_id,h_name,h_privence,h_city,h_address,username) values(REGISTER.nextval,?,?,?,?,?,?)";
pst=conn.prepareStatement(sql3);
pst.setString(1,h_name);
pst.setInt(2,bb_id);
pst.setString(3,h_privence);
pst.setString(4,h_city);
pst.setString(5,h_address);
pst.setString(6,username);
BigDecimal bb_id =rs2.getBigDecimal("b_id");
pst.setBigDecimal(2,bb_id);