📄 lookup.jsp
字号:
<%@ page contentType="text/html;charset=gb2312" %>
<jsp:directive.page import="java.sql.ResultSet"/>
<%
java.sql.Connection conn;
//java.sql.Statement sqlStmt;
java.sql.PreparedStatement preparedStmt;
java.sql.ResultSet sqlRst=null;
request.setCharacterEncoding("gb2312");
try{
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver").newInstance();
conn =java.sql.DriverManager.getConnection("jdbc:sqlserver://localhost;user=sa;password=987613");
conn.setCatalog("QandA");
//sqlStmt=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
preparedStmt=conn.prepareStatement("select Qno,Qcontent,Acontent from Question where Cname = ?");
//String sqlQuery="select Qno,Qcontent,Acontent from Question where Cname=?";
//sqlRst=sqlStmt.executeQuery(sqlQuery);
String parm=request.getParameter("parm");
preparedStmt.setString(1,parm);
sqlRst=preparedStmt.executeQuery();
response.setContentType("text/html;charset=gb2312");
%>
<html>
<%=request.getParameter("parm")%>知识问答库：
<table>
<td align="left">编号</td>
<td align="left">问题</td>
<td align="left">答案</td>
<% while(sqlRst.next()){ %>
<tr>
<td><%=sqlRst.getString("Qno") %></td>
<td><%=new String(sqlRst.getString("Qcontent").getBytes("gb2312")) %></td>
<td><%=new String(sqlRst.getString("Acontent").getBytes("gb2312")) %></td>
</tr>
<% } %>
</table>
<a href=QandA.jsp>返回</a>
</html>
<%
sqlRst.close();
//sqlStmt.close();
preparedStmt.close();
conn.close();
}catch(java.sql.SQLException e){
out.println(e.toString());
}
%>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -