JDBC
Java数据库连接,(Java Database Connectivity,简称JDBC)是Java语言中用来规范客户端程序如何来访问数据库的应用程序接口,提供了诸如查询和更新数据库中数据的方法。JDBC也是Sun Microsystems的商标。我们通常说的JDBC是面向关系型数据库的。
JDBC固定步骤
- 加载驱动
- 链接数据库
- 向数据库发送SQL的对象Statement:CRUD
- 编写SQL
- 执行SQL
- 关闭连接
<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
<modelVersion>4.0.0</modelVersion>
<groupId>com.li.jdbc</groupId>
<artifactId>jdbc-demo</artifactId>
<version>1.0-SNAPSHOT</version>
<dependencies>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.49</version>
</dependency>
</dependencies>
</project>
package com.li.test;
import java.sql.*;
public class test {
public static void main(String[] args) throws ClassNotFoundException, SQLException {
//配置信息
String url = "jdbc:mysql://localhost:3306/jdbc?useUnicode=true&characterEncoding=utf-8";
String username = "root";
String password = "123456";
//1。加载驱动
Class.forName("com.mysql.jdbc.Driver");
//2。链接数据库
Connection connection = DriverManager.getConnection(url, username, password);
//向数据库发送SQL对象的Statement
Statement statement = connection.createStatement();
//4.编写SQL
//增
String sqladd = "insert into users(id,name,password,email,birthday) value (?,?,?,?,?)";
PreparedStatement preparedStatement = connection.prepareStatement(sqladd);
preparedStatement.setInt(1,6);
preparedStatement.setString(2,"lisi");
preparedStatement.setString(3,"23456");
preparedStatement.setString(4,"999@qq.com");
preparedStatement.setString(5,"2020-1-1");
preparedStatement.executeUpdate();//执行
//删
String sqldel = "delete from users where id = 4;";
//改
//查
String sql = "select * from jdbc.users;";
//5.执行sql
ResultSet resultSet = statement.executeQuery(sql);
while (resultSet.next()){
System.out.println("id="+resultSet.getObject("id"));
System.out.println("name="+resultSet.getObject("name"));
System.out.println("password="+resultSet.getObject("password"));
System.out.println("email="+resultSet.getObject("email"));
System.out.println("birthday="+resultSet.getObject("birthday"));
}
//6.关闭连接
resultSet.close();
statement.close();
connection.close();
}
}