目录
1. dao层,写新增信息的方法;
这里面主要是写新增和修改信息的方法;
//增加记录的方法
public int gradeAdd(Connection con, Grade grade) throws Exception{
String sql="insert into t_grade values(null,?,?)";
PreparedStatement pstmt=con.prepareStatement(sql);
pstmt.setString(1,grade.getGradeName());
pstmt.setString(2,grade.getGradeDesc());
return pstmt.executeUpdate();
}
//修改记录的方法
public int gradeModify(Connection con,Grade grade) throws Exception{
String sql="update t_grade set gradeName=?,gradeDesc=? where id=?";
PreparedStatement pstmt=con.prepareStatement(sql);
pstmt.setString(1,grade.getGradeName());
pstmt.setString(2,grade.getGradeDesc());
pstmt.setInt(3,grade.getId());
return pstmt.executeUpdate();
}
2. 前台页面层,写页面;
这里主要是,点击增加或者修改班级信息的时候,都会弹出一个对话框来进行操作;
<div id="dlg" class="easyui-dialog" style="width:400px; height:280px; padding: 10px 20px" closed="true" buttons="#dlg-buttons">
<form id="fm" method="post">
<table>
<tr>
<td>班级名称:</td>
<td><input type="text" name="gradeName" id="gradeName" class="easyui-validatebox" required="true"/></td>
</tr>
<tr>
<td valign="top">班级描述:</td>
<td><textarea rows="9" cols="35" name="gradeDesc" id="gradeDesc"></textarea></td>
</tr>
</table>
</form>
</div>
<div id="dlg-buttons">
<a href="javascript:saveGrade()" class="easyui-linkbutton" iconCls="icon-ok">保存</a>
<a href="javascript:closeGradeDialog()" class="easyui-linkbutton" iconCls="icon-cancel">关闭</a>
</div>
具体的效果就是点击添加或者修改按钮时,出现以下界面;
这里开始在前面的链接里面添加具体的js方法;
<div id="tb">
<div>
<a href="javascript:openGradeAddDialog()" class="easyui-linkbutton" iconCls="icon-add" plain="true">添加</a>
<a href="javascript:openGradeModifyDialog()" class="easyui-linkbutton" iconCls="icon-edit" plain="true">修改</a>
<a href="javascript:deleteGrade()" class="easyui-linkbutton" iconCls="icon-remove" plain="true">删除</a>
</div>
<div> 班级名称: <input type="text" id="s_gradeName" name="s_gradeName"/> <a href="javascript:searchGrade()" class="easyui-linkbutton" iconCls="icon-search" plain="true">搜索</a></div>
</div>
//添加
function openGradeAddDialog(){
$('#dlg').dialog('open').dialog('setTitle','添加班级信息');
url="gradeSave";
}
//修改
function openGradeModifyDialog(){
//选择指定行
var selectedRows=$('#dg').datagrid('getSelections');
if(selectedRows.length!=1){
$.messager.alert("系统提示","请选择1条要修改的数据!");
return;
}
//获取第一条横向数据
var row=selectedRows[0];
$('#dlg').dialog('open').dialog('setTitle','编辑班级信息');
$('#fm').form('load',row);
url="gradeSave?id="+row.id;
}
//关闭
function closeGradeDialog(){
$('#dlg').dialog('close');
resetValue();
}
//清空
function resetValue(){
$('#gradeName').val("");
$('#gradeDesc').val("");
}
//保存
function saveGrade() {
$('#fm').form("submit",{
url:url,
onSubmit:function(){
return $(this).form('validate');
},
success:function(result){
if(result.errorMsg){
$.messager.alert("系统提示",result.errorMsg);
return;
}else{
$.messager.alert("系统提示","保存成功!");
resetValue();
$('#dlg').dialog('close');
$("#dg").datagrid("reload");
}
}
});
}
3. web层,写servlet,调用前面的方法;
我们新建一个Servlet,这里调用前面的方法
request.setCharacterEncoding("utf-8");
String gradeName=request.getParameter("gradeName");
String gradeDesc=request.getParameter("gradeDesc");
String id=request.getParameter("id");
Grade grade=new Grade(gradeName,gradeDesc);
if(StringUtil.isNotEmpty(id)){
grade.setId(Integer.parseInt(id));
}
Connection con=null;
try {
con=dbUtil.getCon();
int saveNums=0;
JSONObject result=new JSONObject();
if(StringUtil.isNotEmpty(id)){
saveNums=gradeDao.gradeModify(con, grade);
}else{
saveNums=gradeDao.gradeAdd(con, grade);
}
if(saveNums>0){
result.put("success", "true");
}else{
result.put("success", "true");
result.put("errorMsg", "保存失败");
}
//向页面传送数据
ResponseUtil.write(response,result);
} catch (Exception e) {
e.printStackTrace();
} finally {
try {
dbUtil.closeCon(con);
} catch (Exception e) {
e.printStackTrace();
}
}
配置web.xml;
<!--保存班级信息请求-->
<servlet>
<servlet-name>gradeSaveServlet</servlet-name>
<servlet-class>com.java.web.GradeSaveServlet</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>gradeSaveServlet</servlet-name>
<url-pattern>/gradeSave</url-pattern>
</servlet-mapping>
经测验,添加和修改都没有问题!