📄 qanda.txt
字号:
<%@ page contentType="text/html;charset=GB2312" %>
<html>
<body bgcolor="DDEECC">
<% request.setCharacterEncoding("gb2312");%>
欢迎您！请选择如下链接进入疑难解答科目<%=request.getParameter("name")%><br>
<%
java.sql.Connection conn;
//java.lang.String strConn;
java.sql.Statement sqlStmt;
java.sql.ResultSet sqlRst=null;
int flag=0;
//java.lang.String strConn;
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(java.sql.ResultSet.TYPE_SCROLL_INSENSITIVE,java.sql.ResultSet.CONCUR_READ_ONLY);
String sqlQuery="select * from Course";
sqlRst=sqlStmt.executeQuery(sqlQuery);
response.setContentType("text/html;charset=gb2312");
request.setCharacterEncoding("gb2312");
%>
<table border="1" width="30%" bordercolorlight="#CC99FF" cellpadding="2" bordercolordark="#FFFFFF" cellspacing="0">
<tr>
<td align="left"> 编号</td>
<td align="left">科目</td>
</tr>
<%
while(sqlRst.next()){
%>
<tr>
<td><%=sqlRst.getString("Cno") %></td>
<td><%=new String(sqlRst.getString("Cname").getBytes("gb2312")) %></td>
</tr>
<% } %>
</table>
<br>
请选择:
<form action="lookup.jsp" method="post">
<input name="parm" value=""></input>
<input type="submit" name="Submit2" value="提交">
</form>
<form action="add.jsp">
提问问题：<input name="parm" value=""></input>
<input type="text" name="Qcontent">
<input type="submit" value="提交">
</form>
<%
sqlRst.close();
sqlStmt.close();
conn.close();
}catch(java.sql.SQLException e){
out.println(e.toString());
}
%>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -