public static String FILE_JDBC_PATH;//相关文件信息properties
private static Properties pro = new Properties();
String sql = "";
Connection connection = null;
PreparedStatement preparedStatement = null;
List<ShjzYwJzwpgl> reList = new ArrayList();
try {
String classPath = Path.CLASS_PATH;
FILE_JDBC_PATH=classPath.substring(0, classPath.length()-8)+"config/jdbc.properties";
pro.load(new FileInputStream(FILE_JDBC_PATH));
String driver = pro.getProperty("jdbc.driver");
String url = pro.getProperty("jdbc.url");
String user = pro.getProperty("jdbc.username");
String password = pro.getProperty("jdbc.password");
Class.forName(driver);
//2.获得数据库链接
connection = DriverManager.getConnection(url , user , password ) ;
//3.通过数据库的连接操作数据库,实现增删改查(使用Statement类)
preparedStatement = connection.prepareStatement(sql);
//preparedStatement.setString(1, sms.getId());
//preparedStatement.setDate(2, new java.sql.Date(sms.getCreatetime().getTime()));
//4.处理数据库的返回结果(使用ResultSet类)
ResultSet rs = preparedStatement.executeQuery();
while(rs.next()){
ShjzYwJzwpgl shjzYwJzwpgl = new ShjzYwJzwpgl();
shjzYwJzwpgl.setPicurls(rs.getString("picurls"));
reList.add(shjzYwJzwpgl);
}
} catch (Exception e) {
e.printStackTrace();
// TODO: handle exception
} finally {
connection.close();
preparedStatement.close();
}
return reList;
public class Path {
public static final String CLASS_PATH;
public static final boolean isLinux;
static {
URL resource = Path.class.getResource("Path.class");
String classPath = resource.getPath();
String className = Path.class.getName().replace('.', '/') + ".class";
String classesPath = classPath.substring(0, classPath.indexOf(className));
if (System.getProperty("os.name").toUpperCase().indexOf("WINDOWS") != -1 && classesPath.startsWith("/")) {
classesPath = classesPath.substring(1);isLinux = false;
} else {
isLinux = true;
}
CLASS_PATH = classesPath;
}
}
JAVA 使用JDBC代码--(优化通用代码)
最新推荐文章于 2023-09-04 14:23:17 发布