java 连接mysql数据库方法

import java.sql.*;

public class tmp
{
        public static void main(String args[]) throws Exception
        {
                Class.forName("org.gjt.mm.mysql.Driver").newInstance();

                Connection conn = null;
                String url = "jdbc:mysql://127.0.0.1:3306/test";

                conn = DriverManager.getConnection(url, "root", "123456");

                Statement stat = conn.createStatement();

                stat.executeUpdate("insert into fan(name) values('temporary')");

                stat.close();
                conn.close();
        }
}