超级简单的mvc框架ajf1.2发布 3

   public String execute_view()throws Exception{

           Map user = null;
           String objectid = (String)model.get("objectid"); 
           String sql = "select * from t_user where id='"+objectid+"'";
           conn = DBUtil.getConn();
           user = DBUtil.queryOne(conn,sql,null);
           //sql = "select * from t_user where id=?"
           //user = DBUtil.queryOne(conn,sql,new Object[]{objectid});
           if(user==null){
               return "no_object";
           }
           model.put("user",user);
           return "view";
        
   }

   public String execute_update()throws Exception{

           String table = "t_user";    
           String cols = "id,name,hh,ww,birth_day";
           int autoPK = 1;//主键是否自增 ，max(id)+1
          
           conn = DBUtil.getConn();
           DBUtil.updateRow(conn,table,cols,1,model);
           return "!query";
        
   }

   public String execute_delete()throws Exception{

           String sql = "delete from t_user where id "; 
           DBUtil.batchDelById(sql,request);
           return "!query";
           
        
   }


   private void createTable(){
             String sql = null;
             sql = "create table t_user(id int primary key,name varchar(50),hh numeric(8,3),ww numeric(8,3),birth_day datetime)";
                 try{
                DBUtil.update(sql,null,request);
}catch(Exception e){}
   }
 

}


//--------------------配置文件ajf.xml



<ajf>

<view name="error">/pages/commons/error.jsp</view>
<view name="home">/pages/commons/ajf_home.jsp</view>
<view name="no_object">/pages/commons/no_object.jsp</view>

<action name="/pages/user/user" class="com.zjuee.action.UserAction">
            <view name="query">user.do</view>      
             <view name="q">user_query.jsp</view>   
              <view name="input">user_input.jsp</view>
            <view name="edit">user_edit.jsp</view>
             <view name="view">user_view.jsp</view>                    
     </action>   
 
<action name="/pages/user/x" forward="/pages/user/user.do"/>
<action name="/xx" forward="!/pages/user/user.do"/>
</ajf>


        enjoy!
                                       giscat 20061121

上一页  [1] [2] [3] 

查看本文来源