pubbean.java

我用java jsp 编写的“航空订票系统”的小项目

package mvc;
import java.io.*;

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

public class PubBean
{
	 
//add
	public void addnew(HttpServletRequest req) throws Exception
	{
	  DbOrder  db=new DbOrder();
	  try
	  {
	   	String addsql="insert into pub_tab(name,sfz,state) values(?,?,?)";
	   	Connection sqlCon=db.getConn();
	   	PreparedStatement  pstm=sqlCon.prepareStatement(addsql);
	   	pstm.setString(1,new String(req.getParameter("name").getBytes("ISO8859_1"),"gb2312"));
        pstm.setString(2,new String(req.getParameter("sfz").getBytes("ISO8859_1"),"gb2312")); 
       	pstm.setInt(3,Integer.parseInt(req.getParameter("state1")));
       
       	
       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 pub_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 pub_tab set name=?,sfz=?,state=? where id=?";
	   	Connection sqlCon=db.getConn();
	   	PreparedStatement  pstm=sqlCon.prepareStatement(addsql);
	   	pstm.setString(1,new String(req.getParameter("name").getBytes("ISO8859_1"),"gb2312"));
        pstm.setString(2,new String(req.getParameter("sfz").getBytes("ISO8859_1"),"gb2312")); 
       	pstm.setInt(3,Integer.parseInt(req.getParameter("state1")));
      	pstm.setInt(4,Integer.parseInt(req.getParameter("id")));
       	pstm.executeUpdate();
       	pstm.close();
       	sqlCon.close();	  	 
	   } 
	   catch(Exception e)
	   {
	   }
	}

	
	
		
}