www.pudn.com > mvc12.rar > Bean3.java

package mvc; 
import java.util.Date; 
import java.sql.*; 
import java.util.*; 
import javax.servlet.*; 
import javax.servlet.http.*; 
public class Bean3 
{  
    
public void update(HttpServletRequest request)throws Exception 
{ 
  try 
  { 
   DbBean  db=new DbBean(); 
   Connection sqlCon=db.getConn(); 
   String updatesql="update txl_tab set name=?,dz=?,dh=?,yb=?,oicq=?,lrsj=?  where id=?"; 
   PreparedStatement pstm=sqlCon.prepareStatement(updatesql); 
   pstm.setString(1,new String(request.getParameter("name").trim().getBytes("ISO8859_1"),"gb2312")); 
   pstm.setString(2,new String(request.getParameter("dz").trim().getBytes("ISO8859_1"),"gb2312")); 
   pstm.setString(3,request.getParameter("dh")); 
   pstm.setInt(4,Integer.parseInt(request.getParameter("yb"))); 
   pstm.setString(5,request.getParameter("oicq")); 
   pstm.setDate(6,new java.sql.Date(new java.util.Date().getTime())); 
   pstm.setInt(7,Integer.parseInt(request.getParameter("id"))); 
   pstm.executeUpdate(); 
   pstm.close(); 
   sqlCon.close(); 
  } 
  catch(Exception e) 
  { 
  } 
} 
  
}