两表联合查询插入代码:
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
String add=request.getParameter("m_id");//获取ID
manageBeanBO mbb=new manageBeanBO();//连接BO
Connection conn=new Conn().getConn();//连数据库
Statement stmt=null;
ResultSet rs=null;
try {
stmt=conn.createStatement();
String uname="select * from manager where m_id='"+add+"'";//添加查询语句
//String upwd="select m_pwd from manager where m_id='3'";
rs=stmt.executeQuery(uname);//执行语句,把结果集封装到rs中
//ResultSet rs2=stmt.executeQuery(upwd);
//while(rs1.next() || rs2.next())
//{
//System.out.println(rs.getString(2));
if(rs.next())//移动指针
{
System.out.println(rs.getString(2));
System.out.println(rs.getString(4));
String sql="insert into Useradmin values('"+rs.getString(2)+"','"+rs.getString(3)
+"','','','','3')";//添加另一张表的执行语句,注意:取出的是刚才那张表中的rs结果集
stmt.execute(sql);//执行
}
} catch (Exception e) {//抛异常
e.printStackTrace();
// TODO: handle exception
} finally {
try {
stmt.close();
conn.close();
} catch (Exception e) {
// TODO: handle exception
}
}
request.getRequestDispatcher("zhuce/userManage.jsp").forward(request, response);//跳转
}