数据库同步工具
sqlserver,Mysql数据同步软件

使用easyui从数据库读入数据完成前端分页并更新datagrid数据表格

购买事宜请联系QQ:1793040

首先,工具

公共类PageUtil {

? private int currentPageIndex;//

? private int pageSize;//每页多少数据

? private int startIndex;//开始是前几个数据

?公共PageUtil(){

this.currentPageIndex = 1;

this.pageSize = 10;

this.startIndex =(this.currentPageIndex-1)* this.pageSize;

?}

?公共PageUtil(int currentPageIndex){

this.currentPageIndex = currentPageIndex;

this.pageSize = 10;

this.startIndex =(this.currentPageIndex-1)* this.pageSize;

?}

? public PageUtil(int currentPageIndex,int pageSize){

this.currentPageIndex = currentPageIndex;

this.pageSize = pageSize;

this.startIndex =(this.currentPageIndex-1)* this.pageSize;

?}

? public int getCurrentPageIndex(){

返回currentPageIndex;

?}

? public void setCurrentPageIndex(int currentPageIndex){

this.currentPageIndex = currentPageIndex;

this.startIndex =(this.currentPageIndex-1)* this.pageSize;

?}

? public int getPageSize(){

返回pageSize;

?}

? public void setPageSize(int pageSize){

this.pageSize = pageSize;

this.startIndex =(this.currentPageIndex-1)* this.pageSize;

?}

? public int getStartIndex(){

返回startIndex;

?}

? @Override

? public String toString(){

返回” PageUtil [currentPageIndex =” + currentPageIndex +”,pageSize =” + pageSize +”,startIndex =”

+ startIndex +”]”;

?}?

}

2.INoteBiz层

公共接口INoteBiz {

?公开清单lt;注意事项queryAll(PageUtil util);

? public int getTotal();

?公开清单lt;注意事项queryByWords(注意,PageUtil util);

? public int getTotalByWords(注意)

}

3.NoteBizImpl层

