Spring完整实例.doc

孙乐Spring完整实例Web.xml文件配置： springorg.springframework.web.servlet.DispatcherServlet contextConfigLocation classpath:applicationContext.xmlspring*.do index.jsp applicationContext.xml文件配置： loginfail loginfailloginloginInsertorg.springframework.web.servlet.view.JstlView/.jsp com.mysql.jdbc.Driverjdbc:mysql:/localhost:3306/testroot1234 PROPAGATION_REQUIREDPROPAGATION_REQUIRED,readOnly接口定义：package com.login.DAO;import java.util.List;/* * 定义接口 * author 孙乐 * */public interface loginDao public List login() throws Exception; public boolean insertUser(String username,String password) throws Exception; public void deleteUser() throws Exception; public void updateUser() throws Exception;业务层的JavaBean，login.java(调用实现类，实现查询);loginInsert.java（调用实现类，实现增、删、改）代码如下：Login.java：package com.login.action;import java.sql.ResultSet;import java.util.List;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;import org.apache.log4j.Logger;import org.apache.log4j.PropertyConfigurator;import org.springframework.web.servlet.ModelAndView;import org.springframework.web.servlet.mvc.Controller;import com.login.DAO.loginDao;public class login implements Controller /注入loginDo类 public loginDao loginDao; private static Logger logger = Logger.getLogger(login.class); public String success_view; public String false_view; public ModelAndView handleRequest(HttpServletRequest request,HttpServletResponse responce) throws Exception (孙乐在Spring中使用log4j); List list = loginDao.login(); request.setAttribute(list, list); /创建模型视图对象，返回相应的jsp页面 ModelAndView mv =null; if(list.size()0) mv = new ModelAndView(success_view); else mv = new ModelAndView(false_view); return mv;public loginDao getloginDao() return loginDao;public void setloginDao(loginDao loginDao) this.loginDao = loginDao;public String getSuccess_view() return success_view;public void setSuccess_view(String success_view) this.success_view = success_view;public String getFalse_view() return false_view;public void setFalse_view(String false_view) this.false_view = false_view;loginInsert.java:package com.login.action;import java.sql.ResultSet;import java.util.List;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;import org.apache.log4j.Logger;import org.apache.log4j.PropertyConfigurator;import org.springframework.web.servlet.ModelAndView;import org.springframework.web.servlet.mvc.Controller;import com.login.DAO.loginDao;/* * 业务层，调用增、删、改 * author 孙乐 * */public class loginInsert implements Controller /注入loginDo类 public loginDao loginDao; private static Logger logger = Logger.getLogger(login.class); public String success_view; public String false_view; public ModelAndView handleRequest(HttpServletRequest request,HttpServletResponse responce) throws Exception (孙乐在Spring中使用transaction); String username=request.getParameter(userName); String password=request.getParameter(password); System.out.println(username); /调用实现方法 loginDao.deleteUser(); loginDao.updateUser(); boolean flag =loginDao.insertUser(username,password); /创建模型视图对象，返回相应的jsp页面 ModelAndView mv =null; if(flag) mv = new ModelAndView(success_view); else mv = new ModelAndView(false_view); return mv;public loginDao getloginDao() return loginDao;public void setloginDao(loginDao loginDao) this.loginDao = loginDao;public String getSuccess_view() return success_view;public void setSuccess_view(String success_view) this.success_view = success_view;public String getFalse_view() return false_view;public void setFalse_view(String false_view) this.false_view = false_view;数据操作层：loginDaoImpl.java，代码如下：package com.login.DaoImpl;import java.sql.ResultSet;import java.sql.SQLException;import java.util.List;import javax.sql.DataSource;import org.apache.log4j.Logger;import org.springframework.jdbc.core.JdbcTemplate;import org.springframework.jdbc.core.RowCallbackHandler;import org.springframework.jdbc.core.RowMapper;import org.springframework.transaction.PlatformTransactionManager;import org.springframework.transaction.TransactionStatus;import org.springframework.transaction.support.TransactionCallback;import org.springframework.transaction.support.TransactionTemplate;import org.springframework.web.servlet.ModelAndView;import com.login.DAO.loginDao;import com.login.bean.userInfo;/* * 数据操作层 * author 孙乐 * */public class loginDaoImpl implements loginDaoprivate DataSource dataSource;private static Logger logger = Logger.getLogger(loginDaoImpl.class); /* * 查询数据库，查询某个数据库表中的所有信息 * return List * throws Exception */public List login() throws Exception JdbcTemplate jdbcTemplate = new JdbcTemplate(getDataSource(); String sql=select * from user; List list=jdbcTemplate.query(sql, new Object, new RowMapper() public Object mapRow(ResultSet rs, int index) userInfo user = new userInfo(); try user.setPassword(rs.getString(password);user.setUserName(rs.getString(username); catch (SQLException e) e.printStackTrace(); return user; ); (执行全部查询操作); return list;/* * 向数据库中插入用户 */public boolean insertUser(String username,String password) final userInfo user = new userInfo();user.setPassword(password);user.setUserName(username); JdbcTemplate jt = new JdbcTemplate(getDataSource();jt.update(insert into user (userName,password) values (+user.getPassword()+,+user.getUserName()+););(TransactionTemplate执行插入操作); return true;/* * 执行删除用户的操作 */public void deleteUser() throws Exception JdbcTemplate jt = new JdbcTemplate(getDataSource();int j=jt.update(delete from user where userName=zzz);(执行删除操作！);/throw new RuntimeException(); /* * 执行更新操作 */public void updateUser() throws Exception JdbcTemplate jt = new JdbcTemplate(getDataSource();int j=jt.update(update user set userName=321 where userName=987);(执行更新操作);public DataSource getDataSource() return dataSource;public void setDataSource(DataSource dataSource) this.dataSource = dataSource;用户信息JavaBean：package com.login.bean;/* * 用户信息类 * author 孙乐 * */public class userInfo pu