userbean.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 UserBean
{
	 
//add
	public void addnew(HttpServletRequest req) throws Exception
	{
	  DbOrder  db=new DbOrder();
	  try
	  {
	   	String addsql="insert into user_tab(username,pwd) values(?,?)";
	   	Connection sqlCon=db.getConn();
	   	PreparedStatement  pstm=sqlCon.prepareStatement(addsql);
	   	pstm.setString(1,new String(req.getParameter("username").getBytes("ISO8859_1"),"gb2312"));
        pstm.setString(2,new String(req.getParameter("pwd").getBytes("ISO8859_1"),"gb2312")); 
       
       	
       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 user_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 user_tab set username=?,pwd=? where id=?";
	   	Connection sqlCon=db.getConn();
	   	PreparedStatement  pstm=sqlCon.prepareStatement(addsql);
	   	pstm.setString(1,new String(req.getParameter("username").getBytes("ISO8859_1"),"gb2312"));
        pstm.setString(2,new String(req.getParameter("pwd").getBytes("ISO8859_1"),"gb2312")); 
       	
       
       	pstm.executeUpdate();
       	pstm.close();
       	sqlCon.close();	  	 
	   } 
	   catch(Exception e)
	   {
	   }
	}

	
	
		
}