招商银行——学生卡

<%@ page contentType="text/html;charset=utf-8"%> <%@ page language="java" import="java.net.*" %> <%@ page language="java" import="java.sql.*" %> <%@ include file="./include/common.jsp"%> <% DBbean.setupConnection("cmbcard"); String sqlStr = ""; ResultSet rs; int num; if(request.getParameter("vote") != null&&request.getParameter("vote") != "0"){ sqlStr="select num from voteip where cid = '"+request.getParameter("id")+"' and IP ='"+ request.getRemoteAddr() +"'"; rs=DBbean.executeQuery(sqlStr); if(rs.next()) num = rs.getInt("num"); else num = 0; if(num >= 5){ %> <% }else{ %> <% if(num == 0){ SQLbean.DoSql("insert into voteip (IP,cid,num)values('"+ request.getRemoteAddr() +"','"+request.getParameter("id")+"','1')"); }else{ SQLbean.DoSql("update voteip set num=num+1 where cid='"+request.getParameter("id")+"' and IP = '"+ request.getRemoteAddr() +"'"); } SQLbean.DoSql("update cartoons set clicks=clicks+1 where id='"+request.getParameter("id")+"'"); } } DBbean.closeConnection(); DBbean.setupConnection("cmbcard"); String OrderWay[]={" order by a.id DESC"," order by a.click DESC"}; sqlStr="select a.*,b.reg_uname from cartoons a left join reg b on b.id = a.uid where a.verified = '1' "+OrderWay[Pagebean.getOrderWayId()]+Pagebean.getAbc(); rs=DBbean.executeQuery(sqlStr); Pagebean.setAllPages(SQLbean.GetSelect("select count(*) from cartoons")); String pageNum = request.getParameter("pageNum"); %> 招商银行——学生卡