Class.forName("com.mysql.jdbc.Driver");
Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/realty","root","123");
如果有多个人员开发,远程连接同一数据库的话需要MySQL先授权:
打开MySQL控制台,输入:GRANT ALL ON *.* TO root@'%' IDENTIFIED BY 'mysql' WITH GRANT OPTION;
别忘了";",其中root是你要登录的用户名,mysql是密码,执行完成后,把上面的连接字符串小改一下:
Connection conn = DriverManager.getConnection("jdbc:mysql://192.168.0.1:3306/realty","root","123");
192.168.0.1是远程数据库的IP地址
OK!