📄 finisha.txt
字号:
<%@ page contentType="text/html;charset=gb2312" %>
<jsp:directive.page import="java.sql.ResultSet"/>
<jsp:directive.page import="java.util.Date"/>
<%
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("update Question set Acontent=? where Qno=?");
//sqlRst=sqlStmt.executeQuery(sqlQuery);
//String Qct=new String (request.getParameter("Qcontent").getBytes("gb2312"));
String Act=new String (request.getParameter("Acontent").getBytes("gb2312"));
String no=request.getParameter("Qno");
//String name=request.getParameter("parm");
//Date date=new java.util.Date();
response.setContentType("text/html;charset=gb2312");
preparedStmt.setString(1,Act);
preparedStmt.setString(2,no);
preparedStmt.executeUpdate();
%>
<html>
<a>添加答案成功！</a>
<a href=addA.jsp>返回</a>
</html>
<%
//sqlRst.close();
preparedStmt.close();
conn.close();
}catch(java.sql.SQLException e){
out.println(e.toString());
}
%>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -