jsp_servlet(2)
/*
author="evangelion"
*/
//record.jsp 实现的是根据名字查询到 相关信息
<%@ page language="java" pageEncoding="gbk"%>
<%@page import="com.sun.xml.internal.txw2.Document"%>
<%@page import="java.sql.ResultSet"%>
<jsp:useBean id="dbOp" class="com.tom.javaBean.JDBC">
<jsp:setProperty name="dbOp" property="*"/>
</jsp:useBean>
<html>
<head>
</head>
<body>
<form action="record.jsp" method="post">
输入名字
<input type="text" name="inputName"/>
<input type="submit" value="请假记录" />
</form>
<%
ResultSet rs=null;
System.out.println(dbOp.getInputName());
rs=dbOp.doQuery(dbOp.getInputName());
while(rs.next())
{
System.out.println("in while");
out.println("姓名:"+rs.getString(1));
out.println("请假日期:"+rs.getString(2));
out.println("请假天数:"+rs.getString(3));
out.println("缘由:"+rs.getString(4));
out.println("</br>");
}
%>
</body>
</html>