8.7w+
社区成员
handleEdit: function () {
$content.on('click', '.page-unit button[id="viewimage"]', function () {
var $unitform = $('#unitForm');
var rowdata = oTable.row($(this).closest('tr')).data();
$unitform.find("img[name='imgView']").attr("src",rowdata.largefilename+"\\"+rowdata.imgfilename);
/* $unitform.find("img[name='imgView']").attr("src","/image/"+rowdata.imgfilename);*/
$unitform.modal('show');
});
},
//初始化表格,
oTable = $('#imageTable').DataTable($.po('dataTable', {
autoWidth: false, //禁用自动调整列宽
processing: true, //隐藏加载提示,自行处理
serverSide: true, //启用服务器端分页
searching: false, //禁用原生搜索
sort: false,
pagingType: "simple_numbers", //分页样式:
//列表表头字段
columns: [
{
"render": function () {
var checkbox = '<span class="checkbox-custom checkbox-primary">' +
'<input type="checkbox" class="contacts-checkbox selectable-item" >' +
'<label></label></span>';
return checkbox;
}
},
{
"data": null,
"render": function (data, type, row, meta) {
var startIndex = meta.settings._iDisplayStart;
return startIndex + meta.row + 1;
}
},
{"data": "xm"},
{"data": "sfzh"},
{"data": "jdah"},
{"data": "fsmachineip"},
{"data": "largefilename"},
{"data":"imgfilename"},
{"data": "subtype"},
{"data": "batchid"},
{"data": "subtypeid"},
{
"render": function (data, type, row, meta) {
var edit = '<button type="button" class="btn btn-sm btn-icon btn-pure btn-default"' + ' id="viewimage" data-toggle="modal" title="查看图片" ><i class="fa-circle-o" aria-hidden="true"></i></button>';
edit += '<button type="button" class="btn btn-sm btn-icon btn-pure btn-default"' + ' id="printpicture" title="打印图片" ><i class="fa-edit" aria-hidden="true"></i></button>';
return edit;
}
}
],
<div class="panel">
<header class="panel-heading">
<h3 class="panel-title">影像查询</h3>
</header>
<div class="panel-body">
<table class="table table-bordered table-hover text-nowrap dataTable table-striped width-full margin-vertical-10"
id="imageTable" data-scroll-x="true" data-responsive="false"
data-column-defs='[{ "orderable": false, "targets": 2}]'>
<thead>
<tr>
<th width="30">
<span class="checkbox-custom checkbox-primary purchase-select-all">
<input id="checkAll" type="checkbox" class="purchase-checkbox selectable-all">
<label></label>
</span>
</th>
<th>ID</th>
<th>姓名</th>
<th>身份证号</th>
<th>旧档案号</th>
<th>图片地址</th>
<th>图片全路径</th>
<th>图片名称</th>
<th>类型</th>
<th>批次号</th>
<th>描述</th>
<th>操作</th>
</tr>
</thead>
</table>
</div>
</div>
</div>
</div>
<div class="modal fade" id="unitForm" aria-hidden="true" role="dialog">
<div class="modal-dialog modal-center">
<form class="modal-content" id="menuInfo">
<div class="modal-header">
</div>
<div class="modal-body">
<div class="center-block">
<img src="" class="img-responsive" alt="" name="imgView">
</div>
</div>
</form>
</div>
</div>
// TbbusidataServiceImpl
//影像查询
@Override
public Map<String, Object> queryImage(Tbbusidata tbb) {
Map<String, Object> jsonMap = new HashMap<String, Object>();
try {
List<Tbbusidata> tbbList = mapper.queryImage(tbb);
查出tbbList后,遍历一下,把路径批量改掉就好了[/quote]
handleEdit: function () {
$content.on('click', '.page-unit button[id="viewimage"]', function () {
var $unitform = $('#unitForm');
//获取到列表的数据
var rowdata = oTable.row($(this).closest('tr')).data();
//给img(name=imgView)的src添加获取的到列表数据
//rowdata.largefilename(这是图片地址)和rowdata.imgfilename(这是图片名名称)
$unitform.find("img[name='imgView']").attr("src",rowdata.largefilename+"\\"+rowdata.imgfilename);
//$unitform.find("img[name='imgView']").attr("src","/public/images/00001.jpg");
//$unitform.find("img[name='imgView']").attr("src","/image/"+rowdata.imgfilename);
$unitform.find("img[name='imgView']").attr("alt",rowdata.subtypeid);
$unitform.modal('show');
});
},
因为是从表获取到的,所以能知道那个图片对应的哪一行,用<Host>的话img src=""这里要写具体的路径的
java后端哪里要写for if 进行遍历和判断,我现在不知道怎么写。。。
// TbbusidataServiceImpl
//影像查询
@Override
public Map<String, Object> queryImage(Tbbusidata tbb) {
Map<String, Object> jsonMap = new HashMap<String, Object>();
try {
List<Tbbusidata> tbbList = mapper.queryImage(tbb);
查出tbbList后,遍历一下,把路径批量改掉就好了 <!-- 查询总数 -->
<select id="imageTotal" resultType="Integer" parameterType="tbbusidata">
SELECT count(1)
FROM tb_busi_data td
INNER JOIN tb_xhscan_batch tb ON td.JDAH=tb.HeHao
INNER JOIN tb_xhscan_input2_data ti ON tb.BatchId=ti.BatchId
WHERE 1=1
<if test="jdah != null">
and JDAH=#{jdah}
</if>
<if test="sfzh != null">
and SFZH=#{sfzh}
</if>
</select>
<!-- 查询全部 -->
<select id="queryImage" resultType="tbbusidata" parameterType="tbbusidata">
SELECT bd.`JDAH`,bd.`XM`,bd.`SFZH`,xb.`FSMachineIp`,xb.`LargeFileName`,td.`SubType`,xb.`BatchId`,td.`SubTypeid`,td.`ImgFileName`
FROM tb_busi_data bd
INNER JOIN tb_xhscan_batch xb ON bd.`JDAH`=xb.`HeHao`
INNER JOIN tb_xhscan_input2_data td ON xb.`BatchId`=td.`BatchId`
WHERE 1=1
<if test="jdah != null">
and JDAH=#{jdah}
</if>
<if test="sfzh != null">
and SFZH=#{sfzh}
</if>
<if test="start != null and limit != null">
limit #{start},#{limit}
</if>
</select>
public interface TbbusidataMapper<T> {
List<Tbbusidata>query(Tbbusidata tbb);
Integer getTotal(Tbbusidata tbb);
//查询全部
List<T>queryImage(Tbbusidata tbb);
//总数
Integer imageTotal(Tbbusidata tbb);
List<Tbgz>querygz(Tbgz tbgz);
}
public interface TbbusidataService {
Map<String, Object> query(Tbbusidata tbb);
//查询全部图片资料
Map<String,Object>queryImage(Tbbusidata tbb);
}
@Service
@Transactional
public class TbbusidataServiceImpl implements TbbusidataService {
Logger logger = Logger.getLogger(TbbusidataController.class);
@Autowired
private TbbusidataMapper mapper;
@Override
public Map<String, Object> query(Tbbusidata tbb) {
Map<String, Object> jsonMap = new HashMap<String, Object>();
try {
List<Tbbusidata> tbbList = mapper.query(tbb);
Integer total = mapper.getTotal(tbb);
jsonMap.put("success", true);
jsonMap.put("total", total);
jsonMap.put("data", tbbList);
} catch (Exception e) {
jsonMap.put("success", false);
logger.error("报错");
}
return jsonMap;
}
//影像查询
@Override
public Map<String, Object> queryImage(Tbbusidata tbb) {
Map<String, Object> jsonMap = new HashMap<String, Object>();
try {
List<Tbbusidata> tbbList = mapper.queryImage(tbb);
Integer total = mapper.imageTotal(tbb);
jsonMap.put("success", true);
jsonMap.put("total", total);
jsonMap.put("data", tbbList);
} catch (Exception e) {
jsonMap.put("success", false);
logger.error("报错");
}
return jsonMap;
}
}
@Controller
@RequestMapping("/viewFiles/archives")
public class TbbusidataController extends BaseController {
Logger logger = Logger.getLogger(TbbusidataController.class);
@Autowired
private TbbusidataService tbbusidataService;
@RequestMapping(value = "/query", method = RequestMethod.POST)
@ResponseBody
public Map<String, Object> query(Tbbusidata tbb) {
return tbbusidataService.query(tbb);
}
//影像查询
@RequestMapping(value = "/queryImage",method = RequestMethod.POST)
@ResponseBody
public Map<String, Object> queryImage(Tbbusidata tbb) {
return tbbusidataService.queryImage(tbb);
}
}
/**
* 页面的跳转
*/
@Controller
@RequestMapping("/viewFiles")
public class ViewPjaxController extends BaseController {
Logger logger = Logger.getLogger(this.getClass());
@RequestMapping(value = "/archives", method = RequestMethod.GET)
public ModelAndView archives(HttpServletRequest request) {
ModelAndView mv = new ModelAndView();
String pjax = request.getHeader("X-PJAX");
if (StringUtils.isNotBlank(pjax) && "true".equals(pjax)) {
mv.setViewName("viewFiles/archives");
} else {
mv.addObject("include", "viewFiles/archives.jsp");
mv.setViewName("index");
}
return mv;
}
/**
* 影像查询
*/
@RequestMapping(value = "/imageview", method = RequestMethod.GET)
public ModelAndView imageview(HttpServletRequest request) {
ModelAndView mv = new ModelAndView();
String pjax = request.getHeader("X-PJAX");
if (StringUtils.isNotBlank(pjax) && "true".equals(pjax)) {
mv.setViewName("viewFiles/imageview");
} else {
mv.addObject("include", "viewFiles/imageview.jsp");
mv.setViewName("index");
}
return mv;
}
}
通过后端从数据库获取到数据后就直接把绝对路径改成相对路径可以吗,这个要改的话应该怎么写?<div class="modal fade" id="unitForm" aria-hidden="true" role="dialog">
<div class="modal-dialog modal-center">
<form class="modal-content" id="menuInfo">
<div class="modal-header">
<button type="button" class="close" data-dismiss="modal" aria-hidden="true">
×
</button>
</div>
<div class="modal-body" id="qrcode">
<img src="" alt="" class="img-responsive center-block" name="imgView">
</div>
<div class="modal-footer">
<button type="button" id="btn_print" class="btn btn-primary" data-dismiss="modal">
<span class="glyphicon glyphicon-floppy-disk" aria-hidden="true"></span>打印
</button>
</div>
</form>
</div>
</div>
// TbbusidataServiceImpl
//影像查询
@Override
public Map<String, Object> queryImage(Tbbusidata tbb) {
Map<String, Object> jsonMap = new HashMap<String, Object>();
try {
List<Tbbusidata> tbbList = mapper.queryImage(tbb);