JSP+SQL实现了一个拥有添加、删除、查询基本功能的CRM系统

源代码在线查看: 复件_00020selectsfzy_0002ejsp_jsp.java

软件大小: 4264 K
上传用户: KuFly
关键词: JSP CRM SQL 删除
下载地址: 免注册下载 普通下载 VIP

相关代码

				package jsp.information.queryInformation;
				
				import java.sql.*;
				import java.util.List;
				import java.util.ArrayList;
				import com.domain.FfzyForm;
				import javax.servlet.*;
				import javax.servlet.http.*;
				import javax.servlet.jsp.*;
				import org.apache.jasper.runtime.*;
				
				
				public class 复件_00020selectSfzy_0002ejsp_jsp extends HttpJspBase {
				
				
				    static {
				    }
				    public 复件_00020selectSfzy_0002ejsp_jsp( ) {
				    }
				
				    private static boolean _jspx_inited = false;
				
				    public final void _jspx_init() throws org.apache.jasper.runtime.JspException {
				    }
				
				    public void _jspService(HttpServletRequest request, HttpServletResponse  response)
				        throws java.io.IOException, ServletException {
				
				        JspFactory _jspxFactory = null;
				        PageContext pageContext = null;
				        HttpSession session = null;
				        ServletContext application = null;
				        ServletConfig config = null;
				        JspWriter out = null;
				        Object page = this;
				        String  _value = null;
				        try {
				
				            if (_jspx_inited == false) {
				                synchronized (this) {
				                    if (_jspx_inited == false) {
				                        _jspx_init();
				                        _jspx_inited = true;
				                    }
				                }
				            }
				            _jspxFactory = JspFactory.getDefaultFactory();
				            response.setContentType("text/html; charset=gb2312");
				            pageContext = _jspxFactory.getPageContext(this, request, response,
				            			"", true, 8192, true);
				
				            application = pageContext.getServletContext();
				            config = pageContext.getServletConfig();
				            session = pageContext.getSession();
				            out = pageContext.getOut();
				
				            // HTML // begin [file="/jsp/information/queryInformation/复件 selectSfzy.jsp";from=(0,63);to=(1,0)]
				                out.write("\r\n");
				
				            // end
				            // HTML // begin [file="/jsp/information/queryInformation/复件 selectSfzy.jsp";from=(1,30);to=(2,0)]
				                out.write("\r\n");
				
				            // end
				            // HTML // begin [file="/jsp/information/queryInformation/复件 selectSfzy.jsp";from=(2,34);to=(3,0)]
				                out.write("\r\n");
				
				            // end
				            // HTML // begin [file="/jsp/information/queryInformation/复件 selectSfzy.jsp";from=(3,39);to=(4,0)]
				                out.write("\r\n");
				
				            // end
				            // HTML // begin [file="/jsp/information/queryInformation/复件 selectSfzy.jsp";from=(4,39);to=(18,0)]
				                out.write("\r\n\r\n\r\n\r\n省份表\r\n\r\n\r\n\r\n\r\n\r\n");
				
				            // end
				            // begin [file="/jsp/information/queryInformation/复件 selectSfzy.jsp";from=(18,2);to=(27,0)]
				                int maxPage=0;
				                List list=(List)request.getAttribute("sfzylist");
				                int total=Integer.parseInt((String)request.getAttribute("total"));
				                int iCount=Integer.parseInt((String)request.getAttribute("iCount"));
				                if(maxPage%5==0){
				                maxPage=maxPage/5;
				                }else{
				                maxPage=maxPage/5+1;
				                }
				            // end
				            // HTML // begin [file="/jsp/information/queryInformation/复件 selectSfzy.jsp";from=(27,2);to=(29,13)]
				                out.write("\r\n\r\n  省份表 ");
				
				            // end
				            // begin [file="/jsp/information/queryInformation/复件 selectSfzy.jsp";from=(29,16);to=(29,21)]
				                out.print(total);
				            // end
				            // HTML // begin [file="/jsp/information/queryInformation/复件 selectSfzy.jsp";from=(29,23);to=(29,28)]
				                out.write(" ");
				
				            // end
				            // begin [file="/jsp/information/queryInformation/复件 selectSfzy.jsp";from=(29,31);to=(29,37)]
				                out.print(iCount);
				            // end
				            // HTML // begin [file="/jsp/information/queryInformation/复件 selectSfzy.jsp";from=(29,39);to=(37,0)]
				                out.write("\r\n\r\n  \r\n    \r\n      省份编号\r\n      省份名称\r\n      操作\r\n    \r\n");
				
				            // end
				            // begin [file="/jsp/information/queryInformation/复件 selectSfzy.jsp";from=(37,2);to=(39,0)]
				                for (int i=0;i				                FfzyForm form =(FfzyForm)list.get(i);
				            // end
				            // HTML // begin [file="/jsp/information/queryInformation/复件 selectSfzy.jsp";from=(39,2);to=(41,10)]
				                out.write("\r\n    \r\n      ");
				
				            // end
				            // begin [file="/jsp/information/queryInformation/复件 selectSfzy.jsp";from=(41,13);to=(41,30)]
				                out.print(form.getSfzy_id());
				            // end
				            // HTML // begin [file="/jsp/information/queryInformation/复件 selectSfzy.jsp";from=(41,32);to=(42,10)]
				                out.write("\r\n      ");
				
				            // end
				            // begin [file="/jsp/information/queryInformation/复件 selectSfzy.jsp";from=(42,13);to=(42,32)]
				                out.print(form.getSfzy_sfmc());
				            // end
				            // HTML // begin [file="/jsp/information/queryInformation/复件 selectSfzy.jsp";from=(42,34);to=(43,44)]
				                out.write("\r\n      				
				            // end
				            // begin [file="/jsp/information/queryInformation/复件 selectSfzy.jsp";from=(43,47);to=(43,64)]
				                out.print(form.getSfzy_id());
				            // end
				            // HTML // begin [file="/jsp/information/queryInformation/复件 selectSfzy.jsp";from=(43,66);to=(43,130)]
				                out.write("\">查看地理位置    				
				            // end
				            // begin [file="/jsp/information/queryInformation/复件 selectSfzy.jsp";from=(43,133);to=(43,152)]
				                out.print(form.getSfzy_sfmc());
				            // end
				            // HTML // begin [file="/jsp/information/queryInformation/复件 selectSfzy.jsp";from=(43,154);to=(45,0)]
				                out.write("\">查看具体城市\r\n    \r\n");
				
				            // end
				            // begin [file="/jsp/information/queryInformation/复件 selectSfzy.jsp";from=(45,2);to=(45,3)]
				                }
				            // end
				            // HTML // begin [file="/jsp/information/queryInformation/复件 selectSfzy.jsp";from=(45,5);to=(47,39)]
				                out.write("\r\n  \r\n  				
				            // end
				            // begin [file="/jsp/information/queryInformation/复件 selectSfzy.jsp";from=(47,42);to=(47,50)]
				                out.print(iCount-1);
				            // end
				            // HTML // begin [file="/jsp/information/queryInformation/复件 selectSfzy.jsp";from=(47,52);to=(47,125)]
				                out.write("\">上一页      				
				            // end
				            // begin [file="/jsp/information/queryInformation/复件 selectSfzy.jsp";from=(47,128);to=(47,136)]
				                out.print(iCount+1);
				            // end
				            // HTML // begin [file="/jsp/information/queryInformation/复件 selectSfzy.jsp";from=(47,138);to=(51,0)]
				                out.write("\">下一页\r\n\r\n\r\n\r\n");
				
				            // end
				
				        } catch (Throwable t) {
				            if (out != null && out.getBufferSize() != 0)
				                out.clearBuffer();
				            if (pageContext != null) pageContext.handlePageException(t);
				        } finally {
				            if (_jspxFactory != null) _jspxFactory.releasePageContext(pageContext);
				        }
				    }
				}
							

相关资源