【java】JDBC连接MySQL

package com.tn.mysqlconnection;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

public class MySQLConnection {
    private static final String DBDRIVER = "com.mysql.jdbc.Driver";
    private static final String DBURL = "jdbc:mysql://localhost:3306/"
            + "user=xiongjiawei@password=Tuniu520@useUnicode=true&characterEncoding=UTF8";
    private static final String URL = "jdbc:mysql://localhost:3306/db_tuniu";
    private static final String DBUSER = "xiongjiawei";
    private static final String PASSWORD = "Tuniu520";
    private Connection conn = null;

    public MySQLConnection() {
        try {
            Class.forName(DBDRIVER);
            this.conn = DriverManager.getConnection(URL, DBUSER, PASSWORD);
        } catch (Exception e) {
            e.printStackTrace();
        }
    }

    public Connection getConnection() {
        return this.conn;
    }

    public void close() {
        if (this.conn != null) {
            try {
                this.conn.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
    }

    public static void main(String[] args) {
        MySQLConnection mySQLConnection = new MySQLConnection();
        Connection conn = mySQLConnection.getConnection();
        String sql = "INSERT INTO student(name) VALUES(?)";
        try {
            PreparedStatement statement = conn.prepareStatement(sql);
            // ResultSet resultSet=statement.executeQuery();
            statement.setString(1, "赵六子");
            System.out.println(statement.executeUpdate());
            conn.close();
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
}