公共类NoteBizImpl实现INoteBiz {

? NoteDao dao = new NoteDao();

? @Override

?公开清单lt;注意事项queryAll(PageUtil util){

字符串sql =”选择便笺。*,A.employeeName作为employeeName,b.employeeName作为operatorName,a.cardNumber,attenancetype.typeName”

+”从笔记左外部加入雇员作为note.employeeId = a.employeeId”

+”在note.operatorId = b.employeeId上将左外部加入的雇员作为b”

+” note.noteTypeId =出席者类型.typeId上的左外部联接出席者类型”;

StringBuilder sbl =新的StringBuilder(sql);

sbl.append(” limit” + util.getStartIndex()+”,” + util.getPageSize());

System.out.println(sbl.toString());

return(List \ lt; Note \ gt;)dao.query(sbl.toString(),Note.class,new Object [] {});

?}

? @Override

? public int getTotal(){

字符串sql =”从注释中选择计数(*)”;

return(int)dao.getCount(sql,new Object [] {});

?}

? @Override

?公开清单lt;注意事项queryByWords(注意,PageUtil util){

字符串sql =”选择便笺。*,A.employeeName作为employeeName,b.employeeName作为operatorName,a.cardNumber,attenancetype.typeName”

+”从笔记左外部加入雇员作为note.employeeId = a.employeeId”

+”在note.operatorId = b.employeeId上将左外部加入的雇员作为b”

+” note.noteTypeId =出席者类型.typeId上的左外部联接出席者类型”

+”其中0 = 0″;

StringBuilder sbl =新的StringBuilder(sql);

//基于输入值的动态组条件

ArrayList \ lt;对象 params = new ArrayList \ lt;对象 ();

if(note.getIsVerify()!= null \ \!””。等于(note.getIsVerify())){

sbl.append(” and note.isVerify = “);

params.add(note.getIsVerify());

}

if(note.getNoteTypeId()!= 0){

sbl.append(” and note.noteTypeId = “);

params.add(note.getNoteTypeId());

}

if(note.getEmployeeName()!= null \ \!””。等于(note.getEmployeeName())){

sbl.append(” and a.employeeName = “);

params.add(note.getEmployeeName());

}

if(note.getOperatorName()!= null \ \!””。等于(note.getOperatorName())){

sbl.append(” and b.employeeName = “);

params.add(note.getOperatorName());

}

if(note.getStartDate()!= null \ \!””。等于(note.getStartDate())){

//sbl.append(” and note.startDate = “);

sbl.append(”和(?(??= note.startDate和?\ lt; = note.endDate)”);

params.add(note.getStartDate());

params.add(note.getStartDate());

}

sbl.append(” limit” + util.getStartIndex()+”,” + util.getPageSize());

列出\ lt;注意事项list = dao.query(sbl.toString(),Note.class,params.toArray());

System.out.println(列表);

返回清单;

?}

? @Override

? public int getTotalByWords(注释){

字符串sql =”选择计数(*)”

+”从笔记左外部加入雇员作为note.employeeId = a.employeeId”

+”在note.operatorId = b.employeeId上将左外部加入的雇员作为b”

+” note.noteTypeId =出席者类型.typeId上的左外部联接出席者类型”

+”其中0 = 0″;

StringBuilder sbl =新的StringBuilder(sql);

//基于输入值的动态组条件

ArrayList \ lt;对象 params = new ArrayList \ lt;对象 ();

if(note.getIsVerify()!= null \ \!””。等于(note.getIsVerify())){

sbl.append(” and note.isVerify = “);

params.add(note.getIsVerify());

}

if(note.getNoteTypeId()!= 0){

sbl.append(” and note.noteTypeId = “);

params.add(note.getNoteTypeId());

}

if(note.getEmployeeName()!= null \ \!””。等于(note.getEmployeeName())){

sbl.append(” and a.employeeName = “);

params.add(note.getEmployeeName());

}

if(note.getOperatorName()!= null \ \!””。等于(note.getOperatorName())){

sbl.append(” and b.employeeName = “);

params.add(note.getOperatorName());

}

if(note.getStartDate()!= null \ \!””。等于(note.getStartDate())){

//sbl.append(” and note.startDate = “);

sbl.append(”和(?(??= note.startDate和?\ lt; = note.endDate)”);

params.add(note.getStartDate());

params.add(note.getStartDate());

}

return(int)dao.getCount(sbl.toString(),params.toArray());

?}

}

4.NoteController层

INoteBiz biz =新的NoteBizImpl();

?受保护的void doPost(HttpServletRequest请求,HttpServletResponse响应)抛出ServletException,IOException {

字符串opt = request.getAttribute(” opt”)。 ToString();

System.out.println(opt);

开关(选择){

案例” QueryAll”:

? QueryAll(请求,响应);

打破;

案例” QueryByWords”:

尝试{

QueryByWords(请求,响应);

} catch(ParseException e){

//TODO自动生成的捕获块

e.printStackTrace();

}

打破;

默认值:

打破;

}

?}

?私有void QueryByWords(HttpServletRequest请求,HttpServletResponse响应)引发ParseException,IOException {

字符串isVerify;

int typeid;

字符串employeeName;

字符串operatorName;

日期AttendanceDate = null;

if(request.getParameter(” isVerify”)== null || request.getParameter(” isVerify”)。等于(””)){

isVerify =””;

}其他{

Verse = request.getParameter(” isVerify”);

}

if(request.getParameter(” noteTypeId”)== null || request.getParameter(” noteTypeId”)。等于(””)){

typeid = 0;

}其他{

? typeid = Integer.parseInt(request.getParameter(” noteTypeId”));

}

if(request.getParameter(” employeeName”)== null || request.getParameter(” employeeName”)。等于(””)){

employeeName =””;

}其他{

employeeName = request.getParameter(” employeeName”)。 toString()。修剪();

}

if(request.getParameter(” operatorName”)== null || request.getParameter(” operatorName”)。等于(””)){

operatorName =””;

}其他{

operatorName = request.getParameter(” operatorName”)。 toString()。修剪();

}

if(request.getParameter(” leaveDate”)== null || request.getParameter(” leaveDate”)。等于(””)){

AttenanceDate = null;

}其他{

字符串时间= request.getParameter(” leaveDate”);

SimpleDateFormat sdf = new SimpleDateFormat(” yyyy-MM-dd”);//yyyy-mm-dd,时间将是错误的,因为小写的mm表示:秒

日期utilDate = sdf.parse(时间);

AttenanceDate =新的java.sql.Date(utilDate.getTime());//

}

//System.out.println(isVerify +” http:///” + typeid +” http:///” + employeeName +” http:///” + operatorName +” http:///” + AttendantDate) ;

Note note =新的Note();

note.setIsVerify(isVerify);

note.setNoteTypeId(typeid);

note.setEmployeeName(employeeName);

note.setOperatorName(operatorName);

note.setStartDate(attendanceDate);

int页面= Integer.parseInt(request.getParameter(”页面”));//! ! !

int行= Integer.parseInt(request.getParameter(”行”));//!!!

PageUtil util =新的PageUtil(页面,行);

//System.out.println(页面+”…” +行);

列出\ lt;注意事项list = biz.queryByWords(注意,util);

int count = biz.getTotalByWords(注释);

HashMap \ lt;字符串,对象 map = new HashMap \ lt;字符串,对象 ();

map.put(” total”,count);

map.put(” rows”,list);

PrintWriter out = response.getWriter();

字符串str = JSON.toJSONStringWithDateFormat(地图,” yyyy-MM-dd”,新的SerializerFeature [0]);

System.out.println(str);

out.print(str);

out.flush();

out.close();

?}

?私有void QueryAll(HttpServletRequest请求,HttpServletResponse响应)引发IOException {

int页面= Integer.parseInt(request.getParameter(”页面”));

int行= Integer.parseInt(request.getParameter(”行”));

//System.out.println(页面+”—-” +行);

PageUtil util =新的PageUtil(页面,行);

列出\ lt;注意事项list = biz.queryAll(util);

int count = biz.getTotal();

//字符串str = JSON.toJSONString(list);

?//字符串str = JSON.toJSONStringWithDateFormat(列表,” yyyy-MM-dd HH:mm:ss”,新的SerializerFeature [0]);//

//字符串str = JSON.toJSONStringWithDateFormat(列表,” yyyy-MM-dd”,新的SerializerFeature [0]);//

//System.out.println(str);

HashMap \ lt;字符串,对象 map = new HashMap \ lt;字符串,对象 ();

map.put(” total”,count);

map.put(” rows”,list);

PrintWriter out = response.getWriter();

字符串str = JSON.toJSONStringWithDateFormat(地图,” yyyy-MM-dd”,新的SerializerFeature [0]);

out.print(str);

out.flush();

out.close();

?}

V.前端

\ lt ;! DOCTYPE html \ gt;

\ lt; html \ gt;

\ lt;头

\ lt; meta charset =” UTF-8″ \ gt;

\ lt;标题gt;休假管理lt;/标题>

\ lt;链接类型=”文本/CSS” rel =”样式表” href =” https://blog.csdn.net/level_Tiller/article/details/js/jquery-easyui/themes/default/easyui.css”/\ gt ;

\ lt;链接类型=”文本/CSS” rel =”样式表” href =” https://blog.csdn.net/level_Tiller/article/details/js/jquery-easyui/themes/icon.css”/\ gt;

\ lt;脚本src =” https://blog.csdn.net/level_Tiller/article/details/js/jquery-easyui/jquery.min.js” \ gt; \ lt;/脚本

\ lt;脚本src =” https://blog.csdn.net/level_Tiller/article/details/js/jquery-easyui/jquery.easyui.min.js” \ gt; \ lt;/脚本

\ lt;脚本src =” https://blog.csdn.net/level_Tiller/article/details/js/jquery-easyui/locale/easyui-lang-zh_CN.js” \ gt; \ lt;/脚本

? \ lt;脚本类型=”文字/javascript” \>

$(function(){

//初始化表列表

initNoteList();

//初始弹出页面

initDialog();

//初始化员工信息

initEmployeeList();

$(”#btnAdd”)。点击(功能(){

$(”#addDiv”)。对话框({

已关闭:false

});

});

//打开图标注册事件

$(”#addForm #employeeId”)。文字框({

图标:[{

? iconCls:” icon-search”,

处理程序:函数(e){

$(”#employeeListDiv”)。对话框({

已关闭:false

));

}

}]

});

$(”#addForm #operatorId”)。文字框({

图标:[{

? iconCls:” icon-search”,

处理程序:函数(e){

? $(”#employeeListDiv2″)。对话框({

已关闭:false

));

}

}]

});

//是员工列表的选择按钮,注册点击事件

$(”#btnSelect”)。点击(功能(){

var row = $(”#tblEmployeeList”)。 datagrid(” getSelected”);

? var employeeId = row.employeeID;

var employeeName = row.employeeName;

var cardNumber = row.cardNumber;

//列表框已关闭

$(”#employeeListDiv”)。对话框({

已关闭:true

});

$(”#addForm #employeeId”)。文本框(

? ” setValue”,employeeName +”(” + employeeId +”,” + cardNumber +”)”

);

});

$(”#btnSelect2″)。点击(功能(){

var row = $(”#tblEmployeeList2″)。 datagrid(” getSelected”);

? var employeeId = row.employeeID;

var employeeName = row.employeeName;

var cardNumber = row.cardNumber;

//列表框已关闭

$(”#employeeListDiv2″)。对话框({

已关闭:true

});

$(”#addForm #operatorId”)。文本框(

? ” setValue”,employeeName +”(” + employeeId +”,” + cardNumber +”)”

);

});

$(”#noteTypeId”)。组合框({

LoadFilter:函数(数据){

var obj = {};

obj.typeId =””;

obj.typeName =”-请选择-”

data.splice(0,0,obj)//在不删除原始元素的情况下将obj插入数组的位置0

返回数据;

}

});

