📄 lunwen.jsp
字号:
<%@ page language="java" import="java.util.*" contentType="text/html; charset=UTF-8"import="java.sql.*" %><%@page import="java.io.*" import="java.lang.*"%><%@page import="javax.xml.parsers.DocumentBuilderFactory,javax.xml.parsers.DocumentBuilder,org.w3c.dom.*"%><%@ page pageEncoding="UTF-8"%><%! Connection conn=null; %><jsp:useBean id="db_conn" scope="page" class="user.DB"/><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html> <head> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> <title>查看论文</title> </head> <body> <%! public String hanzi(String str)//识别汉字 { try { byte[] bytesStr=str.getBytes("ISO-8859-1"); String hanzichange; return hanzichange=new String(bytesStr,"UTF-8"); } catch(Exception e) {return null;} } public String xml_bufen(NodeList bufen)//从xml文档中取出相应的内容 { String bufen_Sum=""; for(int j=0;j<bufen.getLength();j++) { String bufen_Along=null; bufen_Along=bufen.item(j).getFirstChild().getNodeValue(); bufen_Sum=bufen_Sum+bufen_Along; } return bufen_Sum; } %> <% // Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance(); // String url="jdbc:microsoft:sqlserver://localhost;DatabaseName=xy"; // String user="sa"; //String password="a"; // Connection conn= DriverManager.getConnection(url,user,password); if(conn==null) {conn=db_conn.getConnection();}//连接数据库 Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY); //得到要查看的文章号 String lunwen_ID=request.getParameter("lunwen_ID"); System.out.println("dfs:"+lunwen_ID); String sql="update discourse set times=times+1 where ID='"+lunwen_ID+"'"; //此文章的浏览次数加一 stmt.executeUpdate(sql); String lunwen_address_title=""; String title_dizhi=""; String lunwen_rules=""; String shishi="select title,address,rules from discourse where ID='"+lunwen_ID+"'";//取出这个文章的地址 ResultSet rs_shishi=stmt.executeQuery(shishi); if(rs_shishi.next()) { lunwen_address_title=rs_shishi.getString("title"); title_dizhi=rs_shishi.getString("address"); lunwen_rules=rs_shishi.getString("rules"); } String dizhi=""; //存放分开后的各部分，此地址格式，xml解析器不认识，需要重新组合 StringTokenizer dizhi_sTokenizer=new StringTokenizer(title_dizhi,"\\");//去掉\ dizhi=dizhi_sTokenizer.nextToken(); while(dizhi_sTokenizer.hasMoreTokens()) { dizhi=dizhi+"/"+dizhi_sTokenizer.nextToken(); } DocumentBuilderFactory dbf=DocumentBuilderFactory.newInstance(); DocumentBuilder db=dbf.newDocumentBuilder(); File lunwen=new File(dizhi); Document doc=db.parse(lunwen); NodeList title=doc.getElementsByTagName("CHINESE_TITLE");//分析xml文档 NodeList name=doc.getElementsByTagName("NAME"); NodeList abtract=doc.getElementsByTagName("CHINESE_ABTRACT"); NodeList keyword=doc.getElementsByTagName("CHINESE_KEYWORD"); String title_Sum=xml_bufen(title); String abtract_Sum=xml_bufen(abtract); %><table width="610" height="671" border="0" align="center"> <tr> <td height="58" align="center" valign="middle"><%out.println(title_Sum);%></td> </tr> <tr> <td height="59" align="center" valign="middle"><% out.print("作 者: "); for(int i=0;i<name.getLength();i++) { String str; try{ str=name.item(i).getFirstChild().getNodeValue()+" "; } catch(Exception e) { continue; } out.println(str); } %> </td> </tr> <tr> <td height="62"><% out.print("关键字: "); for(int i=0;i<keyword.getLength();i++) { String str; try{ str=keyword.item(i).getFirstChild().getNodeValue()+" "; } catch(Exception e) { continue; } out.println(str); }%></td> </tr> <tr> <td height="185"><%out.println("摘要:"+abtract_Sum);%></td> </tr> <tr> <td height="293">相关文章: <% if(lunwen_rules!=null) { System.out.println("dfs"); StringTokenizer rules_sTokenizer=new StringTokenizer(lunwen_rules,"\\");//去掉\ while(rules_sTokenizer.hasMoreTokens()) { String rules_ID=rules_sTokenizer.nextToken(); String sql_xiangguan="select ID,title from discourse where id='"+rules_ID+"'" ; //sql语句 ; ResultSet rs_xiangguan=stmt.executeQuery(sql_xiangguan); if(rs_xiangguan.next()) { int ppk=rs_xiangguan.getInt("ID"); String sppk=Integer.toString(ppk); String rules_title=rs_xiangguan.getString("title"); %> <p><a href="lunwen.jsp?lunwen_ID=<%=sppk%>"><%=rules_title%></a> <% } } } else { out.println("没有相关文章"); }%> <% stmt.close(); conn.close();%> </td> </tr></table> </body></html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -