《SSI+Jquery实现增删改查(无刷新).doc》由会员分享,可在线阅读,更多相关《SSI+Jquery实现增删改查(无刷新).doc(24页珍藏版)》请在三一文库上搜索。
1、 SSI+jquery简单增删改查一、 配置环境加入jar包,我以前写过一个文档,里面已经将jar包写好,请参考:http:/ 编写后台代码及配置文件1、 写实体beanStudent.javapackage com.vstsoft.model;public class Studentprivate int id ;private String username ;private String stuid ;private String email ;private String phone ;private String address ;public int getId() return
2、id;public void setId(int id) this.id = id;public String getUsername() return username;public void setUsername(String username) this.username = username;public String getStuid() return stuid;public void setStuid(String stuid) this.stuid = stuid;public String getEmail() return email;public void setEma
3、il(String email) this.email = email;public String getPhone() return phone;public void setPhone(String phone) this.phone = phone;public String getAddress() return address;public void setAddress(String address) this.address = address;2、 编写dao层及其实现StudentDao.javapackage com.vstsoft.dao;import java.util
4、.List;import com.vstsoft.model.Student;public interface StudentDao public List queryAll();/查询全部public boolean save(Student student) ;/增加public boolean del(int id) ;/删除public boolean update(Student student) ;/更新public Student queryById(int id);/按ID查询StudentDaoImpl.javapackage com.vstsoft.dao.impl;imp
5、ort java.sql.SQLException;import java.util.List;import com.ibatis.sqlmap.client.SqlMapClient;import com.vstsoft.dao.StudentDao;import com.vstsoft.model.Student;public class StudentDaoImpl extends Student implements StudentDao private SqlMapClient sqlMapClient;public void setSqlMapClient(SqlMapClient
6、 sqlMapClient) this.sqlMapClient = sqlMapClient;public boolean del(int id) try int b = sqlMapClient.delete(del, id);if(b0)return true;elsereturn false; catch (SQLException e) e.printStackTrace();return false;public List queryAll() List list = null;try list = sqlMapClient.queryForList(queryAll); catc
7、h (SQLException e) e.printStackTrace();return list;public Student queryById(int id) Student student = null;try student = (Student) sqlMapClient.queryForObject(queryById, id); catch (SQLException e) e.printStackTrace();return student;public boolean save(Student student) boolean b ;try sqlMapClient.in
8、sert(saveStu, student);b = true ; catch (SQLException e) e.printStackTrace();b = false;return b ;public boolean update(Student student) boolean b ;try sqlMapClient.update(updateStu, student);b = true; catch (SQLException e) e.printStackTrace();b = false;return b;3、 编写服务层及其实现StudentService.javapackag
9、e com.vstsoft.service;import java.util.List;import com.vstsoft.model.Student;public interface StudentService public List queryAll();/查询全部public boolean save(Student student) ;/增加public boolean del(int id) ;/删除public boolean update(Student student) ;/更新public Student queryById(int id);/按ID查询StudentSe
10、rviceImpl.javapackage com.vstsoft.service.impl;import java.util.List;import com.vstsoft.dao.StudentDao;import com.vstsoft.model.Student;import com.vstsoft.service.StudentService;public class StudentServiceImpl implements StudentService private StudentDao sdao ;public boolean del(int id) boolean b =
11、sdao.del(id);if(b)return true ;elsereturn false;public List queryAll() List list = sdao.queryAll();return list;public Student queryById(int id) Student student = sdao.queryById(id);return student;public boolean save(Student student) boolean b = sdao.save(student);if(b)return true;elsereturn false;pu
12、blic boolean update(Student student) boolean b = sdao.update(student);if(b)return true;elsereturn false;public StudentDao getSdao() return sdao;public void setSdao(StudentDao sdao) this.sdao = sdao;/4、编写控制层ActionStudentAction.javapackage com.vstsoft.action;import java.util.List;import javax.servlet.
13、http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;import net.sf.json.JSONObject;import org.apache.struts2.ServletActionContext;import com.opensymphony.xwork2.ActionSupport;import com.vstsoft.model.Student;import com.vstsoft.service.StudentService;public class StudentAction extend
14、s ActionSupportprivate StudentService ss ;private List list;private int id ;private String username ;private String stuid;private String phone;private String address;private String email;public String getUsername() return username;public void setUsername(String username) this.username = username;pub
15、lic int getId() return id;public void setId(int id) this.id = id;public List getList() return list;public void setList(List list) this.list = list;public StudentService getSs() return ss;public void setSs(StudentService ss) this.ss = ss;HttpServletRequest request = ServletActionContext.getRequest();
16、public String queryAll() throws Exception System.out.println(*queryAll*);List list = ss.queryAll();JSONObject json = new JSONObject();json.accumulate(list, list);System.out.println(json+json);HttpServletResponse response = ServletActionContext.getResponse();response.setContentType(text/x-json;charse
17、t=UTF-8);response.setHeader(Cache-Control, no-cache); response.getWriter().print(json.toString();return null;public String del() throws Exception System.out.println(del);System.out.println(id=+this.getId();ss.del(this.getId();return null;public String queryById() throws Exception System.out.println(
18、id=+this.getId();Student student = ss.queryById(this.getId();JSONObject json = new JSONObject();json.accumulate(student, student);System.out.println(json=+json);HttpServletResponse response = ServletActionContext.getResponse();response.setContentType(text/x-json;charset=UTF-8);response.setHeader(Cac
19、he-Control, no-cache); response.getWriter().print(json.toString();return null;public String change() throws Exception System.out.println(*change*);Student student = new Student();student.setUsername(this.username);student.setStuid(this.stuid);student.setPhone(this.phone);student.setEmail(this.email)
20、;student.setAddress(this.address);student.setId(this.id);ss.update(student);return null;public String save() throws Exception Student student = new Student();student.setUsername(this.username);student.setStuid(this.stuid);student.setPhone(this.phone);student.setEmail(this.email);student.setAddress(t
21、his.address);ss.save(student);return null;public String getStuid() return stuid;public void setStuid(String stuid) this.stuid = stuid;public String getPhone() return phone;public void setPhone(String phone) this.phone = phone;public String getAddress() return address;public void setAddress(String ad
22、dress) this.address = address;public String getEmail() return email;public void setEmail(String email) this.email = email;4、 编写配置文件Struts.xml !- - applicationContext.xml classpath:/com/vstsoft/sqlmap/SqlMapConfig.xml Log4j.propertieslog4j.appender.stdout=org.apache.log4j.ConsoleAppenderlog4j.appende
23、r.stdout.layout=org.apache.log4j.PatternLayoutlog4j.appender.stdout.layout.ConversionPattern=%d %p %c - %m%.ibatis=mon.jdbc.SimpleDataSource=mon.jdbc.ScriptRunner=.ibatis.sqlmap.engine.impl.SqlMapClientDelegate=debuglog4j.logger.java.sql.Connection=debuglog4j.logger.java.sql.Statement=debuglog4j.log
24、ger.java.sql.PreparedStatement=debug,stdoutweb.xmlcontextConfigLocationclasspath*:applicationContext.xmlstruts2org.apache.struts2.dispatcher.FilterDispatcherstruts2/*org.springframework.web.context.ContextLoaderListenerindex.jsp ConfigServlet ConfigServlet ConfigServlet /servlet/ConfigServlet SqlMapConfig.xml student.xmlselect * from student order by id asc