$(”#addDiv #noteTypeId”)。组合框({

LoadFilter:函数(数据){

var obj = {};

obj.typeId =””;

obj.typeName =”-请选择-”

data.splice(0,0,obj)//在不删除原始元素的情况下将obj插入数组的位置0

返回数据;

}

});

$(”#btnQuery”)。点击(

函数()

<

? var isVerify = $(”#queryForm #isVerify”)。 val();

? var employeeName = $(”#queryForm #employeeName”)。 val();

? var operatorName = $(”#queryForm #operatorName”)。 val();

? var noteTypeId = $(”#queryForm #noteTypeId”)。组合(” getValue”);

? var LeaveDate = $(”#queryForm #leaveDate”)。 datebox(” getValue”);

? $? “(#tblNote”).datagrid(” options”).url =” http://本地主机:8081/KQXT/NoteController/QueryByWords”;

$(”#tblNote”)。 datagrid(” load”,{

? isVerify:isVerify,

employeeName:employeeName,

operatorName:operatorName,

NoteTypeId:noteTypeId,

离开日期:离开日期

));

}

);

});

函数initNoteList(){

$(”#tblNote”)。 datagrid({

url:” http://localhost:8081/KQXT/NoteController/QueryAll”,

singleSelect:true,

分页:正确,

pageSize:5,

? pageList:[5,10,15,20],

pageNumber:1,

工具栏:”#barNote”,

行号:true,

queryParams:{

? IsVerify:””,

noteTypeId:0,

employeeName:””,

operatorName:””,

LeaveDate:””

},

onLoadSuccess:函数(数据){

如果(data.total == 0)?

$(this).datagrid(” appendRow”,{

FillInTime:” \ lt; div样式=” text-align:center;颜色:红色” \ gt;没有相关记录!\ lt;/div \ gt;”})

datagrid(” mergeCells”,{索引:0,字段:” fillInTime”,colspan:8})?

},

列:[[

? {field:” fillInTime”,标题:” Fill in Time”,宽度:130,align:” center”},

? {field:” cardNumber”,标题:” card number”,宽度:100,align:” center”},

? {field:” employeeName”,标题:” Applicant”,宽度:100,align:” center”},

? {field:” typeName”,标题:” Leave type”,宽度:100,align:” center”},

? {field:” startDate”,标题:” start time”,宽度:130,align:” center”,格式:函数(值,行,索引){

返回row.startDate +” ” + row.startTime;

}},

? {field:” endDate”,标题:” End Time”,宽度:130,align:” center”,格式:功能(值,行,索引){

返回row.endDate +” ” + row.endTime;

}},

? {field:” operatorName”,标题:” Agent”,宽度:100,align:” center”},

? {field:” opt”,标题:” operation”,宽度:150,align:” center”,

格式程序:函数(值,行,索引){

? var a =” \ lt; a href =” https://blog.csdn.net/level_Tiller/article/details/98071527#” id =” editButton”οnclick=”编辑(” +行。noteId +”)”>编辑\\ a \\ \\ nbsp”;

? var b =” \ lt; a href =” https://blog.csdn.net/level_Tiller/article/details/98071527#” id =” delButton”οnclick=” del(” + row。noteId +”)” >删除//一个>

? var c =” \ lt; a href =” https://blog.csdn.net/level_Tiller/article/details/98071527#” id =” viewButton”οnclick=” view(” + row。noteId +”)” \ gt;查看\ gt; \ nbsp”;

返回c + a + b;

}

]]

});

}

函数initDialog(){

$(”#employeeListDiv”)。对话框({

标题:”员工列表”,

宽度:400,

高度:380,

已关闭:true,

模态:true

});

$(”#employeeListDiv2″)。对话框({

标题:”员工列表”,

宽度:400,

高度:380,

已关闭:true,

模态:true

});

$(”#addDiv”)。对话框({

标题:”离开请求管理”,

宽度:550,

高度:400,

已关闭:true,

模态:true

});

}

