jsp怎么修改sql语句实现查询功能
怎么获取输入框的值,点击查询获取单个学生信息 更新表格的数据啊 详细一点 最好能写一下 比较急
<div id ="stu_biao" class="sty_body">
<sql:query dataSource="${snapshot}" var="result">
SELECT * from stu_info;
</sql:query>
<%
if(session.getAttribute("Islogin") == "3"){
%>
<div>
<div>
<table align="center" border="1" cellpadding="0" cellspacing="0" style="font-family: 楷体;
font-weight: 20px;
font-size: 20px;position: absolute;
margin-top: 50px;margin-left: 200px;" >
<tr align="center">
<th>姓名</th>
<th>学号</th>
<th>性别</th>
<th>宿舍</th>
<th>专业</th>
<th>电话</th>
<th>签到状态</th>
<th>缴费状态</th>
<th>密码</th>
<th>操作</th>
</tr>
<c:forEach var="row" items="${result.rows}">
<tr>
<td><c:out value="${row.stu_name}"/></td>
<td><c:out value="${row.stu_id}"/></td>
<td><c:out value="${row.stu_sex}"/></td>
<td><c:out value="${row.stu_adr}"/></td>
<td><c:out value="${row.stu_maj}"/></td>
<td><c:out value="${row.stu_tel}"/></td>
<td><c:out value="${row.stu_sign}"/></td>
<td><c:out value="${row.stu_fee}"/></td>
<td><c:out value="${row.stu_psw}"/></td>
<td>
<a href="editStu.jsp?editid=${row.stu_id}"><button>修改</button></a>
<a href='javascript:confirmDeleteStu("${row.stu_id}")'><button>删除</button></a>
</td>
</tr>
</c:forEach>
</table>
</div>
<div style="position: relative;">
<input type="button" value="添加学生" onclick="showRegister();"id="sub_bt_2" >
<input type="text" style="margin-left: 400px;"placeholder="输入学号" name="stu_select_id">
<button onclick="">查询</button><button>重置</button>
</div>
</div>