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

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

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

package org.bs.dao.impl;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.ArrayList;
import java.util.List;

import org.bs.dao.LoanDao;
import org.bs.dao.UserDao;
import org.bs.model.Loan;
import org.bs.model.User;
import org.bs.utils.ConnContext;
import org.bs.utils.DB;
import org.bs.utils.PageContext;

public class LoanDaoImpl extends BaseDao implements LoanDao {
	private UserDao userDao = new UserDaoImpl();
	public void save(Loan loan) {
		Connection conn = ConnContext.getConn();
		PreparedStatement pstmt = null;
		String sql = "insert into t_loan (kind,amount,pawn,assess,company,risk,approval,send,user) values(?,?,?,?,?,?,?,?,?)";
		try {
			pstmt = conn.prepareStatement(sql);
			pstmt.setString(1, loan.getKind());
			pstmt.setString(2, loan.getAmount());
			pstmt.setString(3, loan.getPawn());
			pstmt.setString(4, loan.getAssess());
			pstmt.setString(5, loan.getCompany());
			pstmt.setString(6, loan.getRisk());
			pstmt.setString(7, loan.getApproval());
			pstmt.setString(8, loan.getSend());
			pstmt.setInt(9, loan.getUser().getId());
			pstmt.executeUpdate();
		} catch (Exception e) {
			throw new RuntimeException(e);
		} finally {
			DB.close(pstmt);
		}
	}

	public void delete(int id) {
		Connection conn = ConnContext.getConn();
		PreparedStatement pstmt = null;
		String sql = "delete from t_loan where id =?";
		try {
			pstmt = conn.prepareStatement(sql);
			pstmt.setInt(1, id);
			pstmt.executeUpdate();
		} catch (Exception e) {
			throw new RuntimeException(e);
		} finally {
			DB.close(pstmt);
		}
	}

	public void update(Loan loan) {
		Connection conn = ConnContext.getConn();
		PreparedStatement pstmt = null;
		String sql = "update t_loan set kind=?,amount=?,pawn=?,assess=?,company=?,risk=?,approval=?,send=?,user=? "