package mvc;
import java.io.*;

import java.util.Date;
import java.util.*;
import java.sql.*;
import javax.servlet.http.*;
import javax.servlet.*;

public class HbBean
{
	 
//add
	public void addnew(HttpServletRequest req) throws Exception
	{
	  DbOrder  db=new DbOrder();
	  try
	  {
	   	String addsql="insert into hb_tab(hbh,mdd,qfsj,ddsj,hprice,dprice) values(?,?,?,?,?,?)";
	   	Connection sqlCon=db.getConn();
	   	PreparedStatement  pstm=sqlCon.prepareStatement(addsql);
	   	pstm.setString(1,new String(req.getParameter("hbh").getBytes("ISO8859_1"),"gb2312"));
        pstm.setString(2,new String(req.getParameter("mdd").getBytes("ISO8859_1"),"gb2312")); 
        pstm.setString(3,new String(req.getParameter("qfsj").getBytes("ISO8859_1"),"gb2312")); 
        pstm.setString(4,new String(req.getParameter("ddsj").getBytes("ISO8859_1"),"gb2312")); 
        
       	pstm.setInt(5,Integer.parseInt(req.getParameter("hprice")));
       	pstm.setInt(6,Integer.parseInt(req.getParameter("dprice")));
       
       	
       pstm.executeUpdate();
       	pstm.close();
       	sqlCon.close();	  	 
	   } 
	   catch(Exception e)
	   {
	   }
	
	}
//delete
	public void delete(HttpServletRequest req) throws Exception
	{
	  DbOrder  db=new DbOrder();
	  try
	  {
	   	String sql="delete from hb_tab where id=?";
	   	Connection sqlCon=db.getConn();
	   	PreparedStatement  pstm=sqlCon.prepareStatement(sql);
 
       	pstm.setInt (1,Integer.parseInt(req.getParameter("id")));
        
       	pstm.executeUpdate();
       	pstm.close();
       	sqlCon.close();	  	 
	   } 
	   catch(Exception e)
	   {
	   }
	}
//uqdate
	public void update(HttpServletRequest req) throws Exception
	{
	  DbOrder db=new DbOrder();
	  try
	  {
	   	String addsql="update hb_tab set hbh=?,mdd=?,qfsj=?,ddsj=?,hprice=?,dprice=? where id=?";
	   	Connection sqlCon=db.getConn();
	   	PreparedStatement  pstm=sqlCon.prepareStatement(addsql);
	   	pstm.setString(1,new String(req.getParameter("hbh").getBytes("ISO8859_1"),"gb2312"));
        pstm.setString(2,new String(req.getParameter("mdd").getBytes("ISO8859_1"),"gb2312")); 
       	
       	pstm.setString(3,new String(req.getParameter("qfsj").getBytes("ISO8859_1"),"gb2312")); 
       	pstm.setString(4,new String(req.getParameter("ddsj").getBytes("ISO8859_1"),"gb2312")); 
      	pstm.setInt(5,Integer.parseInt(req.getParameter("hprice")));
      	pstm.setInt(6,Integer.parseInt(req.getParameter("dprice")));
       	pstm.executeUpdate();
       	pstm.close();
       	sqlCon.close();	  	 
	   } 
	   catch(Exception e)
	   {
	   }
	}

	
	
		
}