天天看点

连接阿里云服务器

用这个jar包:mysql-connector-java-8.0.16.jar不行,不支持8.0的java。得用5.0得版本,我用得是这个版本mysql-connector-java-5.1.7-bin.jar
class mysql
{
	static Connection con;
	static Statement statement;
	static ResultSet rs;
    //驱动程序名
	static
	{
    String driver = "com.mysql.jdbc.Driver";
    //URL指向要访问的数据库名studb
    String url = "jdbc:mysql://rm-bp1b82x8w917q20lb0o.mysql.rds.aliyuncs.com";
    //MySQL配置时的用户名
    String user = "abandon";
    //MySQL配置时的密码
    String password = "Qsy123456";
    try {
    System.out.print("1111");
    Class.forName(driver);
    //1.getConnection()方法,连接MySQL数据库!!
    System.out.print("1111");
    con = DriverManager.getConnection(url,user,password);
    statement=con.createStatement();
    }
    catch(Exception e)
    {
    	System.out.print("打开数据库失败");
    }
	}
}

           

继续阅读