拼接内容，生成xml

/**
	 * @Description: 生成xml
	 * @return
	 */
	public static boolean createXml(){
		sql = "select  from T";
		int count = 0;
		try {
			conn = ConnectionPool.getConn("emos4");
			pstmt = conn.prepareStatement(sql);
			pstmt.setLong(1, startTime);
			pstmt.setLong(2, endTime);
			rs = pstmt.executeQuery();
			StringBuffer buffer = new StringBuffer();
			System.out.println("开始拼接xml---------------------------------------------");
			buffer.append("<?xml version=\"1.0\" encoding=\"GBK\" standalone=\"yes\"?>\n");
			buffer.append("<openlist>\n");
			while(rs.next()){
				buffer.append("\t<BaseStatus>"+rs.getString("c700000010")+"</BaseStatus>\n");
				buffer.append("\t<BaseSN>"+rs.getString("c1")+"</BaseSN>\n");
				count++;
				System.out.println("count:"+count);
			}
			buffer.append("</openlist>");
			System.out.println("结束拼接xml---------------------------------------------");
			System.out.println("开始生成xml---------------------------------------------");
			CommonUtil.readFileByLine(buffer.toString(), System.getProperty(CommonUtil.USER_DIR) + File.separator + 
					CommonUtil.ATTACHMENT_PATH_NAME + File.separator + CommonUtil.OPEN + "_" + 
					TimeUtils.getCurrentDate("yyyyMMddHHmmss") + "_1_1" +".xml");
			System.out.println("结束生成xml---------------------------------------------");
			return true;
		} catch (SQLException e) {
			e.printStackTrace();
			return false;
		} finally {
			DbUtil.closeConnection(conn, pstmt, rs);
		}
	}

根据业务需要while(rs.next()) 这里可以自行拼接xml或其他文件。

在下面会有用到生成文件，关闭数据库连接工具类的链接。