src/com/dao/ReaderTypeDAO.java

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

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

package com.dao;

import com.core.ConnDB;
import java.util.*;
import java.sql.*;

import com.actionForm.ReaderTypeForm;

public class ReaderTypeDAO {
	private ConnDB conn = new ConnDB();

	// 查询数据
	public Collection query(String strif) {
		ReaderTypeForm readerTypeForm = null;
		Collection readerTypeColl = new ArrayList();
		String sql = "";
		if (strif != "all" && strif != null && strif != "") {
			sql = "select * from tb_readerType where " + strif + "";
		} else {
			sql = "select * from tb_readerType";
		}
		ResultSet rs = conn.executeQuery(sql);
		try {
			while (rs.next()) {
				readerTypeForm = new ReaderTypeForm();
				readerTypeForm.setId(Integer.valueOf(rs.getString(1)));
				readerTypeForm.setName(rs.getString(2));
				readerTypeForm.setNumber(rs.getInt(3));
				readerTypeColl.add(readerTypeForm);
			}
		} catch (SQLException ex) {
		}
		conn.close();
		return readerTypeColl;
	}

	// 用于修改的查询
	public ReaderTypeForm queryM(ReaderTypeForm readerTypeForm) {
		ReaderTypeForm readerTypeForm1 = null;
		String sql = "select * from tb_readerType where id="
				+ readerTypeForm.getId() + "";
		System.out.println("修改时的SQL：" + sql);
		ResultSet rs = conn.executeQuery(sql);
		try {
			while (rs.next()) {
				readerTypeForm1 = new ReaderTypeForm();
				readerTypeForm1.setId(Integer.valueOf(rs.getString(1)));
				readerTypeForm1.setName(rs.getString(2));
				readerTypeForm1.setNumber(rs.getInt(3));
				System.out.println(rs.getInt(3));
			}
		} catch (SQLException ex) {
		}
		conn.close();
		return readerTypeForm1;
	}

	/* 添加读者类别信息 */
	public int insert(ReaderTypeForm readerTypeForm) {
		/*首先查询读者类别名称是否已经存在*/