一、JDBC基础知识
JDBC(Java DataBase Connectivity)是面向应用程序开发人员和数据库驱动程序开发人员的应用程序接口,即执行SQL语句的Java API。
JDBC的三个操作:
(1)建立同一个数据库的连接
(2)向数据库发送SQL语句
(3)处理数据库返回的结果集
二、通过JBDC驱动访问数据库
<%--
Created by IntelliJ IDEA.
User: Nigori
Date: 2020/2/27
Time: 16:20
To change this template use File | Settings | File Templates.
--%>
<%@page import="java.sql.Connection"%>
<%@ page import="java.sql.Statement" %>
<%@ page import="java.sql.ResultSet" %>
<%@ page import="java.sql.DriverManager" %>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
<title>通过MySQL的JDBC驱动访问数据库</title>
</head>
<body bgcolor="pink">
<h3 align="center">使用MySQL的JDBC驱动访问数据库</h3>
<hr>
<table border="1" bgcolor="aqua" align="center">
<tr>
<th width="87" align="center">学号</th>
<th width="87" align="center">姓名</th>
<th width="87" align="center">性别</th>
<th width="87" align="center">年龄</th>
<th width="87" align="center">体重</th>
</tr>
<%
Connection conn=null;
Statement stmt=null;
ResultSet rs=null;
Class.forName("com.mysql.jdbc.Driver");
String url="jdbc:mysql://localhost:3306/Student?useUnicode=true&characterEncoding=gbk";
conn= DriverManager.getConnection(url,"root","root");
stmt=conn.createStatement();
String sql="select * from tb_student";
rs=stmt.executeQuery(sql);
while ((rs.next())){
%>
<tr>
<td><%=rs.getString("SID")%></td>
<td><%=rs.getString("SName")%></td>
<td><%=rs.getString("SGender")%></td>
<td><%=rs.getString("SAge")%></td>
<td><%=rs.getString("SWeight")%></td>
</tr>
<%
}
rs.close();
stmt.close();
conn.close();
%>
</table>
</body>
</html>
使用PreparedStatement
String sql="select * from tb_student";
PreparedStatement prestmt = conn.prepareStatement(sql);
rs=prestmt.executeQuery();