SSI特制框架搭建加小例子.docx

Web.xmltravelindex.jspstrutsorg.apache.struts2.dispatcher.ng.filter.StrutsPrepareAndExecuteFilterstruts/*org.springframework.web.context.ContextLoaderListenerorg.springframework.web.context.request.RequestContextListenerapplicationContext.xml pertiesuFF0Clog4j.rootLogger=DEBUG, Console#Consolelog4j.appender.Console=org.apache.log4j.ConsoleAppenderlog4j.appender.Console.layout=org.apache.log4j.PatternLayoutlog4j.appender.Console.layout.ConversionPattern=%d %t %-5p %c - %m%nlog4j.logger.java.sql.ResultSet=INFO.apache=INFOlog4j.logger.java.sql.Connection=DEBUGlog4j.logger.java.sql.Statement=DEBUGlog4j.logger.java.sql.PreparedStatement=DEBUGxxx.japService(estimateService)public class EstimateServiceImpl implements EstimateService Map map = new HashMap();List estimateList = new ArrayList();Serviceimpl.javaAutowiredQualifier(estimateDao)private EstimateDao estimateDao;Overridepublic boolean runEstimate(Estimate estimate, User user, Topic topic) String userId = user.getUserId();int topicId = topic.getTopicId();map.put(userId, userId);map.put(topicId, topicId);estimateDao.deleteEstimate(map);map.put(estimate, estimate);int i = estimateDao.runEstimate(map);if (i 0) return true;else return false;在Dao实现类里面添加private SqlMapClientTemplate sqlMapClientTemplate; public void setSqlMapClientTemplate(SqlMapClientTemplate sqlMapClientTemplate) this.sqlMapClientTemplate = sqlMapClientTemplate; classpath:perties classpath:SqlMapConfig.xml SqlMapConfig.xml User.xml(SqlMap.xml) insert into t_user(usercode,userpswd,username,orgtype,regdate) values(#usercode#,#userpswd#,#username#,#orgtype#,#regdate#) 属性文件perties url=jdbc:oracle:thin::1521:ljh driverClass=oracle.jdbc.driver.OracleDriver username=scott password=ti daoimpl.javapublic class CommonDaoImpl extends SqlMapClientTemplate implements CommonDao Override public Object queryObject(String id, Object Paramter) throws SQLException return getSqlMapClient().queryForObject(id, Paramter); Override public List queryList(String sqlId, Object parameter) throws SQLException return getSqlMapClient().queryForList(sqlId,parameter); Override public Object addObj(String sqlId, Object parameter) throws SQLException return getSqlMapClient().insert(sqlId, parameter); Override public int del(String sqlId, Object parameter) throws SQLException return getSqlMapClient().delete(sqlId, parameter); Override public int editObj(String sqlId, Object parameter) throws SQLException return getSqlMapClient().update(sqlId, parameter); Serviceimpl.javapublic List getlistUser(UserInfo user) throws SQLException /查询的时候由于配置文件中是 对象.字段 所以我们