现在,我正在执行此代码,正在处理提交按钮单击。

<%@page import="java.sql.CallableStatement"%>
<%@page import="javax.imageio.ImageIO"%>
<%@page import="java.io.ByteArrayOutputStream"%>
<%@page import="java.awt.image.BufferedImage"%>
<%@page import="java.io.InputStream"%>
<%@page import="java.sql.ResultSet"%>
<%@page import="connectionss.Connectionss"%>

<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
    pageEncoding="ISO-8859-1"%>
<!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=ISO-8859-1">
<title>Insert title here</title>
</head>
<body>

<form  action="ShowUSerInfo.jsp" method="post">
        <input type="text"  name="tagID">
        <input type="submit" value="Search" name="submit" >
</form>

             <%
             String TAGID="";
             String y=request.getParameter("submit");

                 if("Search".equals(y))
                    {
                TAGID = request.getParameter("tagID");
                out.println(TAGID);


                    String GetUserpass = "{call sp_USerInfoByTagID(?)}";
                    //Connection conn = Connection.GetConnection();
                    CallableStatement cs;
                    cs =  Connectionss.GetConnection().prepareCall(GetUserpass);
                    cs.setString(1,TAGID);
               %>

                    <table border="1">
                    <th>First Name</th>
                    <th>last Name Name</th>
                    <th>Student ID</th>
                    <th>Address</th>
                      <th>NIC</th>

                    <%
                        ResultSet rs1;
                        rs1=cs.executeQuery();
                        while(rs1.next()){

                            String UserName=rs1.getString("fId_FirstName");

                            String UserID= rs1.getString("fId_User_UniversityID");
                            String Adress = rs1.getString("fId_Address");
                            String NIC = rs1.getString("fId_NIC");
                            String lastName = rs1.getString("fId_LastName");

                            %>

                <tr >

                <td><span style="color:red;"><%= UserName %></span></td>
                <td> <span style="color:red;"><%= lastName %></span></td>
                <td><span style="color:red;"><%= UserID %></span></td>
                <td><span style="color:red;"><%= Adress %></span></td>
                <td><span style="color:red;"><%= NIC %></span></td>

                </tr>

                </table>

           <%}} %>

</body>
</html>


但是我想在输入框上的文本更改时执行此代码。基本上,文本框将从NFC卡中获取价值。因此,当我在读取器上点击我的NFC卡时,“值已转移到文本框”,此时我要执行我的sql查询,该查询将针对TAGID接收用户信息。

最佳答案

由于jsp是服务器端,因此您需要收集客户机上的输入并进行ajax调用。

<form  action="ShowUSerInfo.jsp" method="post">
       <input type="text" id="text"  name="tagID">
       <input type="submit" value="Search" name="submit" >
</form>
    <div id="#res></div>


javascript:

   $('#text').change(function(e){
      $.ajax({url: "someurl", success: function(result){
             $("#res").html(result);
          }});
        });
  });

09-10 07:14
查看更多