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

package mvc; 
import java.util.Date; 
import java.sql.*; 
import java.util.*; 
import javax.servlet.*; 
import javax.servlet.http.*; 
public class Bean1 
{  
    
public void addnew(HttpServletRequest request)throws Exception 
{ 
  try 
  { 
   DbBean  db=new DbBean(); 
   Connection sqlCon=db.getConn(); 
   String addsql="insert into txl_tab(name,dz,dh,yb,oicq,lrsj) values(?,?,?,?,?,?)"; 
   PreparedStatement pstm=sqlCon.prepareStatement(addsql); 
     
   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.executeUpdate(); 
   pstm.close(); 
   sqlCon.close(); 
  } 
  catch(Exception e) 
  { 
  } 
} 
  
}