数据库连接

最新推荐文章于 2024-10-03 20:57:12 发布

健三_

最新推荐文章于 2024-10-03 20:57:12 发布

阅读量60

点赞数

文章标签：数据库 java database

本文链接：https://blog.csdn.net/m0_47513806/article/details/125129979

版权

@Test
public void test() throws Exception{
    //读取信息
    InputStream is = ConnectionTest.class.getClassLoader().getResourceAsStream("jdbc.properties");

    //properties应放在所在程序Module的src下
    Properties pros = new Properties();
    pros.load(is);

    String user = pros.getProperty("user");
    String password = pros.getProperty("password");
    String url = pros.getProperty("url");
    String driverClass = pros.getProperty("driverClass");

    //加载Driver
    Class.forName(driverClass);

    //获取连接
    Connection conn = DriverManager.getConnection(url,user,password);

    System.out.println(conn);
}

Properties文件:

user=root
password=root
url=jdbc:mysql://localhost:3306/fruitdb?useUnicode=true&characterEncoding=utf-8&useSSL=false
driverClass=com.mysql.jdbc.Driver