公用資料庫訪問串連javabean開發

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

上載者：User

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

package JavaBean;
import java.io.PrintWriter;
import java.sql.*;

public class DB_Conn {
private String driverName = "com.mysql.jdbc.Driver";
private String userName = "root";
private String userPwd = "123456";
private String dbName = "netvii3d";
private String url = "jdbc:mysql://localhost/"+dbName+
     "?user="+userName+"&password="+userPwd;
private Connection conn = null;
public Statement sm = null;
private PrintWriter out = null;

public void ConnectDB()
{
   try
   {
   Class.forName(driverName).newInstance();
   conn = DriverManager.getConnection(url);
   sm = conn.createStatement();
   }
   catch (Exception ex)
   {
    ex.printStackTrace();
    out.print("資料庫連接失敗！");
   }

}

public void CloseDB()
{
   try{
    if(sm!=null)
    {
     sm.close();

    }
    conn.close();
   }
   catch(SQLException ex)
   {
    ex.printStackTrace();
    out.print("資料庫關閉失敗");
   }
}
}

test.jsp

<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%@ page import="JavaBean.DB_Conn" %>
<jsp:useBean id="db" class="JavaBean.DB_Conn" scope="page" />
<jsp:setProperty name="db" property="*" />

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>

    <title>My JSP 'test.jsp' starting page</title>

<meta http-equiv="pragma" content="no-cache">
<meta http-equiv="cache-control" content="no-cache">
<meta http-equiv="expires" content="0">
<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
<meta http-equiv="description" content="This is my page">

</head>

<body> 
    <%
    db.ConnectDB();
    java.sql.ResultSet rs = db.sm.executeQuery("select * from video_info limit 20");
    while(rs.next())
    {
    out.print(rs.getString("name"));
    out.print("<br>");
    }
     %>
</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

公用資料庫訪問串連javabean開發

聯繫我們

A Free Trial That Lets You Build Big!

Sales Support

After-Sales Support