java简单连接MySQL

查询

import com.JDBC.until.DBUtil;

import java.sql.*;

public class Find {
    public static void main(String[] args) throws SQLException {
        try {
            Connection connection = DBUtil.getConnection();
            //写SQL语句
            String sql = "select * from tb_user";
            //获得statement对象
            PreparedStatement statement = connection.prepareStatement(sql);
            //获得结果集
            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));
            }
            //关闭结果集
            DBUtil.closeAll(resultSet, statement, connection);
        }catch (Exception e){
            System.out.println(e);
        }
    }
}

添加

import com.JDBC.until.DBUtil;

import java.sql.*;

public class invalue {
    public static void main(String[] args) throws ClassNotFoundException, SQLException {
        Connection connection = DBUtil.getConnection();
        //写SQL语句
        String sql = "insert into tb_user(username,password) value ('123','123')";
        //获得statement对象
        PreparedStatement statement = connection.prepareStatement(sql);
        //更新
        statement.executeUpdate();
        //获得结果集
        DBUtil.closeAll(null,statement,connection);
    }
}

删除

import com.JDBC.until.DBUtil;

import java.sql.*;

public class delete {
    public static void main(String[] args) throws ClassNotFoundException, SQLException {
        Connection connection = DBUtil.getConnection();
        String sql = "delete from tb_user where id = 1";
        PreparedStatement statement = connection.prepareStatement(sql);
        statement.executeUpdate();
        DBUtil.closeAll(null,statement,connection);
    }
}

修改

import com.JDBC.until.DBUtil;

import java.sql.*;

public class update {
    public static void main(String[] args) throws ClassNotFoundException, SQLException {
        Connection connection = DBUtil.getConnection();
        String sql = "update tb_user set password = '456' where username = '123'";
        PreparedStatement statement = connection.prepareStatement(sql);
        statement.executeUpdate();
        DBUtil.closeAll(null,statement,connection);
    }
}

重复使用的方法

import java.sql.*;

public class DBUtil {
    public static Connection getConnection() throws ClassNotFoundException, SQLException {
        //加载驱动
        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();
        }
    }
}