函数initEmployeeList(){

$(”#tblEmployeeList”)。 datagrid({

url:” http://localhost:8081/KQXT/EmployeeController/QueryAllZaizhi”,

singleSelect:true,

列:[[

? {field:” employeeID”,标题:” Employee ID”,宽度:100},

? {field:” employeeName”,标题:” employee name”,宽度:100},

? {field:” cardNumber”,标题:” Employee Card Number”,宽度:100}

]]

});

$(”#tblEmployeeList2″)。 datagrid({

url:” http://localhost:8081/KQXT/EmployeeController/QueryAllZaizhi”,

singleSelect:true,

列:[[

? {field:” employeeID”,标题:” Employee ID”,宽度:100},

? {field:” employeeName”,标题:” employee name”,宽度:100},

? {field:” cardNumber”,标题:” Employee Card Number”,宽度:100}

]]

});

}
? \ lt;/脚本

\ lt;/头

\ lt;正文

\ lt; div class =” easyui-layout” data-options =” fit:true” id =” useBox” \ gt;

? \ lt;表单ID =” queryForm”方法=”发布” \>

\ lt; div style =” text-align:center; margin-top:10px;” \ gt;

\ lt;标签为=” isVerify” \\ u>已批准:\ lt;/标签

\ lt;选择类=” easyui-combobox” id =” isVerify”名称=” isVerify” data-options =” editable:false” \ gt;

\ lt;选项值=”” \\-请选择-\\/选项

\ lt;选项值=” 1″通过\ lt;/选项

\ lt;选项值=” 0″ \失败lt;/选项

\ lt;/选择

\ lt;标签为=” noteTypeId” \ gt;休假类型:\ lt;/标签

\ lt;输入id =” noteTypeId”类=” easyui-combobox”名称=” noteTypeId”数据选项=” valueField:” typeId”,textField:” typeName”,url:” http://本地主机:8081/KQXT/AttendancetypeController/QueryNoteType”,可编辑:false” \

\ lt;/div>

\ lt; div style =” text-align:center; margin-top:10px;” \ gt;

\ lt;标签为=” employeeName” \\员工姓名:\ lt;/标签

\ lt;输入id =” employeeName”名称=” employeeName”类=” easyui-文本框” style =”宽度:100px” \ gt;

\ lt;标签为=” operatorName” \ gt;代理商名称:/标签

\ lt;输入id =” operatorName”名称=” operatorName”类=” easyui-textbox”样式=”宽度:100px” \ gt;

