我是新手。我有两张桌子。
registrationtable
logintable
哪里
registerationid
登记表
和外键输入
哪里
注册ID
在里面
登记表
. 我可以插入
但不在
登录表
PreparedStatement
并且拥有
Bean
提前感谢您的帮助。
try {
PreparedStatement preparedstatement=connection.prepareStatement("INSERT INTO registrationtable(firstname,lastname,dob,address,city,state,mob) VALUES (?,?,?,?,?,?,?)",PreparedStatement.RETURN_GENERATED_KEYS);
preparedstatement.setString(1,bean.getFirstName());
preparedstatement.setString(2,bean.getLastName());
preparedstatement.setString(3,bean.getDOB());
preparedstatement.setString(4,bean.getAddress());
preparedstatement.setString(5,bean.getCity());
preparedstatement.setString(6,bean.getState());
preparedstatement.setString(7,bean.getMobile());
System.out.println("Dao Rgisteration : "+bean.getFirstName());
preparedstatement.executeUpdate();
ResultSet resultset=preparedstatement.getGeneratedKeys();
resultset.next();
int autoGeneratedKeyRegisteration = resultset.getInt(1);
preparedstatement.close();
String sql="INSERT INTO logintable(registerationid,username,password) VALUES (LAST_INSERT_ID(),'xyz@gmail.com','xyzabc123')";
PreparedStatement preparedstatement1=connection.prepareStatement(sql,PreparedStatement.RETURN_GENERATED_KEYS);
preparedstatement1.setInt(1,bean.getRegistrationId());
preparedstatement1.setString(2, bean.getUsername());
preparedstatement1.setString(3, bean.getPassword());
System.out.println("Dao Login : "+bean.getUsername());
preparedstatement1.executeUpdate();
ResultSet resultset1=preparedstatement1.getGeneratedKeys();
if(resultset1.next()){
int autoGeneratedkeyLogin=resultset1.getInt(1);
}
resultset1=preparedstatement1.executeQuery("SELECT registerationid FROM logintable WHERE registerationid=LAST_INSERT_ID()");
System.out.println(resultset);
preparedstatement1.close();
} catch(Exception e){e.getMessage();}finally{
try{
connection.close();
}catch(Exception ex){ex.getMessage();}
}
}