標籤：串連資料庫 源檔案 jsp mysql
如下寫入jsp源碼。
在瀏覽器地址欄輸入：http://localhost:8080/項目名/jsp源檔案名稱.jsp
斷行符號
<%@ page language="java" import="java.util.*,java.sql.*" pageEncoding="UTF-8"%><%String path = request.getContextPath();String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";%><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"><html> <head> <base href="<%=basePath%>"> <title>載入JDBC驅動串連資料庫</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"> <!-- <link rel="stylesheet" type="text/css" href="styles.css"> --> </head> <body> <% try { Class.forName("com.mysql.jdbc.Driver").newInstance(); //載入驅動 String url = "jdbc:mysql://localhost:3306/student"; //news為資料庫名 String user = "root"; //資料庫名 String password = "123"; //密碼 Connection conn = DriverManager.getConnection(url, user, password); out.println("串連資料庫成功！"); } catch (Exception e) { out.println("無法串連資料庫，失敗！"); e.printStackTrace(); } %> </body></html>
jsp連結MySQL
Start building with 50+ products and up to 12 months usage for Elastic Compute Service
1 on 1 presale consultation
24/7 Technical Support 6 Free Tickets per Quarter Faster Response
Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.
A comprehensive suite of global cloud computing services to power your business
Payment Methods We Support
