0.工具类的实现
import java.sql.*;
public class JdbcUtil {
public static Connection getConnection() throws SQLException, ClassNotFoundException {
Class.forName("com.mysql.jdbc.Driver");
Connection connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/wzbc", "root" , "123456");
return connection;
}
public static void closeAll(ResultSet resultSet, Statement statement, Connection connection) throws SQLException {
if(resultSet!= null) {
resultSet.close();
}
if(statement!= null) {
statement.close();
}
if(connection!= null) {
connection.close();
}
}
}
主要用于减少代码的复用度
1.增加操作
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;
public class Insert {
public static void main(String[] args) throws SQLException, ClassNotFoundException {
Connection conn = JdbcUtil.getConnection();
System.out.println("创建连接成功");
String sql = "insert into tb_user(id,username,password) values('3','WangWu','123456')";
PreparedStatement statement = conn.prepareStatement(sql);
statement.executeUpdate();
JdbcUtil.closeAll(null,statement,conn);
}
}
2.修改操作
public class Alter{
public static void main(String[] args) throws SQLException, ClassNotFoundException {
Connection conn = JdbcUtil.getConnection();
System.out.println("创建连接成功");
String sql = "update tb_user set password = '123' where id = 3";
PreparedStatement statement = conn.prepareStatement(sql);
statement.executeUpdate();
JdbcUtil.closeAll(null,statement,conn);
}
}
3.删除操作
public class Delete {
public static void main(String[] args) throws SQLException, ClassNotFoundException {
Connection conn = JdbcUtil.getConnection();
System.out.println("创建连接成功");
String sql = "delete from tb_user where id = 3";
PreparedStatement statement = conn.prepareStatement(sql);
statement.executeUpdate();
JdbcUtil.closeAll(null,statement,conn);
}
}
4.查询数据
public class Query{
public static void main(String[] args) throws SQLException, ClassNotFoundException {
Connection conn = JdbcUtil.getConnection();
System.out.println("创建连接成功");
String sql = "select * from tb_user";
PreparedStatement statement = conn.prepareStatement(sql);
statement.executeQuery();
ResultSet resultSet = statement.executeQuery();
while(resultSet.next()){
System.out.println(resultSet.getInt(1));
System.out.println(resultSet.getString(2));
System.out.println(resultSet.getString(3));
}
JdbcUtil.closeAll(resultSet,statement,conn);
}
}
5.连接数据库的七个步骤
1、JDBC所需的四个参数(user,password,url,driverClass)
2、加载JDBC驱动程序
•for.class中调用静态代码块自行加载
3、创建数据库的连接
•要连接数据库,需要向java.sql.DriverManager请求并获得Connection对象,该对象就代表一个数据库的连接
4、创建一个preparedStatement
•Statement接口提供了三种执行SQL语句的方法:executeQuery 、executeUpdate和execute*
5、执行SQL语句
6、遍历结果集
7、处理异常,关闭JDBC对象资源