1、读取配置文件
1 //Properties集合 流对象读取键值对
2 public static void getNum() throwsException {3 Properties p=newProperties();4 FileReader f=new FileReader("c:\\root.properties");5 p.load(f);6 f.close();7 }
2、properties文件
url:jdbc:mysql://localhost:3306/qy97
name:"root"
password:"root"
3、数据库连接代码
1
package com.aaa.QuDong;
import java.io.FileReader;
import java.sql.*;
import java.util.Properties;
public class SQLEnc_Test {
public static void main(String[] args) throws Exception {
Properties p=new Properties();
//获取文件里边的值
FileReader f=new FileReader("c:\\root.properties");
p.load(f);
String url=p.getProperty("url");
String user = p.getProperty("name");
String root=p.getProperty("password");
//通过值连接数据库
Connection conn = SQLEns.jdbc_enc(url, user, root);
String sql="select * from users where uname like ‘%郭敬明%‘";
System.out.println(conn);
PreparedStatement pre =conn.prepareStatement(sql);
ResultSet rs = pre.executeQuery();
while (rs.next()){
String name = rs.getString(2);
String dsc = rs.getString(5);
System.out.println("姓名:"+name+" 描述:"+dsc);
}
pre.close();
conn.close();
f.close();
}
//Properties集合 流对象读取键值对
public static void getNum() throws Exception {
Properties p=new Properties();
FileReader f=new FileReader("c:\\root.properties");
p.load(f);
f.close();
}
}
4、JDBC封装mysql数据库连接
1 packagecom.aaa.demo;2
3 importjava.io.FileNotFoundException;4 importjava.io.FileReader;5 importjava.sql.Connection;6 importjava.sql.DriverManager;7 importjava.util.Properties;8
9 //封装JDBC
10 public classSQLEns {11 private staticConnection conn;12 public staticConnection jdbc_enc(String url, String user, String password){13 try{14 //注册驱动
15 Class.forName("com.mysql.jdbc.Driver");16 //获得数据库连接对象
17 conn =DriverManager.getConnection(url, user, password);18 } catch(Exception e) {19 }20 returnconn;21 }22 }
原文:https://www.cnblogs.com/yanpingping/p/10639067.html