dao.java

用JSP JAVA 做的 系统 只是初来扎到还望西黄！别乱来哦！

package com.chis.util;

import java.util.List;

import com.stframe.dao.DaoUtil;
import com.stframe.form.ActionForm;
import com.stframe.form.DataForm;
import com.stframe.servlet.ActionInstance;

public class Dao extends ActionInstance {

	@Override
	public int execute(ActionForm arg0) throws Exception {
		return 0;
	}
	
	/**
	 * 保存
	 * @param af ActionForm
	 * @param df DataForm
	 * @param url url
	 * @param str 返回文字
	 * @return
	 */
	public int daoSave(ActionForm af, DataForm df, String url, String str) {
		int bak = 0;
		try {
			bak = DaoUtil.insert(af.getConnection(), df);
			if (bak > 0) {
				af.getHttpRequest().setAttribute("result", str);
				af.getHttpRequest().setAttribute("goto",
						"Selevet.do?action=" + url);
				af.getHttpRequest().setAttribute("CMD",
						af.getHttpRequest().getParameter("CMD"));
				return 1;
			} else {
				af.getHttpRequest().setAttribute("result", str);
				return 0;
			}
		} catch (Exception e) {
			e.printStackTrace();
			af.getHttpRequest().setAttribute("result", str);
			return 0;
		}
	}
	
	/**
	 * 修改
	 * @param af  ActionForm
	 * @param df  DataForm
	 * @param url  url
	 * @param str  返回文字
	 * @return
	 */
	public int daoUpdate(ActionForm af, DataForm df, String url, String str) {
		int bak = 0;
		try {
			bak = DaoUtil.update(af.getConnection(), df);
			if (bak > 0) {
				af.getHttpRequest().setAttribute("result", str);
				af.getHttpRequest().setAttribute("goto",
						"Selevet.do?action=" + url);
				af.getHttpRequest().setAttribute("CMD",
						af.getHttpRequest().getParameter("CMD"));
				return 1;
			} else {
				af.getHttpRequest().setAttribute("result", str);
				return 0;
			}
		} catch (Exception e) {
			e.printStackTrace();
			af.getHttpRequest().setAttribute("result", str);
			return 0;
		}
	}
	
	/**
	 * 删除
	 * @param af  ActionForm
	 * @param id  DataForm
	 * @param table  表名
	 * @param url  url
	 * @param str  返回文字
	 * @return
	 */
	public int daoDelecte(ActionForm af, String id,String table, String url, String str){
		int bak = 0;
		try {
			bak=DaoUtil.execute(af.getConnection(),"DELETE FROM "+table+" WHERE ID='"+id+"'");
			if(bak>0){
				af.getHttpRequest().setAttribute("result",str);
				af.getHttpRequest().setAttribute("goto","Selevet.do?action="+url);
				af.getHttpRequest().setAttribute("CMD",af.getHttpRequest().getParameter("CMD"));
				return 1;
			}else{
				af.getHttpRequest().setAttribute("result", str);
				return 0;
			}
		} catch (Exception e) {
			e.printStackTrace();
			af.getHttpRequest().setAttribute("result", str);
			return 0;
		}
	}
	
	/**
	 * 查询列表
	 * @param af  ActionForm
	 * @param table 表名
	 * @param str 条件
	 * @return
	 */
	public List daoSelectAll(ActionForm af,String sql,  DataForm df){
		
		List list=DaoUtil.select(af.getConnection(),sql, df);
		return  list;
	}


}