📄 adda.txt
字号:
<%@ 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 from Question where Acontent IS NULL");
String sqlQuery="select Qno,Qcontent,Cname from Question where Acontent IS NULL";
sqlRst=sqlStmt.executeQuery(sqlQuery);
//sqlRst=preparedStmt.executeQuery();
response.setContentType("text/html;charset=gb2312");
%>
<html>
知识问答库：
<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("Cname").getBytes("gb2312")) %></td>
<td><%=new String(sqlRst.getString("Qcontent").getBytes("gb2312")) %></td>
</tr>
<% } %>
</table>
<form action=finishA.jsp >
回答问题：<input type="text" name="Qno">
<input type="text" name="Acontent">
<input type="submit" value="提交">
</form>
</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 + -