package cn.dao;
import java.io.IOException;
import java.util.Properties;
public class DBsql {
private static final String FILENAME="cn\\dao\\SQL.properties";
public DBsql(){
}
public static String getSQL(String param) throws IOException{
Properties proper = new Properties();
proper.load(DBsql.class.getClassLoader().getResourceAsStream(FILENAME));
return proper.getProperty(param);
}
}
通过读取属性文件中的SQL语句,查询,修改数据。
SQL.properties:
sql=select name from emp;