\ lt;标签为=” leaveDate” \\ u>离开日期:/标签

\ lt;输入id =” leaveDate”名称=” leaveDate”类=” easyui-datebox”样式=” width:100px” data-options =” editable:false” \ gt;

\ lt;/div>

\ lt; div style =” text-align:center; margin-top:10px;” \ gt;

\ lt; id =” btnQuery” class =” easyui-linkbutton” iconCls =” icon-search” \\ ugt26;查询\ lt;/a>

\ lt;/div>

? \ lt;/表格

? \ lt; br \ gt;

? \ lt; div class =” tableCon” \ gt;

\ lt;表格ID =” tblNote” \ gt; \ lt;/表>

\ lt; div id =” barNote” \ gt;

\ lt; id =” btnAdd” class =” easyui-linkbutton” data-options =” iconCls:” icon-add”,普通:true” \ gt;添加\ lt;/a>

\ lt;/div>

? \ lt;/div>

\ lt;/div>

\ lt; div id =” addDiv” \ gt;

? \ lt;表单ID =” addForm” \\ u>

\ lt; div style =” text-align:center; margin-top:10px;” \ gt;

\ lt;标签为=” employeeId” \\ ugt26申请人:/标签

\ lt;输入id =” employeeId” name =” employeeId” class =” easyui-textbox easyui-validatebox” data-options =” required:true” style =” width:300px” \ gt;

\ lt;/div>

\ lt; div style =” text-align:center; margin-top:10px;” \ gt;

\ lt;标签为=” operatorId” \ gt;代理商:/标签

\ lt;输入id =” operatorId” name =” operatorId” class =” easyui-textbox easyui-validatebox” data-options =” required:true” style =” width:300px” \ gt;

\ lt;!-\ lt;输入id =” operatorId”名称=” operatorId”类=” easyui-combobox” data-options =”必填:true,iconCls:” icon-search””样式=”宽度:300px”/\ gt;-\ gt;

\ lt;/div>

\ lt; div style =” text-align:center; margin-top:10px;” \ gt;

\ lt;标签为=” noteTypeId” \ gt;休假类型:\ lt;/标签

\ lt;输入id =” noteTypeId” class =” easyui-combobox” name =” noteTypeId” data-options =” valueField:” typeId”,textField:” typeName”,url:” http://本地主机:8081/KQXT/AttendancetypeController/QueryNoteType”,可编辑:false” \

\ lt;/div>

\ lt; div style =” text-align:center; margin-top:10px;” \ gt;

\ lt;标签为=” fillInTime” \表格填写时间:/标签

\ lt;输入类=” easyui-datetimebox” name =” fillTime” id =” fillTime” data-options =”必填:true,可编辑:false” style =”宽度:150px” \ gt;

\ lt;/div;?

\ lt; div style =” text-align:center; margin-top:10px;” \ gt;

\ lt;标签为”原因” \>离开原因:/标签

\ lt; “输入类=” easyui-文本框” id =”原因” name =”原因” data-options =”必需:true,多行:true” style =”宽度:300px;高度:50px;” \ gt;

\ lt;/div>

\ lt; div style =” text-align:center; margin-top:10px;” \ gt;

\ lt;标签为=” startDate” \\ u>离开开始时间:/标签

\ lt;输入id =” startDate”名称=” startDate”类型=” text”类=” easyui-datebox” data-options =”必填:true,可编辑:false”/\ gt;

\ lt;选择id =” endTime”类=” easyui-combobox”名称=” endTime”样式=” width:200px;” data-options =” editable:false” \\ ugt26

\ lt;选项值=” AM” AM \ lt;/选项

\ lt;选项值=” PM”> PM \ lt;/选项

\ lt;/选择

\ lt;/div>

\ lt; div style =” text-align:center; margin-top:10px;” \ gt;

\ lt;标签为=” endDate” \\ u>离开结束时间:/标签

\ lt;输入id =” endDate”名称=” endDate”类型=” text”类=” easyui-datebox” data-options =”必填:true,可编辑:false”/\ gt;

