package cn.xwkj.dao;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import cn.xwkj.entity.Mso;

public class MsoDao extends BaseDao{

	// 查询方法(返回结果用集合存储)
		public List<Mso> list(String sql, Object... param){
			List<Mso> list=new ArrayList<Mso>();
			ResultSet rs=executeQuery(sql, param);
			try {
				while(rs.next())
				{
					Mso m=new Mso();
					m.setId(rs.getInt(1));
					m.setMsoid(rs.getString(2));
					m.setMsoname(rs.getString(3));
					m.setTelephone(rs.getString(4));
					m.setMsoTime(rs.getString(5));
					m.setMsostate(rs.getString(6));
					m.setMsomoney(rs.getString(7));
					m.setAddress(rs.getString(8));
					list.add(m);
				}
				return list;
			} catch (SQLException e) {
				e.printStackTrace();
			}
			finally
			{
				closeAll();
			}
			return null;
		}
		
		/**
		 * 修改
		 * @param sql
		 * @param mso
		 * @return
		 */
		public int Update(String sql, Mso mso) {
			Object [] param = {};
			return executeUpdate(sql, param);
		}
		/**
		 * 删除
		 * @param sql
		 * @param id
		 * @return
		 */
		public int delete(String sql, int id) {
			
			return executeUpdate(sql, id);
		}
}