📄 add.jsp
字号:
<%@ 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("insert into Question(Qno,Qcontent,Cname)"+" values(?,?,?)");
String sqlQuery="select * from Question";
sqlRst=sqlStmt.executeQuery(sqlQuery);
//String Qct=new String (request.getParameter("Qcontent").getBytes("gb2312"));
String Qct=new String (request.getParameter("Qcontent").getBytes("gb2312"));
String name=request.getParameter("parm");
//Date date=new java.util.Date();
response.setContentType("text/html;charset=gb2312");
int n=0;
while(sqlRst.next())
{
//java.sql.Blob blob=sqlRst.getBlob("Qcontent");
//byte[] ab=blob.getBytes(1,(int)blob.length());
response.setContentType("text/html;charset=gb2312");
//op.write(ab);
//op.flush();
//op.close();
n++;
}
preparedStmt.setString(2,Qct);
//preparedStmt.setString(2,Qct);
preparedStmt.setString(3,name);
preparedStmt.setInt(1,n+1);
//preparedStmt.setDate(4,date);
preparedStmt.executeUpdate();
//ServletOutputStream op=response.getOutputStream();
%>
<html>
<a>添加问题成功！</a>
<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 + -