resultprocess.jsp
来自「Lucene+nuctch一书的全部源码 测试源码 和几个简单的项目」· JSP 代码 · 共 64 行
JSP
64 行
<%@ page language="java" contentType="text/html; charset=GB2312"
pageEncoding="GB2312"%>
<%@ page import="java.sql.*"%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=GB2312">
<title></title>
</head>
<body>
<table align="left">
<tr>
<td align="left" width="100">id号</td>
<td align="left" width="100">关键词</td>
<td align="left" width="100">权重</td>
</tr>
<%
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
String url = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=console";
Connection con = DriverManager.getConnection(url, "sa", "sa");
Statement stmt = con.createStatement(
ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_READ_ONLY);
ResultSet rs1;
String keyword = request.getParameter("keyword");
String power2 = request.getParameter("power");
if (keyword == "" || power2 =="") {
} else {
int power3 = Integer.valueOf(power2).intValue();
String keywords = new String(keyword.getBytes("ISO-8859-1"));
String sqlinsert = "INSERT INTO keywordstable (keyword,power) values ('"
+ keywords + "'," + power3 + ")";
stmt.executeUpdate(sqlinsert);
out.print("保存成功");
}
String sqlread = " select * from keywordstable";
rs1 = stmt.executeQuery(sqlread);
while (rs1.next())
{
String idid = rs1.getString("id");
String key = rs1.getString("keyword");
String pow = rs1.getString("power");
out.print("<tr>");
out.print("<td >");
out.print(idid);
out.print("</td>");
out.print("<td>");
out.print(key);
out.print("</td>");
out.print("<td>");
out.print(pow);
out.print("</td>");
out.print("</tr>");
}
%>
</table>
</body>
</html>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?