WebRoot/jsp/type/selecttype.jsp

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

<%@ page language="java" contentType="text/html; charset=GB2312"  pageEncoding="GB2312"%>
<%@page import="com.book.dao.DBHelper"%>
<%@page import="java.sql.*"%>
<%@page import="java.util.*"%>
<%@page import="com.book.pojo.*"%>
<%@page import="com.book.util.*"%>
<%
	String type_name = request.getParameter("type_name");
	
	if(type_name != null && !"".equals(type_name)){
		Connection conn =null;
		PreparedStatement ps = null;
		ResultSet rs = null;
		List list = new ArrayList();
		try{
		 	conn = DBHelper.getConnection();
		 	ps = conn.prepareStatement("select * from  book_type where type_name like '%"+Util.encodeGB2312(type_name)+"%'");
		 	rs = ps.executeQuery();
		 	while(rs.next()){
		 		BookType type = new BookType();
		 		type.setType_id(rs.getInt(1));
		 		type.setType_name(rs.getString(2));
		 		list.add(type);
	 		}
	 		request.setAttribute("typeList",list);
		}catch(Exception e){
			e.printStackTrace();
		}finally{
			DBHelper.close(conn,ps,null);
		}
		request.getRequestDispatcher("typeList.jsp").forward(request,response);
		return;
	}
 %>