src/org/bs/dao/impl/MaterialDaoImpl.java

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

package org.bs.dao.impl;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.text.DateFormat;
import java.util.ArrayList;
import java.util.Calendar;
import java.util.Date;
import java.util.List;

import org.bs.dao.MaterialDao;
import org.bs.model.Material;
import org.bs.utils.ConnContext;
import org.bs.utils.DB;
import org.bs.utils.PageContext;



public class MaterialDaoImpl extends BaseDao implements MaterialDao{

	public Material getMaterialById(int id){
		Connection conn = DB.getConn();
		String sql = "select * from t_materials where id = ?";
		Material material = null;
		PreparedStatement pstmt = null;
		ResultSet rs = null;
		try {
		    pstmt = conn.prepareStatement(sql);
			pstmt.setInt(1, id);
			rs = pstmt.executeQuery();
			while(rs.next()){
				material = new Material();
				material.setId(rs.getInt("id"));
				material.setInTime(rs.getDate("in_time"));
				material.setName(rs.getString("name"));
				material.setPhoto(rs.getString("photo"));
				material.setPower(rs.getString("power"));
				material.setState(rs.getInt("state"));
				material.setNo(rs.getString("no"));
				material.setCount(rs.getInt("count"));
				material.setPrice(rs.getInt("price"));
			}
		} catch (SQLException e) {
		}finally{
			DB.close(conn);
			DB.close(pstmt);
			DB.close(rs);
		}
		return material;
	}

	/* (non-Javadoc)
	 * @see org.bs.dao.impl.MaterialDao#getMaterialByNo(java.lang.String)
	 */
	public Material getMaterialByNo(String no){
		Connection conn = DB.getConn();
		String sql = "select * from t_materials where no = '"+no+"'";
		Material material = null;