orderbean.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 OrderBean
{
	 
//订票方法
	public void buy(HttpServletRequest req) throws Exception
	{
	  DbOrder  db=new  DbOrder ();
	  try
	  {
	   	String addsql="insert into order_tab(name,addr,phone,sfz,chairtype,hbh,ordertime) 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("addr").getBytes("ISO8859_1"),"gb2312")); 
       	pstm.setString(3,req.getParameter("phone"));
       	pstm.setString(4,req.getParameter("sfz"));
       	pstm.setString(5,req.getParameter("chairtype"));
       	pstm.setString(6,req.getParameter("hbh"));
       	pstm.setString(7,req.getParameter("ordertime"));
       	
       	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 order_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)
	   {
	   }
	}
//update
	public void update(HttpServletRequest req) throws Exception
	{
	   DbOrder  db=new  DbOrder ();
	  try
	  {
	   	String addsql="update order_tab set state=? where id=?";
	   	Connection sqlCon=db.getConn();
	   	PreparedStatement  pstm=sqlCon.prepareStatement(addsql);
	   
       	
       	pstm.setInt(1,Integer.parseInt(req.getParameter("state1")));
       	pstm.setInt(2,Integer.parseInt(req.getParameter("id")));
       	
       	pstm.executeUpdate();
       	pstm.close();
       	sqlCon.close();	  	 
	   } 
	   catch(Exception e)
	   {
	   }
	}

	
//登陆方法
	public String  login(HttpServletRequest req) throws Exception
	{
	   String userName=req.getParameter("username");
	   String passWord=null;
	   DbOrder  db=new  DbOrder ();
	 try
	  {
	   	String addsql="select*  from user_tab  where username='"+userName+"'";
	   	Connection sqlCon=db.getConn();
	   	Statement stat=sqlCon.createStatement();
	       ResultSet rs = stat.executeQuery(addsql);
            rs.next();
        passWord= rs.getString(3);
         
       	stat.close();
       	sqlCon.close();	  	 
	   } 
	   catch(Exception e)
	   {
	   }
	return passWord; 
	}
		
}