addroutebean.java

这是jsp通用模块导航的程序原代码,里面有新闻,bbs等jsp与javabean结合的程序.

package com.wxpn.tutorial.ec.bean;


import java.sql.SQLException;

import java.util.Collection;
import java.util.HashMap;


import com.wxpn.tutorial.ec.util.DBAccess;



public class AddRouteBean {
	private DBAccess db=null;
    //state the table' name
    private String sTableName="travelroute";
	
	public AddRouteBean()  {
		db=new DBAccess();
	}
	
	 public void deleteRouteByKey(int key) throws Exception{
			
			try{
				db.performDeleteByKey(sTableName,key);
			} catch (Exception e) {
				e.printStackTrace();
			}
	}
	 
	 public void insertTravelRoute(HashMap map) throws Exception{
			
			try{
				db.performInsert(sTableName,map);
			}catch(Exception e){
				e.printStackTrace();
				}
			}
	
	 
	 public String getAddSeqNum() throws SQLException{
         
		 String tablekey="routeid";
		 String maxid = "1";  
		   db=new DBAccess();
			try{
	
				maxid=db.getAddSeqNum(tablekey,sTableName);
			}catch(Exception e){

					e.printStackTrace();
			
			}  
			 
	  return maxid;  
	      
 }
     public Collection getResultList(){
		 
		 Collection  resultList =null;
		 try{
		 resultList=(Collection)db.getAll(sTableName);
		 
     }catch(Exception e){
	  e.printStackTrace();	 
	 }
		return resultList;
     }
}