用JavaBean實現資料庫的串連和關閉，在jsp頁面輸出資料庫中student表中學生的資訊

最後更新：2016-07-01 來源：互聯網

上載者：User

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

標籤：

package com.hanqi.test;import java.sql.*;public class XveSheng {     Connection conn;     Statement st;     ResultSet rs;         public Connection getConn() {        return conn;    }    public void setConn(Connection conn) {        this.conn = conn;    }    public Statement getSt() {        return st;    }    public void setSt(Statement st) {        this.st = st;    }    public ResultSet getRs() {        return rs;    }    public void setRs(ResultSet rs) {        this.rs = rs;    }    public void lianjie()    {                       try        {                    Class.forName("oracle.jdbc.driver.OracleDriver");            String strUrl = "jdbc:oracle:thin:@localhost:1521:orcl"    ;            conn  = DriverManager.getConnection(strUrl, "test", "5211314");                    System.out.println("串連資料庫成功！");        }        catch (Exception e)        {                        e.printStackTrace();                    }             }    public void guanbi()    {        try         {            conn.close();            st.close();            rs.close();        }         catch (SQLException e)        {            e.printStackTrace();        }                    }    }

<%@page import="com.hanqi.test.XveSheng"%><%@page import="java.sql.*"%><%@ page language="java" contentType="text/html; charset=UTF-8"    pageEncoding="UTF-8"%><!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=UTF-8"><title>學生資訊</title></head><body><div align="center"><font size="20px">學生資訊表</font></div><table border="1" cellspacing="0" width="80%" align="center" style="text-align: center"><tr><td height="40">學號</td><td >姓名</td><td >性別</td><td >生日</td><td>班級</td></tr><%     XveSheng xs = new XveSheng();     xs.lianjie();     xs.setSt(xs.getConn().createStatement());     xs.setRs(xs.getSt().executeQuery("select * from student"));     while(xs.getRs().next())        {                      String sno = xs.getRs().getString(1);                     String sname = xs.getRs().getString(2);           String ssex = xs.getRs().getString(3);           Date sbirthday= xs.getRs().getDate(4);           String sclass = xs.getRs().getString(5);                 %> <tr><td height="40"><%=sno %></td><td ><%=sname %></td><td ><%=ssex %></td><td ><%=sbirthday.toString() %></td><td><%=sclass %></td></tr> <%        }     xs.guanbi();%></table></body></html>

用JavaBean實現資料庫的串連和關閉，在jsp頁面輸出資料庫中student表中學生的資訊

本文章原先以中文撰寫並發佈於 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