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 + -
显示快捷键?