<%@ page language="java" import="java.util.*,com.fit.*,java.sql.*" pageEncoding="gbk"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()
+":"+request.getServerPort()+path+"/";
%>
<html>
<head>
</head>
<body>
<center>
<%
int pagesize=10;//每页显示的条数
int currentpage=1;//当前页数
int allsize=30;//总记录数
String keyword=null;
%>
<%
keyword = request.getParameter("text");
%>
<%
request.setCharacterEncoding("gbk");
Connection conn = Jdbc.getConn();
Statement stmt = conn.createStatement();
String sql1=null;
if(keyword==null){
sql1 = "select count(*) from person";
}else{
sql1 = "select count(*) from person where uid like '%"+keyword+"%' or name like
'%"+keyword+"%'";
//System.out.println(sql1);
}
ResultSet rs1 = stmt.executeQuery(sql1);
if(rs1.next()){
allsize = rs1.getInt(1);
rs1.close();
}
String sql=null;
if(keyword==null){
sql = "select * from person";
}else{
sql = "select * from person where uid like '%"+keyword+"%' or name like '%"+keyword+"%'";
}
stmt = conn.createStatement();
评论0
最新资源