publishingdao.java~3~

图书馆管理系统 第1章 系统简介 图书馆是各大高等院校的重要组成部门

package com.dao;

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

public class PublishingDAO {
    private ConnDB conn=new ConnDB();
//查询数据
public Collection query(String strif){
PublishingForm bookTypeForm=null;
Collection bookTypeColl=new ArrayList();
String sql="";
if(strif!="all" && strif!=null && strif!=""){
    sql="select * from tb_bookType where "+strif+"";
}else{
    sql="select * from tb_bookType";
}
ResultSet rs=conn.executeQuery(sql);
try {
    while (rs.next()) {
        bookTypeForm=new PublishingForm();
        bookTypeForm.setId(Integer.valueOf(rs.getString(1)));
        bookTypeForm.setTypeName(rs.getString(2));
        bookTypeForm.setDays(rs.getInt(3));
        bookTypeColl.add(bookTypeForm);
        System.out.print(bookTypeForm.getTypeName());
    }
} catch (SQLException ex) {
}
conn.close();
return bookTypeColl;
}

}