IDEA java连接mysql数据库，实现对数据库的增删改查

先上代码：

package Database_Demo;

import java.sql.*;

public class DataBase {

    public static void main(String[] args) {
        Connection con;

        String driver="com.mysql.jdbc.Driver";
        //这里我的数据库是test

        String url="jdbc:mysql://localhost:3306/test";
        //我的mysql数据库的账户：root  密码：mysql
        String user="root";
        String password="mysql";

        try {
            Class.forName(driver);
            con = DriverManager.getConnection(url, user, password);
            if (!con.isClosed()) {
                System.out.println("数据库连接成功");
            }
            Statement statement = con.createStatement();
            //tb1表中插入
            tring sql = "insert into tb1 VALUES ('hhh',20,1000)";
            //tb1表中删除
            String sq2 = "DELETE FROM tb1 WHERE ang=13";
            //查找
            String sql3 = "select * from tb1;";
            ResultSet resultSet = statement.executeQuery(sql3);
            String name;
            while (resultSet.next()) {
                name = resultSet.getString("username");
                System.out.println("姓名：" + name);
            }
            //删除tb2表
            String sq4 = "DROP TABLE IF EXISTS tb2;";
            //创建tb3表
            String sq5 = "CREATE TABLE tb3(username VARCHAR(20),passward VARCHAR(10))";
            //statement.execute(sq5);

            //修改tb1表中数据
            String sq6 = "UPDATE tb1 SET ang=1111 WHERE username='hhh'";
            statement.execute(sq6);


            statement.execute(sql);
            statement.execute(sq2);
            statement.execute(sq4);

            con.close();
        } catch (ClassNotFoundException e) {
            System.out.println("数据库驱动没有安装");

        } catch (SQLException e) {
            System.out.println("数据库连接失败");
        }
    }

}