参考：

 try {
            String sql = "insert into user(name,age) values('zhanSan',30);";
            Class.forName("com.mysql.jdbc.Driver");
            // 连接对象
            Connection con = DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/myDB?characterEncoding=utf-8", "username", "password");
            // 执行命令对象
            Statement stmt = con.createStatement();
            // 执行
            stmt.execute(sql);

            // 关闭
            stmt.close();
            con.close();
        } catch (Exception e) {
            e.printStackTrace();
        }