模糊查询怎么只显示数据库第一条，其他不显示

FromStranger 2015-06-19 11:37:08

mhcx_do.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8"

    pageEncoding="UTF-8"%>

<%@page import="java.sql.*,java.util.*" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">

<html>

<head>

<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">

<title>Insert title here</title>

</head>

<body background="image/bg5.jpg">

<center>

<%if(session.getAttribute("username")!=null) {

%>

<br>

<br>

<p align="center"><span style="color: red">查询内容如下：</span></p>

<br>

<%

request.setCharacterEncoding("UTF-8");

response.setCharacterEncoding( "utf-8" );

Class.forName("com.mysql.jdbc.Driver").newInstance();

String url="jdbc:mysql://127.0.0.1:3306/jsp";

String user="root";

String passwords="123456";

Connection conn=null;

PreparedStatement pstmt =null;

ResultSet rs=null;

String id =request.getParameter("Stuname");



%>

<% try{id =request.getParameter("Stuname");

} catch(Exception e) {}%>

<%String sql = " SELECT * FROM stu_info WHERE XM like '%"+id+"%'"; 

		  try{

			  conn=DriverManager.getConnection(url,user,passwords);

			  pstmt = conn.prepareStatement(sql); 

			  rs = pstmt.executeQuery(); %>

<%if(rs.next()) { 

	String ksh = rs.getString(1);

	String XM = rs.getString(2); 

	String XB = rs.getString(3);

	String zongfen = rs.getString(4);

	String luquzhuanye = rs.getString(5);

    String jiguang = rs.getString(7);

    String kelei = rs.getString(9);

    String kelei_h = rs.getString(8);

    String CSRQ = rs.getString(10);

    String ZXMC = rs.getString(12);

    String MZMC = rs.getString(15);

    String ZMMC = rs.getString(16);

%>			  

			  

<form action="" method="post">

<table border="2"bgcolor="ffffff"width="500" style="width: 869px;color:red;">

<tr bgcolor="ffffff"align="center">

<td><span style="color: red">高考号</span></td>

<td style="width: 60px;"><span style="color: red">名字</span></td>

<td style="width: 41px; "><span style="color: red">性别</span></td>

<td style="width: 41px; "><span style="color: red">总分</span></td>

<td style="width: 65px; "><span style="color: red">录取专业</span></td>

<td style="width: 65px; "><span style="color: red">籍贯</span></td>

<td><span style="color: red">科类</span></td>

<td style="width: 49px; "><span style="color: red">科类号</span></td>

<td style="width: 65px; "><span style="color: red">出生日期</span></td>

<td style="width: 65px; "><span style="color: red">毕业学校</span></td>

<td><span style="color: red">民族</span></td>

<td><span style="color: red">团员</span></td>

</tr>

<tr bgcolor="ffffff"align="center"> 

 <td><%=ksh%></td>

<td><%=XM%></td>

<td><%=XB%></td>

<td><%=zongfen%></td>

<td><%=luquzhuanye%></td>

<td><%=jiguang%></td>

<td><%=kelei%></td>

<td><%=kelei_h%></td>

<td><%=CSRQ%></td>

<td><%=ZXMC%></td>

<td><%=MZMC%></td>

<td><%=ZMMC%></td>

   </table></form> 



   <%

   }else{

     %><span style="color: red">没有发现，要查找的内容！！</span><br> <span style="color: red">请确认要查找的信息是否存在！！</span><br> 

   <%

   }

   %> 

   <%

   rs.close();

   pstmt.close();

   conn.close(); 

   } catch(Exception e) {}

   %>

   <h3> 

   <a href="xxcx.jsp">重新输入</a><br><br>

   <a href="right.jsp">回到功能列表页</a>

   </h3> 

    <%

    }else{

    	response.setHeader("refresh","2;URL=index.jsp");

    %> 

    <span style="color: red"><br>您还未登陆，请先登陆！！！</span><br> 

    <span style="color: red"><br>两秒后自动跳转到登陆窗口！！！</span><br>

     <span style="color: red"><br>如果没有跳转，请按</span>

  <a href="index.jsp"><span style="color: red"><br>这里</span></a><span style="color: red">！！！</span><br> 

  <%

  }

  %>

 </center>

</body>

</html>

mhcx.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8"

    pageEncoding="UTF-8"%>

    <%@page import="java.sql.*,java.util.*" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">

<html>

<head>

<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">

<title>信息查询</title>



</head>

<body background="image/bg3.jpg">



<br>

<br>

<br>

<br>

<br>



<p align=center><span style="color: red">数据查询</span></p>

<form action="mhcx_do.jsp" method="post" name="form4">

<p align="center"><span style="color: red">按关键字查询</span><input type="text"name="Stuname" />

</p>

<p align=center><input type="submit" value="查询" style="width: 91px;color:red "></p>

</form>



</body>

</html>

我把if换成while后，但else命令又不能用，求修改下

...全文

505 5 打赏收藏转发到动态举报

写回复

用AI写文章

5 条回复

切换为时间正序

请发表友善的回复…

发表回复

xuzuning 2015-06-21

打赏
举报

while(! rs.eof()) { ...... rs.next(); }

slwsss 2015-06-20

打赏
举报

SELECT * FROM stu_info WHERE XM like '%"+id+"%' limit 1";

FromStranger 2015-06-20

打赏
举报

引用 1 楼 slwsss 的回复:

SELECT * FROM stu_info WHERE XM like '%"+id+"%' limit 1";

还是不行<%if(rs.next()) { String ksh = rs.getString(1); String XM = rs.getString(2); String XB = rs.getString(3); String zongfen = rs.getString(4); String luquzhuanye = rs.getString(5); String jiguang = rs.getString(7); String kelei = rs.getString(9); String kelei_h = rs.getString(8); String CSRQ = rs.getString(10); String ZXMC = rs.getString(12); String MZMC = rs.getString(15); String ZMMC = rs.getString(16); %> 是不是 if换成while啊，但换了，就报错

FromStranger 2015-06-20