public NewsInfoDto getNewsInfoDto(int id) {

		PreparedStatement stmt = null;
		ResultSet rs = null;
		NewsInfoDto newsInfoDto = null;
		try {

			stmt = conn
					.prepareStatement("select author,title,content,creatTime from NewsInfo where id = ? ");

			stmt.setInt(1, id);

			rs = stmt.executeQuery();

			String title = "";
			Date date=null;
			String author = "";
			String infoString="";

			if(rs.next()) {

				newsInfoDto=new NewsInfoDto();
				
				author = rs.getString(1);
				title = rs.getString(2);
				infoString=rs.getString(3);
				date = new Date(rs.getTimestamp(4).getTime());

				newsInfoDto.setAuthor(author);
				newsInfoDto.setCreateTime(date);
				newsInfoDto.setTitle(title);
				newsInfoDto.setContent(infoString);

			}

			if (stmt != null)
				stmt.close();
			if (rs != null)
				rs.close();

		} catch (Exception e) {
			// TODO: handle exception
			
			logger.debug(e.getMessage());
		}
		
		return newsInfoDto;
	}