Jsp/Servlet

Development Platform:

Java

PublishingDAO.java~3~：Code Content

							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;
}
}

						