\ lt;选择id =” endTime”名称=” endTime”类=” easyui-combobox”样式=” width:200px;” data-options =” editable:false” \\ ugt26

\ lt;选项值=” AM” AM \ lt;/选项

\ lt;选项值=” PM”> PM \ lt;/选项

\ lt;/选择

\ lt;/div>

\ lt; div style =” text-align:center; margin-top:10px;” \ gt;

\ lt;标签为=” directorSign” \\ u>主管的意见:/标签

\ lt; “输入类=” easyui-textbox” id =” directorSign”名称=” directorSign”数据选项=” multiline:true”样式=”宽度:300px;高度:50px;” \ gt;

\ lt;/div>

\ lt; div style =” text-align:center; margin-top:10px” \ gt;

\ lt;标签为=” administrationSign” \\ ugt26行政经理的意见:\ lt;/标签

\ lt; “输入类=” easyui-textbox” id =” administrationSign”名称=” administrationSign” data-options =” multiline:true” style =”宽度:300px;高度:50px;” \ gt;

\ lt;/div>

\ lt; div style =” text-align:center; margin-top:10px” \ gt;

\ lt;标签为=” presidentSign” \\ u>主席的意见:/标签

\ lt; “输入类=” easyui-文本框” id =” presidentSign”名称=” presidentSign”数据选项=”多行:true” style =”宽度:300px;高度:50px;”/\\ gt;

\ lt;/div>

\ lt; div style =” text-align:center; margin-top:10px;” \ gt;

\ lt; id =” btnSave” class =” easyui-linkbutton” data-options =” iconCls:” icon-save”,普通:true” \ gt;保存\ lt;/a>

\ lt;/div>

? \ lt;/表格

\ lt;/div>

\ lt; div id =” employeeListDiv” \ gt;

? \ lt;表格ID =” queryEmpForm” \\ ugt26

\ lt; div style =” text-align:center; margin-top:10px;” \ gt;

\ lt;标签为=” employeeName” \\员工姓名:\ lt;/标签

\ lt;输入类=” easyui-textbox” id =” employeeName”名称=” employeeName”样式=” width:200px” \ gt;

\ lt; id =” btnSave” class =” easyui-linkbutton” data-options =” iconCls:” icon-search”,普通:true” \ gt;找到\ lt;/a>

\ lt;/div>

? \ lt;/表格

? \ lt; div class =” tableCon” style =” text-align:center;” \ gt;

\ lt;表格ID =” tblEmployeeList” \ gt; \ lt;/表>

\ lt; id =” btnSelect” class =” easyui-linkbutton” data-options =” iconCls:” icon-ok”,普通:true” \ gt; OK \ lt;/a>

? \ lt;/div>

\ lt;/div>

\ lt; div id =” employeeListDiv2″ \ gt;

? \ lt;表单ID =” queryEmpForm2″ \ gt;

\ lt; div style =” text-align:center; margin-top:10px;” \ gt;

\ lt;标签为=” employeeName” \\员工姓名:\ lt;/标签

\ lt;输入类=” easyui-textbox” id =” employeeName2″ name =” employeeName2″ style =” width:200px” \\ ugt26>

\ lt; id =” btnSave2″ class =” easyui-linkbutton” data-options =” iconCls:” icon-search”,普通:true” \ gt;找到\ lt;/a>

\ lt;/div>

? \ lt;/表格

? \ lt; div class =” tableCon” style =” text-align:center;” \ gt;

\ lt;表格ID =” tblEmployeeList2″ \ gt; \ lt;/表>

\ lt; id =” btnSelect2″ class =” easyui-linkbutton” data-options =” iconCls:” icon-ok”,普通:true” \ gt; OK \ lt;/a>

? \ lt;/div>

\ lt;/div>

\ lt;/身体>

\ lt;/html \ gt;

未经允许不得转载:数据库同步软件|Mysql数据同步软件|sqlserver数据库同步工具|异构同步 » 使用easyui从数据库读入数据完成前端分页并更新datagrid数据表格

分享到:更多 ()

syncnavigator 8.6.2 企业版

联系我们联系我们