jdbc
1.加载驱动
2.创建连接
3.写sql语句
4.获得statement对象
5.执行sql得到结果集
6.处理结果集
7.关闭资源
封装DBUtil工具类
package com.util;
import java.sql.*;
public class DBUtil {
public static Connection getConnection(){
//1.加载驱动
try {
Class.forName("com.mysql.jdbc.Driver");
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
//2.创建连接
Connection connection = null;
try {
connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/wzbc", "root", "123456");
} catch (SQLException e) {
e.printStackTrace();
}
return connection;
}
public static void closeAll(ResultSet resultSet, Statement statement,Connection connection) {
if (resultSet!=null){
try {
resultSet.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
if (statement!=null){
try {
statement.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
if (connection!=null){
try {
connection.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
}
增
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;
public class insert {
public static void main(String[] args) {
Connection connection = DBUtil.getConnection();
String sql = "insert ignore into tb_user(id,username,password) values('4','朱泽伟','8848')";
PreparedStatement statement = null;
try {
statement = connection.prepareStatement(sql);
statement.executeUpdate();
System.out.println("插入成功");
} catch (SQLException e) {
e.printStackTrace();
}
DBUtil.closeAll(null,statement,connection);
}
}
删
package com;
import com.util.DBUtil;
import java.sql.*;
public class delete {
public static void main(String[] args){
Connection connection = DBUtil.getConnection();
//3.写sql语句
String sql = "delete from tb_user where id=3";
PreparedStatement statement = null;
try {
//4.获得statement对象
statement = connection.prepareStatement(sql);
//5.执行sql得到结果集
statement.executeUpdate();
System.out.println("删除成功");
} catch (SQLException e) {
e.printStackTrace();
}
//6.关闭资源
DBUtil.closeAll(null,statement,connection);
}
}
改
package com;
import com.util.DBUtil;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;
public class alter {
public static void main(String[] args){
Connection connection = DBUtil.getConnection();
String sql = "update tb_user set username = 'www' where id = 2";
PreparedStatement statement = null;
try {
statement = connection.prepareStatement(sql);
statement.executeUpdate();
System.out.println("修改成功");
} catch (SQLException e) {
e.printStackTrace();
}
DBUtil.closeAll(null,statement,connection);
}
}
查
package com;
import com.util.DBUtil;
import java.sql.*;
public class Find {
public static void main(String[] args) {
Connection connection = DBUtil.getConnection();
//3.写sql语句
String sql="select * from tb_user";
PreparedStatement statement = null;
ResultSet resultSet = null;
try {
//4.获得statement对象
statement = connection.prepareStatement(sql);
//5.执行sql得到结果集
resultSet = statement.executeQuery();
} catch (SQLException e) {
e.printStackTrace();
}
//6.处理结果集
while (true){
try {
if (!resultSet.next()) break;
} catch (SQLException e) {
e.printStackTrace();
}
try {
System.out.println(resultSet.getInt(1));
System.out.println(resultSet.getString(2));
System.out.println(resultSet.getString(3));
} catch (SQLException e) {
e.printStackTrace();
}
}
//7.关闭资源
DBUtil.closeAll(resultSet,statement,connection);
}
}