標籤：alt each ESS last arc mpi Servle ges 資料
JSP 串連資料庫本章節假設您已經對JDBC有一定的瞭解。在開始學習JSP資料庫訪問前，請確保JDBC環境已經正確配置。
首先，讓我們按照下面的步驟來建立一個簡單的表並插入幾條簡單的記錄：
建立表在資料庫中建立一個Employees表，步驟如下：
步驟1：開啟CMD，然後進入資料庫安裝目錄：
C:\>C:\>cd Program Files\MySQL\binC:\Program Files\MySQL\bin>步驟2：
C:\Program Files\MySQL\bin>mysql -u root -pEnter password: ********mysql>步驟3：
用create database語句建立一個新的資料庫TEST：
mysql> create database TEST步驟4：
在TEST資料庫中建立Employee表：
mysql> use TEST;mysql> create table Employees ( id int not null, age int not null, first varchar (255), last varchar (255) );Query OK, 0 rows affected (0.08 sec)mysql>插入資料記錄
建立好Employee表後，往表中插入幾條記錄：
mysql> INSERT INTO Employees VALUES (100, 18, ‘Zara‘, ‘Ali‘);Query OK, 1 row affected (0.05 sec) mysql> INSERT INTO Employees VALUES (101, 25, ‘Mahnaz‘, ‘Fatma‘);Query OK, 1 row affected (0.00 sec) mysql> INSERT INTO Employees VALUES (102, 30, ‘Zaid‘, ‘Khan‘);Query OK, 1 row affected (0.00 sec) mysql> INSERT INTO Employees VALUES (103, 28, ‘Sumit‘, ‘Mittal‘);Query OK, 1 row affected (0.00 sec) mysql>SELECT操作
接下來的這個例子告訴我們如何使用JSTL SQL標籤來運行SQL SELECT語句：
<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%><%@ page import="java.io.*,java.util.*,java.sql.*"%><%@ page import="javax.servlet.http.*,javax.servlet.*" %><%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%><%@ taglib uri="http://java.sun.com/jsp/jstl/sql" prefix="sql"%> <html><head><title>SELECT 操作</title></head><body> <sql:setDataSource var="snapshot" driver="com.mysql.jdbc.Driver" url="jdbc:mysql://localhost/TEST" user="root" password="pass123"/> <sql:query dataSource="${snapshot}" var="result">SELECT * from Employees;</sql:query> <table border="1" width="100%"><tr> <th>Emp ID</th> <th>First Name</th> <th>Last Name</th> <th>Age</th></tr><c:forEach var="row" items="${result.rows}"><tr> <td><c:out value="${row.id}"/></td> <td><c:out value="${row.first}"/></td> <td><c:out value="${row.last}"/></td> <td><c:out value="${row.age}"/></td></tr></c:forEach></table> </body></html>
訪問這個JSP例子，運行結果如下：
INSERT操作這個例子告訴我們如何使用JSTL SQL標籤來運行SQL INSERT語句：
<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%><%@ page import="java.io.*,java.util.*,java.sql.*"%><%@ page import="javax.servlet.http.*,javax.servlet.*" %><%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%><%@ taglib uri="http://java.sun.com/jsp/jstl/sql" prefix="sql"%> <html><head><title>INSERT 操作</title></head><body> <sql:setDataSource var="snapshot" driver="com.mysql.jdbc.Driver" url="jdbc:mysql://localhost/TEST" user="root" password="pass123"/><sql:update dataSource="${snapshot}" var="result">INSERT INTO Employees VALUES (104, 2, ‘Nuha‘, ‘Ali‘);</sql:update> <sql:query dataSource="${snapshot}" var="result">SELECT * from Employees;</sql:query> <table border="1" width="100%"><tr> <th>Emp ID</th> <th>First Name</th> <th>Last Name</th> <th>Age</th></tr><c:forEach var="row" items="${result.rows}"><tr> <td><c:out value="${row.id}"/></td> <td><c:out value="${row.first}"/></td> <td><c:out value="${row.last}"/></td> <td><c:out value="${row.age}"/></td></tr></c:forEach></table> </body></html>
訪問這個JSP例子，運行結果如下：
DELETE操作這個例子告訴我們如何使用JSTL SQL標籤來運行SQL DELETE語句：
<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%><%@ page import="java.io.*,java.util.*,java.sql.*"%><%@ page import="javax.servlet.http.*,javax.servlet.*" %><%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%><%@ taglib uri="http://java.sun.com/jsp/jstl/sql" prefix="sql"%> <html><head><title>DELETE 操作</title></head><body> <sql:setDataSource var="snapshot" driver="com.mysql.jdbc.Driver" url="jdbc:mysql://localhost/TEST" user="root" password="pass123"/> <c:set var="empId" value="103"/> <sql:update dataSource="${snapshot}" var="count"> DELETE FROM Employees WHERE Id = ? <sql:param value="${empId}" /></sql:update> <sql:query dataSource="${snapshot}" var="result"> SELECT * from Employees;</sql:query> <table border="1" width="100%"><tr> <th>Emp ID</th> <th>First Name</th> <th>Last Name</th> <th>Age</th></tr><c:forEach var="row" items="${result.rows}"><tr> <td><c:out value="${row.id}"/></td> <td><c:out value="${row.first}"/></td> <td><c:out value="${row.last}"/></td> <td><c:out value="${row.age}"/></td></tr></c:forEach></table> </body></html>
訪問這個JSP例子，運行結果如下：
UPDATE操作這個例子告訴我們如何使用JSTL SQL標籤來運行SQL UPDATE語句：
<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%><%@ page import="java.io.*,java.util.*,java.sql.*"%><%@ page import="javax.servlet.http.*,javax.servlet.*" %><%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%><%@ taglib uri="http://java.sun.com/jsp/jstl/sql" prefix="sql"%> <html><head><title>UPDATE 操作</title></head><body> <sql:setDataSource var="snapshot" driver="com.mysql.jdbc.Driver" url="jdbc:mysql://localhost/TEST" user="root" password="pass123"/> <c:set var="empId" value="102"/> <sql:update dataSource="${snapshot}" var="count"> UPDATE Employees SET last = ‘Ali‘ WHERE Id = ? <sql:param value="${empId}" /></sql:update> <sql:query dataSource="${snapshot}" var="result"> SELECT * from Employees;</sql:query> <table border="1" width="100%"><tr> <th>Emp ID</th> <th>First Name</th> <th>Last Name</th> <th>Age</th></tr><c:forEach var="row" items="${result.rows}"><tr> <td><c:out value="${row.id}"/></td> <td><c:out value="${row.first}"/></td> <td><c:out value="${row.last}"/></td> <td><c:out value="${row.age}"/></td></tr></c:forEach></table> </body></html>
訪問這個JSP例子，運行結果如下：
JSP 串連資料庫JDBC有一定的瞭解
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
