JAVA 使用JDBC代码--(优化通用代码)

		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;
        		}
        	 }