etp.zip_Scanner _java调用扫描仪_扫描仪_扫描仪 dll_调用扫描仪

package com.shxhg.etp.action; import java.text.SimpleDateFormat; import java.util.HashMap; import java.util.List; import java.util.Map; import javax.servlet.http.HttpSession; import org.apache.struts2.ServletActionContext; import org.scavino.twain.JTwain; import com.mdl.scan.AcquireHelper; import com.opensymphony.xwork2.ActionSupport; import com.shxhg.etp.service.TicketService; /** * 访客登记 * * @author Administrator * */ public class RegisterAction extends ActionSupport { /** * */ private static final long serialVersionUID = -1790426326758343435L; private String id; private String dept; private String item; private String visitor; private String org; private String begintime; private String endtime; private String fwyg; private String num; private String url; private String bz; private int pageNo; private String phone; private String cardnum; private String status; private TicketService ticketService; public void setTicketService(TicketService ticketService) { this.ticketService = ticketService; } public int getPageNo() { return pageNo; } public void setPageNo(int pageNo) { this.pageNo = pageNo; } public String getId() { return id; } public void setId(String id) { this.id = id; } public String getDept() { return dept; } public void setDept(String dept) { this.dept = dept; } public String getItem() { return item; } public void setItem(String item) { this.item = item; } public String getVisitor() { return visitor; } public void setVisitor(String visitor) { this.visitor = visitor; } public String getOrg() { return org; } public void setOrg(String org) { this.org = org; } public String getBegintime() { return begintime; } public void setBegintime(String begintime) { this.begintime = begintime; } public String getEndtime() { return endtime; } public void setEndtime(String endtime) { this.endtime = endtime; } public String getFwyg() { return fwyg; } public void setFwyg(String fwyg) { this.fwyg = fwyg; } public String getNum() { return num; } public void setNum(String num) { this.num = num; } public String getUrl() { return url; } public void setUrl(String url) { this.url = url; } public String getBz() { return bz; } public void setBz(String bz) { this.bz = bz; } public String getPhone() { return phone; } public void setPhone(String phone) { this.phone = phone; } public String getCardnum() { return cardnum; } public void setCardnum(String cardnum) { this.cardnum = cardnum; } public String getStatus() { return status; } public void setStatus(String status) { this.status = status; } public String registerConfig() throws Exception { HttpSession session = ServletActionContext.getRequest().getSession(); String config = (String)session.getAttribute("scanConfig"); try { if (null == config && JTwain.getInstance().isTwainAvailble()) { String[] twainSources = JTwain.getInstance().getAvailableSources(); if(null != twainSources && twainSources.length>0) { session.setAttribute("scanConfig", twainSources[0]); } } } catch (Exception e) { e.printStackTrace(); } ServletActionContext.getRequest().setAttribute("itemList", ticketService.getTicketList("select id,name from t_item")); ServletActionContext.getRequest().setAttribute("deptList", ticketService.getTicketList("select id,name from t_dept")); return SUCCESS; } public String updateRegiser() throws Exception { ServletActionContext.getRequest().setAttribute("itemList", ticketService.getTicketList("select id,name from t_item")); ServletActionContext.getRequest().setAttribute("deptList", ticketService.getTicketList("select id,name from t_dept")); String config = ServletActionContext.getRequest().getParameter("config"); if("config".equals(config)) { ServletActionContext.getRequest().setAttribute("config", "config"); List<Map<String, Object>> list = ticketService .getTicketList("select id,dept,item,visitor,org,fwyg,num,url,bz,phone,cardnum,status,begintime from t_register where id=" + id); if (list.size() > 0) ServletActionContext.getRequest().setAttribute("register", list.get(0)); else ServletActionContext.getRequest().setAttribute("register", new HashMap<String, Object>()); return SUCCESS; } int person = 0; try { person = Integer.parseInt(num); }catch(NumberFormatException e) { person = 1; } StringBuilder sql = new StringBuilder("update t_register set dept='"); sql.append(getResult(dept)).append("',item='").append(getResult(item)) .append("',visitor='").append(getResult(visitor)).append("',org='").append(getResult(org)) .append("',fwyg='").append(getResult(fwyg)).append("',num=").append(person).append(",url='") .append(getResult(url)).append("',bz='").append(getResult(bz)).append("',phone='").append(getResult(phone)) .append("',cardnum='").append(getResult(cardnum)).append("',status='").append(getResult(status)).append("' where id=").append(id); ticketService.deleteTicket(sql.toString()); ServletActionContext.getRequest().setAttribute("message", "保存访客信息成功"); ServletActionContext.getRequest().setAttribute("config", "config"); List<Map<String, Object>> list = ticketService .getTicketList("select id,dept,item,visitor,org,fwyg,num,url,bz,phone,cardnum,status,begintime from t_register where id=" + id); if (list.size() > 0) ServletActionContext.getRequest().setAttribute("register", list.get(0)); else ServletActionContext.getRequest().setAttribute("register", new HashMap<String, Object>()); return SUCCESS; } /** * 访客登记 * @return * @throws Exception */ public String register() throws Exception { int person = 0; try { person = Integer.parseInt(num); }catch(NumberFormatException e) { person = 1; } if(!isNull(begintime)) { SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss"); begintime = sdf.format(new java.util.Date()); } StringBuilder sql = new StringBuilder("insert into t_register (dept,item,visitor,org,begintime,fwyg,num,url,bz,phone,cardnum,status)"); sql.append("values('").append(getResult(dept)).append("','").append(getResult(item)).append("','") .append(getResult(visitor)).append("','").append(getResult(org)).append("','") .append(getResult(begintime)).append("','").append(getResult(fwyg)).append("',") .append(person).append(",'").append(getResult(url)).append("','").append(getResult(bz)) .append("','").append(getResult(phone)) .append("','").append(getResult(cardnum)).append("','").append(getResult(status)).append("')"); ticketService.deleteTicket(sql.toString()); ServletActionContext.getRequest().setAttribute("message", "保存访客信息成功"); return SUCCESS; } /** * 扫描访客证件 * @return * @throws Exception */ public String scan() throws Exception { java.util.Date date = new java.util.Date(); SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss"); long time = date.getTime(); if(JTwain.getInstance().isTwainAvailble()) { String path = "C:\\scan\\"+time+".jpg"; AcquireHelper acquire = new AcquireHelper(); String source = String.valueOf(ServletActionContext.getRequest().getSession().getAttribute("scanConfig")); acquire.startAcquireOne(source, path); } ServletActionContext.getRequest().setAttribute("itemList", ticketService.getTicketList("select id,name from t_item")); ServletActionContext.getRequest().setAttribute("deptList", ticketS