两表联合查询插入代码：

两表联合查询插入代码：

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);//跳转
  
 }