bugstatusdao.java

是一个Bug系统

package com.runwit.ebookstore.services.dao;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.List;

import com.runwit.ebookstore.model.BugStatusModel;
import com.runwit.ebookstore.services.IBugStatusServices;

public class BugStatusDAO extends DbDAO implements IBugStatusServices {

	@Override
	public Object mapRowToModel(ResultSet rs) throws SQLException {
		
		BugStatusModel model = new BugStatusModel(
				rs.getInt("bsid"), 
				rs.getString("name"), 
				rs.getString("remark")
				);

		return model;
	}

	public List getStatusList() {
		
		String sql = "select * from bugstatus";
		DebugUtil.printSql(sql);
		try{
			return super.queryBySql(sql);
		}catch(SQLException ex) {
			return null;
		}
	}

}