JSP+JAVABEAN兩層模開發式（新聞中心模組的實現）

最後更新：2018-12-05 來源：互聯網

上載者：User

創建阿里雲帳戶，並獲得超過 40 款產品的免費試用版；而企業帳戶則可以享有總值 $1200 的免費試用版。立即註冊！

1.conn.java

package news;
import java.sql.*;

public class conn {


String sDBDriver="org.gjt.mm.mysql.Driver";
   String sConnStr="jdbc:mysql://localhost/test";
   Connection connect =null;
   ResultSet rs=null;

   public conn()
   {

       try {Class.forName(sDBDriver);

    } catch (Exception e) {e.printStackTrace();}

    }


    public ResultSet executeQuery (String sql) {

        try{
        connect=DriverManager.getConnection(sConnStr,"test_root","test_root");
        Statement stmt=connect.createStatement();
        rs=stmt.executeQuery(sql);
        }catch(SQLException ex){System.err.println(ex.getMessage());}
        return rs;
    }

    public int executeUpdate(String sql){
        int result=0;
        try {
            connect=DriverManager.getConnection(sConnStr,"test_root","test_root");
            Statement stmt=connect.createStatement();
            result=stmt.executeUpdate(sql);

        } catch(SQLException ex){System.err.println(ex.getMessage());}
        return result;


    }

   public void close(){
       if(connect!=null){
           try {
               connect.close();
               connect=null;
           }
            catch (SQLException ex) {
            System.err.println(ex.getMessage());}
       }

   }


}

2.mianNew.jsp

</td>
</tr>

</table>

<td width="13%"></td>
<td width="87">
<img border="0" src="images/mid-rdxw2.gif" width="101" height="18"><p>
<%
ResultSet rs,rsNest;
String strSql=null;
strSql="select * from news where type=1 order by time desc";
rs=conn.executeQuery(strSql);

while(rs.next()){
%>
<span class="s"> 
<a href="newsContent.jsp?newsId=<%=rs.getInt("id") %>"><%=rs.getString("Title")%></a><br>
<%
     }
   %>
<p>
<img border="0" src="images/mid-hyxw2.gif" width="94" height="19"></p>

<%
strSql="select * from news where type=2 order by time desc";
rs=conn.executeQuery(strSql);

while(rs.next()){
%>
<span class="s"> 
<a href="newsContent.jsp?newsId=<%=rs.getInt("id") %>"><%=rs.getString("Title")%></a><br>
<%
     }
   %>
<p>
</td>
</tr>
</table>
<p align="center">aaronbai 著作權</p>
   <p align="center"> </p>

</body>
</html>

3.newsContent.jsp

<%@ page language="java" contentType="text/html; charset=gb2312"
pageEncoding="UTF-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<%@page import="java.sql.* "%>
<jsp:useBean id="conn" scope="page" class="news.conn"/>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>newsContent</title>
</head>
<body>

</td>
</tr>

</table>

<div class="title" align="center" style="width:603; height:36 ">
<%
String id="";
String keyword="";
String rplContent="";
ResultSet rs,rsNest;
String strSql=null;
id=request.getParameter("newsId");
strSql="select * from news where id="+id;
rs=conn.executeQuery(strSql);

if(rs.next()){
keyword=rs.getString("keyword");

%>
<%=rs.getString("Title") %>
</div>

<%
rplContent = rs.getString("content").replaceAll("/n","<br>");//處理換行府問題
%>

<%
strSql="select * from news where id<>"+id+"and title like '%"+keyword+"%' order by time desc";
rs=conn.executeQuery(strSql);

while(rs.next()){
%>

<a href="newsContent.jsp?newsId=<%=rs.getInt("id") %>"><%=rs.getString("Title") %></a><%=rs.getDate("time") %><br>

<%
     }
   }

   %>
</span>
</td>
</tr>
</table>
<p align="center">aaronbai 著作權</p>
   <p align="center"> </p>
</body>
</html>

本文章原先以中文撰寫並發佈於 aliyun.com，亦設英文版本，僅作資訊用途。本網站不對文章的準確性，完整性或可靠性或其任何翻譯作出任何明示或暗示的陳述或保證。如對該文章有任何疑慮或投訴，請傳送電郵至 info-contact@alibabacloud.com 並提供相關疑慮或投訴的詳細說明。職員會於 5 個工作天內與您聯絡，一經驗證之後，即會刪除該侵權內容。

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

Get Started for Free

Sales Support

1 on 1 presale consultation

Chat Contact Sales
After-Sales Support

24/7 Technical Support 6 Free Tickets per Quarter Faster Response

Open a Ticket
Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.

Learn More