test.jsp

JSP+ORACLE网站开发实例（下）.rar

   <%@ include file="conn.jsp"%>

<%String  sql;
   
   sql="select * from scott.friendimg where id=41";
      ResultSet rst=stmt.executeQuery(sql); 
if(rst.next()) { 
	 out.print("update scott.friendimg set img='"+rst.getString("img")+"' where id='4'"); 
	 //stmt.executeUpdate("update scott.friendimg set img='"+rst.getString("img")+"' where id='4'"); 

  //stmt.executeUpdate("update scott.friendimg set img='"+rst.getString("img")+"'  where id='21'");
    //stmt.executeUpdate("update scott.friendimg set img='"+rs1.getString("img")+"'"); 
}
	%>