怎样用properties连接MYSQL

Question

            Class.forName("com.mysql.jdbc.Driver");
            Properties pr = new Properties();
            pr.setProperty(key, pass);
            pr.setProperty(key, user);
            pr.setProperty(key, "utf-8");
            pr.setProperty(key, db);
            conn = DriverManager.getConnection("jdbc:mysql://localhost/", pr);Properties 中的KEY 怎么写

Answer 1

我都是用的xml来配置的
key应该是对应的属性名吧，就像用户名(connection.username,username)

Answer 2

url=abc等号左边是key右边是value

Answer 3

Parameters:
url a database url of the form jdbc:subprotocol:subname
info a list of arbitrary string tag/value pairs as connection arguments; normally at least a "user" and "password" property should be includedClass.forName("com.mysql.jdbc.Driver");
            Properties pr = new Properties();
            pr.setProperty("user", user);
            pr.setProperty("password", pass);
            conn = DriverManager.getConnection("jdbc:mysql://localhost/", pr);

Answer 4

比如：
InputStream in = lnew BufferedInputStream(new FileInputStream(propertiesFileName));
　　Properties p = new Properties();
　　p.load(in);
    p.getProperty("password");
    P.getProperty("username");
    p.getProperty("charset"");
    p.getProperty("databasename");
那么对应的key分别为passwrd,username,charset,databasename

Answer 5

有误,多个字母l,应为：
InputStream in = new BufferedInputStream(new FileInputStream(propertiesFileName));
　　Properties p = new Properties();
　　p.load(in);
    p.getProperty("password");
    P.getProperty("username");
    p.getProperty("charset"");
    p.getProperty("databasename");