?? adsrarchbookcontroller.java
字號:
import java.io.IOException;
import java.sql.ResultSet;
import java.util.Vector;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
import library.DBConnection;
public class AdSrarchBookController extends Controller {
@SuppressWarnings("unchecked")
public void doPost (HttpServletRequest req,
HttpServletResponse res) throws ServletException, IOException {
HttpSession session = req.getSession();
//req.setCharacterEncoding("GB2312");
String id = new String(req.getParameter("id").getBytes("ISO-8859-1"),"GB2312");
String name = new String(req.getParameter("bookname").getBytes("ISO-8859-1"),"GB2312");
String auther =new String( req.getParameter("auther").getBytes("ISO-8859-1"),"GB2312");
String publisher = new String(req.getParameter("publisher").getBytes("ISO-8859-1"),"GB2312");
String isbn = new String(req.getParameter("isbn").getBytes("ISO-8859-1"),"GB2312");
String publishData = new String(req.getParameter("publishData").getBytes("ISO-8859-1"),"GB2312");
session = req.getSession();
boolean find = true;
if(id.equals("")&&name.equals("")&&
auther.equals("")&&publisher.equals("")&&
publishData.equals("")){
find = false;
}
try{
if(find==false){
res.sendRedirect("../admin/searchBook.jsp?jieguo=failed");
}else{
String sql = "select * from books,booktitle where ";
if(!id.equals("")){
sql += "findid = '"+id+"'";
}
if(!name.equals("")&&!sql.endsWith("where ")){
sql += "and name like '%"+name+"%'";
}
if(!name.equals("")&&sql.endsWith("where ")){
sql += "name like '%"+name+"%'";
}
if(!auther.equals("")&&!sql.endsWith("where ")){
sql += "and aurher like '%"+auther+"%'";
}
if(!auther.equals("")&&sql.endsWith("where ")){
sql += " auther like '%"+auther+"%'";
}
if(!publisher.equals("")&&!sql.endsWith("where ")){
sql += "and publisher like '%"+publisher+"%'";
}
if(!publisher.equals("")&&sql.endsWith("where ")){
sql += " publisher like '%"+publisher+"%'";
}
if(!isbn.equals("")&&!sql.endsWith("where ")){
sql += "and isbn = '"+isbn+"'";
}
if(!isbn.equals("")&&sql.endsWith("where ")){
sql += " isbn = '"+isbn+"'";
}
if(!publishData.equals("")&&!sql.endsWith("where ")){
sql += "and publishData = '"+publishData+"'";
}
if(!publishData.equals("")&&sql.endsWith("where ")){
sql += " publishData = '"+publishData+"'";
}
DBConnection connection = DBConnection.Instance();
ResultSet w = null;
Vector vector = new Vector();
w = connection.runQuery(sql);
while(w.next()){
boolean add=true;
String hh = "";
for(int i=0;i<vector.size();i++){
hh = (String)vector.get(i);
if(hh.equals(w.getString("books.isbn"))){
add = false;
}
}
if(add==true){
vector.add(w.getString("books.isbn"));
}
;
//res.sendRedirect("../admin/new.jsp?l="+w.getString("readerid"));
}
session.setAttribute("rdsearchbookresult", vector);
res.sendRedirect("../admin/searchbookresult.jsp");
}
}catch(Exception e){
sendErrorRedirect(req, res, e);
}
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -