📄 newscontent.jsp

📁 基于JSP的公交查询系统,很好用的,适于学习,操作语句全在jsp页面里

💻 JSP

字号:

<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%@ page import="java.util.*" %>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">

<STYLE type=text/css>
BODY {
	FONT-SIZE: 13px; FONT-FAMILY: 宋体; TEXT-ALIGN: center
}
TR {
	FONT-SIZE: 13px; FONT-FAMILY: 宋体; TEXT-ALIGN: center
}
TD {
	FONT-SIZE: 13px; FONT-FAMILY: 宋体; TEXT-ALIGN: center
}
.style1 {color: #FF0000}
</STYLE>

<META content="MSHTML 6.00.2900.2995" name=GENERATOR><title>车次查询结果</title></HEAD>
<BODY>
<%  ResultSet result;
    Connection con;

   String title=new String(request.getParameter("title").getBytes("ISO8859_1"),"GBK");
    String content="";
   try{ Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
	     }
		catch(ClassNotFoundException e){}
		 
	try{  
	      con=DriverManager.getConnection("jdbc:odbc:nbos","","");
	      Statement sql=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY); 
		  String statement="select * from News where Title='"+title+"'";
		  result=sql.executeQuery(statement);
		  if(result.next())
		     {  
			  content=result.getString("Content");
			  }  
			   
		  
	      
			result.close();
			
	  } catch(Exception e) {  }
	  
	 

%>
<TABLE cellSpacing=1 cellPadding=3 width=650 align=center bgColor=#003399 
border=0>
  <TBODY>
  <TR>
    <TD background=Picture/topbg.gif height=20></TD>
  </TR>
  <TR bgColor=#7da4ec>
    <TD><STRONG><FONT color=#ffffff>
      
      <%=title%></FONT></STRONG></TD>
  </TR>
  <TR bgColor=#e8f3ff>
    <TD><!--查询结果显示开始-->
      <TABLE cellSpacing=1 cellPadding=3 width=500 bgColor=#003399 border=0>
        <TBODY>
        <TR bgColor=#fddd90>
          <TD><%=content%></TD>
          </TR>
     
		</TBODY></TABLE>
      <!--查询结果显示结束--><BR>        <IMG 
      src="Picture/close_window.gif" width="78" height="21" border=0 
      style="CURSOR: hand" onclick=window.close()> </TD>
  </TR>
  
  <TR>
    <TD background=Picture/bottombg.gif 
height=20></TD>
  </TR></TBODY></TABLE> 
</BODY></HTML>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -