第一篇 Hibernate实用技术

Transcription

1 Spring Spring 1 Spring Spring Spring Spring Spring Spring Spring Spring...5

2 2.1.1 JDK JDK Path Classpath Eclipse Eclipse Tomcat TOMCAT_HOME Eclipse Tomcat Eclipse Tomcat Spring Spring Eclipse Spring Spring HelloWorld HelloWorld Java HelloWorld.java Spring config.xml TestHelloWorld.java Spring Hello.java ChHello EnHello Spring config.xml TestHelloWorld.java Spring 3 Spring / IoC DI interface...25 injection Set setter injection constructor...26 injection 3.3 HelloWorld HelloWorld.java config.xml TestHelloWorld.java

3 4 Spring Bean Bean Bean id name Bean class Singleton Bean null depend-on Bean Bean Bean Bean Bean Bean ref local bean parent Bean byname bytype constructor autodetect no Bean simple object all none List Set Map Properties Bean BeanWrapper Bean BeanFactory Bean ApplicationContext Bean...58

4 Bean ApplicationContext Spring AOP AOP AOP AOP OOP AOP Java Java Java AOP Pointcut Advice Advisor Spring 3 Pointcut Spring Advice Interception Around Before After Returning Throw Introduction Spring Advisor ProxyFactoryBean AOP ProxyFactoryBean ProxyFactoryBean Spring AOP Interception Around Before After Returning Throw Spring AOP Java CGLIB Spring...97

5 5.11 Spring AOP Advice ExceptionHandler.java Advice TimeHandler.java LogicInterface.java Logic1.java Logic2.java config.xml Logic1 TestAop.java Logic Logic2 TestAop.java Logic ProxyFactoryBean config.xml Logic1 TestAop.java ProxyFactoryBean Logic Logic2 TestAop.java ProxyFactoryBean Logic Spring JDBC Spring Spring Spring Jdbc XML DataSource Spring DriverManagerDataSource DBCP Tomcat JNDI JdbcTemplate Template TransactionTemplate JdbcTemplate...137

6 7.3.4 JdbcTemplate JdbcTemplate ORM ORM Hibernate ibatis Spring Web Web MVC MVC MVC MVC Model Model Spring MVC Jsp HelloWord Spring MVC Web.xml jsp index.jsp HelloWorldAction.java Spring dispatcherservlet-servlet.xml Tomcat index.jsp jstl dispatcherservlet-servlet.xml Log4j Spring MVC ModelAndView Jstl Spring MVC Controller Controller SimpleFormController MultiActionController Spring MVC DispatcherServlet Web DispatcherServlet

7 Validator cookie Spring MVC Eclipse Tomcat mymvc mymvc/web-inf/src web.xml login.jsp success.jsp Bean UserValidator.java Login.java dispatcherservlet-servlet.xml Spring Timer Quartz Spring Spring Timer Spring Quartz Spring 10 Spring Struts Struts Struts Struts...228

8 10.2 Struts Struts Struts Jsp HelloWord Struts web.xml jsp index.jsp HelloWorldAction.java Struts struts-config.xml Tomcat Struts ActionServlet Action Action Mapping ActionForm DispatchAction Struts Bean Logic Html Spring Struts Spring ActionSupport Spring DelegatingRequestProcessor Spring DelegatingActionProxy Spring Struts web.xml regedit.jsp success.jsp User.java Struts struts-config.xml Spring config.xml RegeditAction.java Regedit.java RegeditImpl.java Spring Hibernate Hibernate Hibernate Hibernate Hibernate...279

9 11.3 Hibernate POJO POJO Xml Hibernate Hibernate Hibernate Hibernate POJO Hibernate Configuration Hibernate SessionFactory Session Session Connection xml Spring Hibernate Hibernate-Context.xml Struts Spring Hibernate Spring Struts Hibernate web.xml regedit.jsp success.jsp User.hbm.xml POJO UserDAO.java UserDAOImpl.java Struts struts-config.xml Spring config.xml RegeditAction.java Regedit.java RegeditImpl.java Spring Ant Ant Ant Ant Ant Spring Ant Eclipse Ant...353

10 build.xml Ant Spring Junit Junit Junit Junit Junit Spring Junit Eclipse Junit TestCase Junit Junit Ant Junit build.xml Ant Spring 14 Spring JDK Tomcat Ant Eclipse mynews Eclipse Ant build Web.xml UML Jsp show.jsp release.jsp regedit.jsp login.jsp error.jsp...392

11 14.6 xml POJO xml POJO VO DAO User.java UsersAuthor.java News.java NewsType.java DAO UserDAO.java DAO NewsDAO.java DAO NewsTypeDAO.java DAO UserDAOImpl.java DAO NewsDAOImpl.java DAO NewsTypeDAOImpl.java Login.java Regedit.java Release.java LoginImpl.java RegeditImpl.java ReleaseImpl.java LoginController.java RegeditController.java ReleaseController.java ShowController.java NewsUtil.java dispatcherservlet-servlet.xml

12 7 Spring 6 Spring Spring Spring 7.1 Jdbc Jdbc JDBC //******* TimeBook.java************** Public Class HelloWorld { Connection conn =null; Statement stmt = null; try { // Class.forName(com.microsoft.jdbc.sqlserver.SQLServerDriver); conn = DriverManager.getConnection(jdbc:microsoft:sqlserver://localhost:1433/stdb, admin, admin); // conn.setautocommit(false); stmt = conn.createstatement(); // stmt.executeupdate("insert into hello values(1, gf, HelloWorld )'"); // conn.commit(); catch (SQLException e) { if (conn!= null) { try { // conn.rollback(); catch (SQLException ex) { System.out.println( + ex); finally { if (stmt!= null) { try { stmt.close(); catch (SQLException ex) { System.out.println( + ex); if (conn!= null) { try {

13 conn.close(); catch (SQLException ex) { System.out.println( + ex); Jdbc Spring Jdbc hello 3 id name msg id XML DataSource Spring 3 Xml DataSource Spring DriverManagerDataSource DBCP Tomcat JNDI Spring DriverManagerDataSource 6 DataSource Spring DriverManagerDataSource DriverManagerDataSource Jdbc DriverManagerDataSource <?xml version="1.0" encoding="utf-8"?> <!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN//EN" " <beans> <! datasource --> <bean id="datasource" class="org.springframework.jdbc.datasource.drivermanagerdatasource"> <property name="driverclassname"> <value>com.microsoft.jdbc.sqlserver.sqlserverdriver</value> <property name="url"> <value>jdbc:microsoft:sqlserver://localhost:1433/stdb</value> <property name="name"> <value>admin</value> <property name="msg"> <value>admin</value> </bean> <! transactionmanager --> <bean id="transactionmanager" class="org.springframework.jdbc.datasource.datasourcetransactionmanager">

14 <property name="datasource"> <ref bean="datasource"/> </bean> <! DAO --> <bean id="hellodao" class="com.gc.action.hellodao"> <property name="datasource"> <ref bean="datasource"/> <property name="transactionmanager"> <ref bean="transactionmanager"/> </bean> </beans> id hellodao Bean 6 HelloDAO.java //******* HelloDAO.java************** package com.gc.action; import javax.sql.datasource; import org.springframework.jdbc.core.*; import org.springframework.transaction.*; import org.springframework.transaction.support.*; import org.springframework.dao.*; public class HelloDAO { private DataSource datasource; private PlatformTransactionManager transactionmanager; public void setdatasource(datasource datasource) { this.datasource = datasource; public void settransactionmanager(platformtransactionmanager transactionmanager) { this.transactionmanager = transactionmanager; public int create(string msg) { TransactionTemplate transactiontemplate = new TransactionTemplate(transactionManager); Object result = transactiontemplate.execute( new TransactionCallback() { public Object dointransaction(transactionstatus status) { // );. // resultobject return resultobject;

15 7.2.2 DBCP Spring DBCP DBCP Spring DBCP spring-framework-2.0-m1\lib\jakarta-commons commons-collections.jar commons-dbcp.jar commons-pool.jar ClassPath DBCP <?xml version="1.0" encoding="utf-8"?> <!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN//EN" " <beans> <! datasource --> <bean id="datasource" class="org.apache.commons.dbcp.basicdatasource" destroy-method="close"> <! sqlserver --> <property name="driverclassname"> <value>com.microsoft.jdbc.sqlserver.sqlserverdriver</value> <! Url --> <property name="url"> <value>jdbc:microsoft:sqlserver://localhost:1433/stdb</value> <! --> <property name="name"> <value>admin</value> <! --> <property name="msg"> <value>admin</value> </bean> <! transactionmanager --> <bean id="transactionmanager" class="org.springframework.jdbc.datasource.datasourcetransactionmanager"> <property name="datasource"> <ref bean="datasource"/> </bean> <! DAO --> <bean id="hellodao" class="com.gc.action.hellodao"> <property name="datasource"> <ref bean="datasource"/> <property name="transactionmanager"> <ref bean="transactionmanager"/> </bean> </beans> HelloDAO

16 7.2.3 Tomcat JNDI DBCP Spring Web Web Tomcat Spring Tomcat JNDI Tomcat server.xml <Context path="/myapp" reloadable="true" docbase="d:\eclipse\workspace\myapp" workdir="d:\eclipse\workspace\myapp\work" > <Resource name="jdbc/opendb" auth="container" type="javax.sql.datasource" factory="org.apache.tomcat.dbcp.dbcp.basicdatasourcefactory" driverclassname="com.microsoft.jdbc.sqlserver.sqlserverdriver" url=" jdbc:microsoft:sqlserver://localhost:1433/stdb" <! --> name="admin" <! --> msg="admin" <! --> maxactive="10000" <! --> maxidle="10000" <! --> maxwait="10000" removeabandoned="true" removeabandonedtimeout="10" logabandoned="true" /></Context> Spring <?xml version="1.0" encoding="utf-8"?> <!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN//EN" " <beans> <! datasource --> <bean id="datasource" class="org.springframework.jndi.jndiobjectfactorybean"> <property name="jndiname"> <value>jdbc/opendb</value> </bean> <! transactionmanager --> <bean id="transactionmanager" class="org.springframework.jdbc.datasource.datasourcetransactionmanager"> <property name="datasource"> <ref bean="datasource"/> </bean> <! DAO --> <bean id="hellodao" class="com.gc.action.hellodao"> <property name="datasource"> <ref bean="datasource"/>

17 <property name="transactionmanager"> <ref bean="transactionmanager"/> </bean> </beans> HelloDAO 3 DataSource Jdbc Spring Jdbc 7.3 JdbcTemplate JdbcTemplate Template Spring TransactionTemplate JdbcTemplate Template Template 1 Transaction Transaction.java //******* Transaction.java************** public abstract class Transaction{ // public Object execute() throws TransactionException { this.transactionmanager.gettransaction(this); Object result = null; try { result = dointransaction(); catch (Error err) { // Transactional code threw error -> rollback this.transactionmanager.rollback(this); throw err; this.transactionmanager.commit(this); return result; // Public abstract Object dointransaction (); 2 SubTransaction SubTransaction.java

18 //******* SubTransaction.java************** public class SubTransaction extends Transaction { // Public Object dointransaction () { // 3 SubTransaction. Execute TransactionTemplate Spring Template Spring 1 TransactionTemplate //******* TransactionTemplate.java************** public class TransactionTemplate extends DefaultTransactionDefinition implements InitializingBean{ // public Object execute(transactioncallback action) throws TransactionException { TransactionStatus status = this.transactionmanager.gettransaction(this); Object result = null; try { result = action.dointransaction(status); catch (RuntimeException ex) { // Transactional code threw application exception -> rollback rollbackonexception(status, ex); throw ex; catch (Error err) { // Transactional code threw error -> rollback rollbackonexception(status, err); throw err; this.transactionmanager.commit(status); return result; // private void rollbackonexception(transactionstatus status, Throwable ex) throws TransactionException { try { this.transactionmanager.rollback(status);

19 catch (RuntimeException ex2) { throw ex2; catch (Error err) { throw err; TransactionTemplate execute execute TransactionCallback dointransaction 2 TransactionCallback TransactionCallback.java //******* TransactionCallback.java************** public interface TransactionCallback { Object dointransaction(transactionstatus status); 3 TransactionCallback dointransaction //******* HelloDAO.java************** package com.gc.action; import javax.sql.datasource; import org.springframework.jdbc.core.*; import org.springframework.transaction.*; import org.springframework.transaction.support.*; import org.springframework.dao.*; public class HelloDAO { private DataSource datasource; private PlatformTransactionManager transactionmanager; public void setdatasource(datasource datasource) { this.datasource = datasource; public void settransactionmanager(platformtransactionmanager transactionmanager) { this.transactionmanager = transactionmanager; public int create(string msg) { TransactionTemplate transactiontemplate = new TransactionTemplate(transactionManager); Object result = transactiontemplate.execute( new TransactionCallback() { public Object dointransaction(transactionstatus status) { //

20 );. // resultobject return resultobject; HelloDAO create TransactionCallback dointransaction Spring JdbcTemplate Template JdbcTemplate JdbcTemplate JdbcTemplate Jdbc JdbcTemplate Template TransactionTemplate JdbcTemplate //******* JdbcTemplate.java************** public class JdbcTemplate extends JdbcAccessor implements JdbcOperations { // public Object execute(connectioncallback action) throws DataAccessException { Connection con = DataSourceUtils.getConnection(getDataSource()); try { Connection contouse = con; if (this.nativejdbcextractor!= null) { // Extract native JDBC Connection, castable to OracleConnection or the like. contouse = this.nativejdbcextractor.getnativeconnection(con); else { // Create close-suppressing Connection proxy, also preparing returned Statements. contouse = createconnectionproxy(con); return action.doinconnection(contouse); catch (SQLException ex) { // Release Connection early, to avoid potential connection pool deadlock // in the case when the exception translator hasn't been initialized yet. DataSourceUtils.releaseConnection(con, getdatasource()); con = null; throw getexceptiontranslator().translate("connectioncallback", getsql(action), ex); finally { DataSourceUtils.releaseConnection(con, getdatasource()); //

21 public Object execute(statementcallback action) throws DataAccessException { Connection con = DataSourceUtils.getConnection(getDataSource()); Statement stmt = null; try { Connection contouse = con; if (this.nativejdbcextractor!= null && this.nativejdbcextractor.isnativeconnectionnecessaryfornativestatements()) { contouse = this.nativejdbcextractor.getnativeconnection(con); stmt = contouse.createstatement(); applystatementsettings(stmt); Statement stmttouse = stmt; if (this.nativejdbcextractor!= null) { stmttouse = this.nativejdbcextractor.getnativestatement(stmt); Object result = action.doinstatement(stmttouse); SQLWarning warning = stmt.getwarnings(); throwexceptiononwarningifnotignoringwarnings(warning); return result; catch (SQLException ex) { // Release Connection early, to avoid potential connection pool deadlock // in the case when the exception translator hasn't been initialized yet. JdbcUtils.closeStatement(stmt); stmt = null; DataSourceUtils.releaseConnection(con, getdatasource()); con = null; throw getexceptiontranslator().translate("statementcallback", getsql(action), ex); finally { JdbcUtils.closeStatement(stmt); DataSourceUtils.releaseConnection(con, getdatasource()); // sql public void execute(final String sql) throws DataAccessException { if (logger.isdebugenabled()) { logger.debug("executing SQL statement [" + sql + "]"); class ExecuteStatementCallback implements StatementCallback, SqlProvider { public Object doinstatement(statement stmt) throws SQLException { stmt.execute(sql); return null; public String getsql() { return sql; execute(new ExecuteStatementCallback());

22 JdbcTemplate TransactionTemplate execute execute TransactionTemplate JdbcTemplate sql JdbcTemplate JdbcTemplate JdbcTemplate 1 Spring <?xml version="1.0" encoding="utf-8"?> <!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN//EN" " <beans> <! datasource --> <bean id="datasource" class="org.springframework.jdbc.datasource.drivermanagerdatasource"> <! sqlserver --> <property name="driverclassname"> <value>com.microsoft.jdbc.sqlserver.sqlserverdriver</value> <! Url --> <property name="url"> <value>jdbc:microsoft:sqlserver://localhost:1433/stdb</value> <! --> <property name="name"> <value>admin</value> <! --> <property name="msg"> <value>admin</value> </bean> <! transactionmanager --> <bean id="transactionmanager" class="org.springframework.jdbc.datasource.datasourcetransactionmanager"> <property name="datasource"> <ref bean="datasource"/> </bean> <! DAO --> <bean id="hellodao" class="com.gc.action.hellodao"> <property name="datasource"> <ref bean="datasource"/> <property name="transactionmanager"> <ref bean="transactionmanager"/> </bean>

23 </beans> 6 2 HelloDAO JdbcTemplate HelloDAO.java //******* HelloDAO.java************** package com.gc.action; import javax.sql.datasource; import org.springframework.jdbc.core.*; import org.springframework.transaction.*; import org.springframework.transaction.support.*; import org.springframework.dao.*; public class HelloDAO { private DataSource datasource; private PlatformTransactionManager transactionmanager; public void setdatasource(datasource datasource) { this.datasource = datasource; public void settransactionmanager(platformtransactionmanager transactionmanager) { this.transactionmanager = transactionmanager; // JdbcTemplate public int create(string msg) { DefaultTransactionDefinition def = new DefaultTransactionDefinition(); TransactionStatus status = transactionmanager.gettransaction(def); try { JdbcTemplate jdbctemplate = new JdbcTemplate(dataSource); jdbctemplate.update("insert INTO hello VALUES(1, 'gf', 'HelloWord')"); catch (DataAccessException ex) { // status.setrollbackonly(); transactionmanager.rollback(status); throw ex; finally { transactionmanager.commit(status); datasource JdbcTemplate JdbcTemplate update Jdbc 2 3 datasource JdbcTemplate JdbcTemplate JdbcTemplate datasource <?xml version="1.0" encoding="utf-8"?>

24 <!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN//EN" " <beans> <! datasource --> <bean id="datasource" class="org.springframework.jdbc.datasource.drivermanagerdatasource"> <! sqlserver --> <property name="driverclassname"> <value>com.microsoft.jdbc.sqlserver.sqlserverdriver</value> <! Url --> <property name="url"> <value>jdbc:microsoft:sqlserver://localhost:1433/stdb</value> <! --> <property name="name"> <value>admin</value> <! --> <property name="msg"> <value>admin</value> </bean> <! transactionmanager --> <bean id="transactionmanager" class="org.springframework.jdbc.datasource.datasourcetransactionmanager"> <property name="datasource"> <ref bean="datasource"/> </bean> <! jdbctemplate --> <bean id="jdbctemplate" class="org.springframework.jdbc.core.jdbctemplate"> <property name="datasource"> <ref bean="datasource"/> </bean> <! DAO --> <bean id="hellodao" class="com.gc.action.hellodao"> <property name=" jdbctemplate "> <ref bean=" jdbctemplate "/> <property name="transactionmanager"> <ref bean="transactionmanager"/> </bean> </beans> jdbctemplate datasource jdbctemplate jdbctemplate HelloDAO 4 HelloDAO JdbcTemplate datasource jdbctemplate HelloDAO.java //******* HelloDAO.java**************

25 package com.gc.action; import javax.sql.datasource; import org.springframework.jdbc.core.*; import org.springframework.transaction.*; import org.springframework.transaction.support.*; import org.springframework.dao.*; import org.springframework.jdbc.core.jdbctemplate; public class HelloDAO { private JdbcTemplate jdbctemplate; private PlatformTransactionManager transactionmanager; public void setjdbctemplate(jdbctemplate jdbctemplate) { this.jdbctemplate = jdbctemplate; public void settransactionmanager(platformtransactionmanager transactionmanager) { this.transactionmanager = transactionmanager; // jdbctemplate public int create(string msg) { DefaultTransactionDefinition def = new DefaultTransactionDefinition(); TransactionStatus status = transactionmanager.gettransaction(def); try { jdbctemplate.update("insert INTO hello VALUES(1, 'gf', 'HelloWord')"); catch (DataAccessException ex) { // status.setrollbackonly(); transactionmanager.rollback(status); throw ex; finally { transactionmanager.commit(status); 1 Spring IoC Spring 5 sql sql sql <?xml version="1.0" encoding="utf-8"?> <!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN//EN" " <beans> <! datasource --> <bean id="datasource" class="org.springframework.jdbc.datasource.drivermanagerdatasource"> <! sqlserver --> <property name="driverclassname"> <value>com.microsoft.jdbc.sqlserver.sqlserverdriver</value>

26 <! Url --> <property name="url"> <value>jdbc:microsoft:sqlserver://localhost:1433/stdb</value> <! --> <property name="name"> <value>admin</value> <! --> <property name="msg"> <value>admin</value> </bean> <! transactionmanager --> <bean id="transactionmanager" class="org.springframework.jdbc.datasource.datasourcetransactionmanager"> <property name="datasource"> <ref bean="datasource"/> </bean> <! jdbctemplate --> <bean id="jdbctemplate" class="org.springframework.jdbc.core.jdbctemplate"> <property name="datasource"> <ref bean="datasource"/> </bean> <! DAO --> <bean id="hellodao" class="com.gc.action.hellodao"> <property name=" jdbctemplate "> <ref bean=" jdbctemplate "/> <property name="transactionmanager"> <ref bean="transactionmanager"/> <property name="sql"> <value> INSERT INTO hello VALUES(1, 'gf', 'HelloWord')</value> </bean> </beans> sql IoC HelloDAO 6 HelloDAO.java //******* HelloDAO.java************** package com.gc.action; import javax.sql.datasource; import org.springframework.jdbc.core.*; import org.springframework.transaction.*; import org.springframework.transaction.support.*; import org.springframework.dao.*;

27 import org.springframework.jdbc.core.jdbctemplate; public class HelloDAO { private JdbcTemplate jdbctemplate; private PlatformTransactionManager transactionmanager; private String sql; public void setjdbctemplate(jdbctemplate jdbctemplate) { this.jdbctemplate = jdbctemplate; public void settransactionmanager(platformtransactionmanager transactionmanager) { this.transactionmanager = transactionmanager; public void setsql(string sql) { this.sql = sql; // sql public int create(string msg) { DefaultTransactionDefinition def = new DefaultTransactionDefinition(); TransactionStatus status = transactionmanager.gettransaction(def); try { jdbctemplate.update(this.sql); catch (DataAccessException ex) { transactionmanager.rollback(status); // status.setrollbackonly(); throw ex; finally { transactionmanager.commit(status); 3 HelloDAO create Spring JdbcTemplate JdbcTemplate JdbcTemplate queryformap queryforlong queryforint queryforlist queryforlist List rows = jdbctemplate.queryforlist("select * from hello"); Iterator it = rows.iterator(); while(it.hasnext()) { Map map = (Map) it.next(); String id = map.get("id"); String name = map.get("name"); String msg = map.get("msg");

28 queryforint hello int count = jdbctemplate.queryforint("select count(*) from hello"); 2 JdbcTemplate JdbcTemplate JdbcTemplate update jdbctemplate.update("inset into hello values('1, gf', HelloWorld ')"); jdbctemplate.update("inset into hello values (?,?,?,)", new Object[] {1, gf, HelloWorld ); jdbctemplate.update("inset into hello values (?,?,?,)", new PreparedStatementSetter() { public void setvalues(preparedstatement ps) throws SQLException { ps.setint(1, 1); ps.setstring(2, gf ); ps.setstring(3, HelloWorld ); ); jdbctemplate.update("update hello set name = gd, msg = HelloWorld where id = 1"); jdbctemplate.update("update hello set name =?, msg =? where id =?", new Object[] { gf, HelloWorld,1); Object[] 7.4 ORM JdbcTemplate JdbcTemplate Spring ORM Spring Hibernate ibatis Spring Hibernate ibatis ORM

29 7.4.1 ORM ORM ORM Object-Relational Mapping ORM SQL SQL ORM Hibernate ibatis ORM ORM CRUD API API mapping metadata ORM dirty checking, lazy association fetching ORM ORM, ORM Hibernate Hibernate Hibernate Spring Hibernate Spring HelloDAO Hibernate Hello.hbm.xml Hello 1 Hibernate Spring <?xml version="1.0" encoding="utf-8"?> <!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN//EN" " <beans> <! datasource --> <bean id="datasource" class="org.springframework.jdbc.datasource.drivermanagerdatasource"> <! sqlserver --> <property name="driverclassname"> <value>com.microsoft.jdbc.sqlserver.sqlserverdriver</value> <! Url --> <property name="url"> <value>jdbc:microsoft:sqlserver://localhost:1433/stdb</value> <! --> <property name="name"> <value>admin</value> <! -->

30 <property name="msg"> <value>admin</value> </bean> <! Hibernate sessionfactory --> <bean class="org.springframework.orm.hibernate.localsessionfactorybean"> <property name="datasource"> <ref local="datasource" /> <property name="mappingresources"> <list> <value>com/gc/action/ Hello.hbm.xml</value> </list> <property name="hibernateproperties"> <props> <prop key="hibernate.dialect"> net.sf.hibernate.dialect.sqlserverdialect </prop> <prop key="hibernate.show_sql"> true </prop> </props> </bean> <! transactionmanager --> id="sessionfactory" <bean id="transactionmanager" class="org.springframework.jdbc.datasource.datasourcetransactionmanager"> <property name="sessionfactory"> <ref bean="sessionfactory"/> </bean> <! DAO --> <bean id="hellodao" class="com.gc.action.hellodao"> <property name="sessionfactory"> <ref bean="sessionfactory"/> <property name="transactionmanager"> <ref bean="transactionmanager"/> </bean> </beans> Hibernate SessionFactory Session Spring SessionFactory com/gc/action/ Hello.hbm.xml Hello.hbm.xml com.gc.action 2 Hello.hbm.xml com.gc.action Hello.hbm.xml <hibernate-mapping> <class name="com.gc.action.hello" table="hello" dynamic-update="false" dynamic-insert="false"> <id name="id" column="id" type="java.lang.integer"/>

31 <property name="name" type="java.lang.string" update="true" insert="true" access="property" <! msg--> column="msg" <! 50--> length="50"/> <property name="msg" type="java.lang.string" update="true" insert="true" access="property" <! name--> column="name" <! 50--> length="50" /> </class> </hibernate-mapping> 3 Hello com.gc.action Hello.java //******* Hello.java************** /** table="hello" */ public class Hello { public Integer id; public String name; public String msg; /** * column="id" * type="java.lang.integer" */ public Integer getid() { return id; public void setid(integer id) { this.id = id; /** column="msg" length="50" */ public String getmsg() { return msg; public void setmsg(string msg) { this.msg = msg; /** column="name" length="50"

32 */ public String getname() { return name; public void setname(string name) { this.name = name; 4 HelloDAO SessionFactory HelloDA //******* HelloDAO.java************** package com.gc.action; import javax.sql.datasource; import org.springframework.jdbc.core.*; import org.springframework.transaction.*; import org.springframework.transaction.support.*; import org.springframework.dao.*; import org.springframework.orm.*; public class HelloDAO { private SessionFactory sessionfactory; private PlatformTransactionManager transactionmanager; public void set SessionFactory (DataSource sessionfactory) { this. sessionfactory = sessionfactory; public void settransactionmanager(platformtransactionmanager transactionmanager) { this.transactionmanager = transactionmanager; // HibernateTemplate JdbcTemplate public int create(string msg) { DefaultTransactionDefinition def = new DefaultTransactionDefinition(); TransactionStatus status = transactionmanager.gettransaction(def); try { HibernateTemplate hibernatetemplate = new HibernateTemplate (sessionfactory); Hello hello = new Hello(); hello.setid(1); hello.setname( gf ); hello.setmsg( HelloWorld ); hibernatetemplate. saveorupdate (hello); catch (DataAccessException ex) { transactionmanager.rollback(status); // status.setrollbackonly(); throw ex; finally { transactionmanager.commit(status);

33 JdbcTemplate ibatis ibatis Hibernate ibatis Spring ibatis Spring HelloDAO ibatis sqlmapconfig.xml Hello.xml Hello 1 ibatis Spring <?xml version="1.0" encoding="utf-8"?> <!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN//EN" " <beans> <! datasource --> <bean id="datasource" class="org.springframework.jdbc.datasource.drivermanagerdatasource"> <! sqlserver --> <property name="driverclassname"> <value>com.microsoft.jdbc.sqlserver.sqlserverdriver</value> <! Url --> <property name="url"> <value>jdbc:microsoft:sqlserver://localhost:1433/stdb</value> <! --> <property name="name"> <value>admin</value> <! --> <property name="msg"> <value>admin</value> </bean> <! ibatis--> <bean id="sqlmap" class="org.springframework.orm.ibatis.sqlmapclientfactorybean"> <property name="configlocation"> <value>web-inf/sqlmapconfig.xml</value> </bean> <! transactionmanager --> <bean id="transactionmanager" class="org.springframework.jdbc.datasource.datasourcetransactionmanager"> <property name="datasource"> <ref bean="datasource"/> </bean> <! DAO --> <bean id="hellodao" class="com.gc.action.hellodao"> <property name="datasource">

34 <ref bean="datasource"/> <property name="transactionmanager"> <ref bean="transactionmanager"/> <property name="sqlmap"> <ref bean="sqlmap"/> </bean> </beans> sqlmapconfig.xml ibatis WEB-INF 2 sqlmapconfig.xml <sqlmapconfig> <sqlmap resource="com/gc/action/hello.xml"/> </sqlmapconfig> 3 Hello.xml com.gc.action Hello.xml <sqlmap namespace="hello"> <typealias alias="hello" type="com.gc.action.hello" /> <insert id="inserthello" parameterclass="hello"> insert into hello ( id,name, msg) values ( #id#,#name#,#msg# ) </insert> </sqlmap> 4 Hello Hibernate Hello.java //******* Hello.java************** public class Hello { public Integer id; public String name; public String msg; public Integer getid() { return id; public void setid(integer id) { this.id = id; public String getmsg() { return msg; public void setmsg(string msg) { this.msg = msg; public String getname() { return name; public void setname(string name) {

35 this.name = name; 5 HelloDAO HelloDAO.java //******* HelloDAO.java************** package com.gc.action; import javax.sql.datasource; import org.springframework.jdbc.core.*; import org.springframework.transaction.*; import org.springframework.transaction.support.*; import org.springframework.dao.*; import org.springframework.orm.*; public class HelloDAO extends SqlMapClientDaoSupport { private PlatformTransactionManager transactionmanager; public void settransactionmanager(platformtransactionmanager transactionmanager) { this.transactionmanager = transactionmanager; // getsqlmapclienttemplate JdbcTemplate public int create(string msg) { DefaultTransactionDefinition def = new DefaultTransactionDefinition(); TransactionStatus status = transactionmanager.gettransaction(def); try { Hello hello = new Hello(); hello.setid(1); hello.setname( gf ); hello.setmsg( HelloWorld ); getsqlmapclienttemplate().update("inserthello", hello); catch (DataAccessException ex) { transactionmanager.rollback(status); // status.setrollbackonly(); throw ex; finally { transactionmanager.commit(status); JdbcTemplate Hibernate 7.5 Spring Jdbc JdbcTemplate Spirng Hibernate ibatis Spring JdbcTemplate Spring Spring Web Spring Web

36 14 Spring 13 Spring Spring Spring Spring Spring Hibernate Spring Hibernate Spring MVC Struts Spring Hibernate Struts JDK Tomcat Spring Hibernate Ant JDK 2 JDK cmd cmd java JDK 14.1

37 14.1 java Tomcat 2 Tomcat IE Tomcat Tomcat

38 Ant cmd ant Ant Ant Ant Buildfile: build.xml does not exist! Build failed Build build.xml Build Ant 14.3 Eclipse mynews Eclipse mynews Spring Hibernate Eclipse 1 Eclipse File File 2 New Project Eclipse New Project Java Tomcat Project Next New Tomcat Project 14.5

39 14.4 New Project 14.5 New Tomcat Project 4 New Tomcat Project Project name mynews Finish mynews mynews 5 log4j jar commons-logging.jar spring.jar antlr.jar asm.jar spring-hibernate3.jar asm-attrs.jars cglib.jar commons-collections.jar dom4j.jar ehcache.jar jta.jar mysql-connector-java beta-bin.jar hibernate3.jar 14 jar /WEB-INF/lib/ mynews\web-inf\lib CLASSPATH 6 Windows log4j.properties log4j.properties mynews\web-inf\src 7 log4j.properties log4j.rootlogger=debug,stdout,r log4j.logger.org=error, A1 log4j.logger.com.gd =DEBUG,A2 log4j.appender.a1=org.apache.log4j.rollingfileappender log4j.appender.a1.file=org.log log4j.appender.a1.maxfilesize=500kb log4j.appender.a1.maxbackupindex=50 log4j.appender.a1.append=true log4j.appender.a1.layout=org.apache.log4j.patternlayout log4j.appender.a1.layout.conversionpattern=%d{iso [%p] [%C{1] - %m%n log4j.appender.a2=org.apache.log4j.rollingfileappender log4j.appender.a2.file=gc.log log4j.appender.a2.maxfilesize=500kb log4j.appender.a2.maxbackupindex=50 log4j.appender.a2.append=true log4j.appender.a2.layout=org.apache.log4j.patternlayout log4j.appender.a2.layout.conversionpattern=%d{iso [%p] [%C{1] - %m%n # stdout log4j.appender.stdout=org.apache.log4j.consoleappender log4j.appender.stdout.layout=org.apache.log4j.patternlayout # Pattern to output the caller's file name and line number. log4j.appender.stdout.layout.conversionpattern=[%-5p] %d{yyyy-mm-dd HH:mm:ss %c - %m%n # R #log4j.appender.r=org.apache.log4j.rollingfileappender log4j.appender.r=org.apache.log4j.dailyrollingfileappender #this log file will be stored in web server's /bin directory,modify to your path which want to store. log4j.appender.r.file=gf.log

40 #log4j.appender.r.datepattern='.'yyyy-mm-dd-hh-mm log4j.appender.r.datepattern='.'yyyy-mm-dd log4j.appender.r.append=true ## Keep one backup file log4j.appender.r.layout=org.apache.log4j.patternlayout log4j.appender.r.layout.conversionpattern=[%-5p] %d{yyyy-mm-dd HH:mm:ss %c - %m%n #[%-5p] %d{yyyy-mm-dd HH:mm:ss,SSS method:%l%n%m%n 8 mynews Eclipse 9 Properties for mynews Properties for mynews 10 Properties for mynews Java Build Path 11 Properties for mynews Libraries 12 Libraries Add JARs Selection JAR Selection 13 JAR Selection mynews lib 14 jar log4j jar commons-logging.jar spring.jar antlr.jar spring-hibernate3.jarasm.jar

41 asm-attrs.jars cglib.jar commons-collections.jar dom4j.jar ehcache.jar jta.jar mysql-connector-java beta-bin.jar hibernate3.jar 14 Ctrl 14 jar OK Properties for mynews Properties for mynews 15 Properties for mynews OK Spring Hibernate 16 mynews New Package Package New Java Package spring.jar Hibernate Hibernate spring-framework-2.0-m1\dist\extmodules\spring-hibernate3.jar ClassPath New Java Package 17 New Java Package Name com.gd.action Finish com.gd.action 18 com.gd.service com.gd.service.impl com.gd.dao com.gd.dao.impl com.gd.vo com.gd.po 19 WEB-INF jsp 20 Spring Hibernate mynews 14.11

42 14.11 Spring Hibernate mynews Ant build mynews ant build.xml <?xml version="1.0"?> <project name="mynews" default="init" basedir="."> <property name="mynews.home" value="." /> <property name="mynews.lib" value="${mynews.home/web-inf/lib" /> <property name="mynews.jar" value="${mynews.home/web-inf/lib" /> <property name="mynews.classes" value="${mynews.home/web-inf/classes" /> <property name="tomcat.home" value="d\:/jakarta-tomcat-5.5.5" /> <!--<property file="build.properties" /> build.properties --> <target name="init"> <path id="all"> <fileset dir="${mynews.lib"> <include name="**/*.jar" /> </fileset> /* jar*/ <fileset dir="${tomcat.home/common/lib"> <include name="*.jar" /> </fileset> </path> <mkdir dir="${mynews.classes" /> </target> <target name="clean"> <delete dir="${mynews.classes"> </delete> </target> <target name="compile" depends="init"> /* */ <javac srcdir="${mynews.home/web-inf/src" destdir="${mynews.classes" target="1.5"> <classpath refid="all" /> </javac> </target> <target name="jar" depends="compile"> /* jar */ <jar jarfile="${mynews.jar/gd.jar" basedir="${mynews.classes" includes="com/gd/**">

43 </jar> </target> <!-- mynews war --> <target name="war" depends="jar"> <war destfile="${mynews.home/mynews.war" webxml="${mynews.home/web-inf/web.xml"> <fileset dir="${mynews.home" casesensitive="yes"> <include name="web-inf/**" /> <exclude name="*.war" /> </fileset> <lib dir="${mynews.home/web-inf/lib"> <include name="*.jar" /> </lib> </war> </target> </project> Web.xml web.xml mynews \WEB-INF web.xml <?xml version="1.0" encoding="utf-8"?> <!DOCTYPE web-app PUBLIC "-//Sun Microsystems, Inc.//DTD Web Application 2.2//EN" " <web-app> <servlet> <servlet-name>dispatcherservlet</servlet-name> <servlet-class>org.springframework.web.servlet.dispatcherservlet</servlet-class> <init-param> <param-name>contextconfiglocation</param-name> <param-value>/web-inf/conf/dispatcherservlet-servlet.xml</param-value> </init-param> <load-on-startup>1</load-on-startup> </servlet> <servlet-mapping> <servlet-name>dispatcherservlet </servlet-name> <url-pattern>*.do</url-pattern> </servlet-mapping> <taglib> <taglib-uri>/spring</taglib-uri> <taglib-location>/web-inf/tld/spring.tld</taglib-location> </taglib> </web-app> /WEB-INF/conf/dispatcherServlet-servlet.xml conf /WEB-INF/conf/ /WEB-INF/tld/spring.tld tld

44 /WEB-INF/tld/ show.html release.html regedit.html login.html error.html 1 show.html show.html <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" " <html> <head> <meta http-equiv="content-type" content="text/html; charset=gb2312"> <title> </title> <style type="text/css"> <!--.style1 {font-family: " " -->

45 </style> </head> <body> <table width="100%" height="100%" border="1" cellpadding="0" cellspacing="0" > <tr height="100%"> <td height="20"><strong> </strong></td> <td><strong> </strong></td> <tr height="100%"> <td height="150"><ol> <li> </li> <li> </li> <li> </li> <li> </li> <li> </li> </ol></td> <td><ol> <li> </li> <li> </li> <li> </li> <li> </li> <li> </li> </ol></td> <tr height="100%" style=" border-top-width:0"> <td height="15" style=" border-top-width:0"><div align="right" class="style1" > </div></td> <td style=" border-top-width:0"><div align="right" class="style1" > </div></td> <tr height="100%"> <td height="20"><strong> </strong></td> <td><strong> </strong></td> <tr height="100%"> <td height="150"><ol> <li> </li> <li> </li> <li> </li> <li> </li> <li> </li> </ol></td> <td><ol> <li> </li> <li> </li> <li> </li> <li>2006 </li> <li> 2005 </li> </ol></td> <tr height="100%"> <td height="15" style=" border-top-width:0"><div align="right" class="style1" > </div></td>

46 <td style=" border-top-width:0"><div align="right" class="style1" > </div></td> </table> </body> </html> 2 release.html release.html <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" " <html> <head> <meta http-equiv="content-type" content="text/html; charset=gb2312"> <title> </title> <style type="text/css"> <!--.style1 { font-size: large; font-weight: bold; --> </style> </head> <body> <form name="form1" method="post" action=""> <table width="100%" height="160" border="1" cellpadding="0" cellspacing="0"> <tr> <td height="17" colspan="2"><div align="center" class="style1"> </div></td>

47 <tr> <td width="126" height="19"><strong> </strong></td> <td width="560"> </td> <tr> <td height="73"><strong> </strong></td> <td><p><strong>1</strong><strong> </strong></p> <p align="left">1.1 </p> <p>1.2 </p> <p>1.3 </p> <p><strong>2</strong><strong> </strong></p> <p>2.1 </p> <p>2.2 <p>2.3 <strong> </strong></p> <p><strong>3</strong><strong> </strong></p> <p>3.1 </p> <p> </p> </td> <tr> <td height="19" colspan="2"><strong> </strong> <strong> </strong> gd <strong> </strong> <select name="select"> <option> </option> <option selected> </option> <option> </option> <option> </option> </select></td> <tr> <td height="18"> </td> <td><input type="submit" name="submit" value=" "> <input type="submit" name="submit" value=" "> <input type="submit" name="submit" value=" "></td> </table> </form> </body> </html> 3 regedit.html 14.14

48 14.14 regedit.html <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" " <html> <head> <meta http-equiv="content-type" content="text/html; charset=gb2312"> <title> </title> </head> <body> <form name="form1" method="post" action=""> <table width="100%" height="251" border="1" cellpadding="0" cellspacing="0"> <tr> <td height="17" colspan="2"><div align="center"><strong> </strong></div></td> <tr> <td width="18%"><strong> </strong></td> <td width="82%"><input type="text" name="textfield"></td> <tr> <td><strong> </strong></td> <td><input type="password" name="textfield"></td> <tr> <td><strong> </strong></td> <td><input type="password" name="textfield"></td> <tr> <td colspan="2"><div align="center"> <input type="submit" name="submit" value=" "> <input type="reset" name="submit" value=" "> </div></td> </table>

49 </form> </body> </html> 4 login.html login.html <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" " <html> <head> <meta http-equiv="content-type" content="text/html; charset=gb2312"> <title> </title> </head> <body> <form name="form1" method="post" action=""> <table width="100%" border="1" cellpadding="0" cellspacing="0"> <tr> <td colspan="2"><div align="center"><strong> </strong></div></td> <tr> <td height="41"><strong> </strong></td> <td><input type="text" name="textfield"></td> <tr> <td height="40"><strong> </strong></td> <td><input type="password" name="textfield"></td> <tr> <td height="49"><strong> </strong></td> <td><input type="password" name="textfield"></td> <tr>

50 <td height="83" colspan="2"><div align="center"> <input type="submit" name="submit" value=" "> <input type="reset" name="submit" value=" "> </div></td> </table> </form> </body> </html> 5 error.html error.html <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" " <html> <head> <meta http-equiv="content-type" content="text/html; charset=gb2312"> <title> </title> <style type="text/css"> <!--.style1 { color: #000000; font-weight: bold;.style2 {color: #FF > </style> </head> <body> <table width="100%" border="1"> <tr> <td colspan="2"><div align="center"><strong> </strong></div></td> <tr>

51 <td width="22%" height="141"><span class="style1"> </span></td> <td width="78%"><span class="style2">sql SQL </span></td> </table> </body> </html> User.java UsersAuthor.java News.java NewsType.java Together UML Together User.java UML 14.18

52 14.18 UML Together //******* User.java************** package com.gd.vo; public class User { public String getmsg(){ return msg; public void setmsg(string msg){ this.msg = msg; public String getpassword2(){ return password2; public void setpassword2(string password2){ this.password2 = password2; public String getpassword1(){ return password1; public void setpassword1(string password1){ this.password1 = password1; public String getusername(){ return username; public void setusername(string username){ this.username = username; public boolean validate() { private String msg; private String password2; private String password1; private String username; msg password1 password2 username 2 UsersAuthor.java UML 14.19

53 14.19 UML UsersAuthor User Together //******* UsersAuthor.java************** package com.gd.vo; public class UsersAuthor { public void setusersauthor(user lnkuser, int power) { lnkuser = lnkuser; power = power; public int getauthorbyuser(user lnkuser) { return power; public UsersAuthor(User lnkuser, int power) { lnkuser = lnkuser; power = power; private int power; /** 1 0.n */ private User lnkuser; power 0 power 1

54 3 NewsType.java UML UML Together //******* NewsType.java************** package com.gd.vo; public class NewsType { public int getid(){ return id; public void setid(int id){ this.id = id; public String gettypename(){ return typename; public void settypename(string typename){ this.typename = typename; public String gettypebyid (int id) { return typename; private int id; private String typename; 4 News.java UML 14.22

55 14.22 UML News User Together //******* News.java************** package com.gd.vo; public class News { public int getid(){

56 return id; public void setid(int id){ this.id = id; public String getmsg(){ return msg; public void setmsg(string msg){ this.msg = msg; public String gethead(){ return head; public void sethead(string head){ this.head = head; public String getcontent(){ return content; public void setcontent(string content){ this.content = content; public Date getdate(){ return date; public void setdate(date date){ this.date = date; // id public List getnewsbytype(int id) { // public void savenews(new new) { private int id; private String msg; private String head; private String content; private Date date; /** n 1 */ private NewsType lnknewstype; /** n 1 */ private User lnkuser;

57 user username password username 2 userauthor username power username power 3 newstype id type 4 news id head content issuedate issueuser newstype id id UML UML UML

58 14.5 Jsp jsp show.jsp WEB-INF/jsp Map id show.jsp contenttype="text/html;charset=gbk"%> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" " import="java.util.*,com.gd.util.*,com.gd.vo.*,com.gd.po.newstype,com.gd.po.new"%> <html> <head> <meta http-equiv="content-type" content="text/html; charset=gb2312"> <title> </title> <style type="text/css"> <!--.style1 {font-family: " " --> </style> </head> <% List listnewstype = (List)request.getAttribute("listNewsType"); Map mapnews = (Map)request.getAttribute("mapNews"); %> <body> <table width="100%" height="100%" border="1" cellpadding="0" cellspacing="0" > <% for (int i = 0; listnewstype!= null && i < listnewstype.size(); i++) { %> <tr height="100%"> <td height="20"><strong><%=((newstype)listnewstype.get(i)).gettype()%></strong></td> <td><strong><%=((newstype)listnewstype.get(i + 1)).getType()%></strong></td> <tr height="100%"> <td height="150"><ol> <% List newsheads = (List)mapNews.get((((Newstype)listNewsType.get(i)).getId())); for (int j = 0; newsheads!= null && j < newsheads.size(); j++) { %> <li><%=((new)newsheads.get(j)).getcontent() %></li> <%%> </ol></td> <td><ol>

59 <% newsheads = (List)mapNews.get((((Newstype)listNewsType.get(++i)).getId())); for (int j = 0; newsheads!= null && j < newsheads.size(); j++) { %> <li><%=((new)newsheads.get(j)).getcontent() %></li> <%%> </ol></td> <tr height="100%" style=" border-top-width:1"> <td height="15" style=" border-top-width:1"><div align="right" class="style1" > </div></td> <td style=" border-top-width:1"><div align="right" class="style1" > </div></td> <%%> </table> </body> </html> Map mapnews = (Map)request.getAttribute("mapNews") release.jsp WEB-INF/jsp NewsUtil.java release.jsp <%@page contenttype="text/html;charset=gbk"%> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" " <%@page import="java.util.list,com.gd.util.*,com.gd.vo.user,com.gd.po.newstype"%> <html> <head> <meta http-equiv="content-type" content="text/html; charset=gb2312"> <title> </title> <style type="text/css"> <!--.style1 { font-size: large; font-weight: bold; --> </style> </head> <% List newstypes = (List)request.getAttribute("newsTypes"); User user = (User)request.getAttribute("user"); %> <body> <form name="form1" method="post" action="/mynews/release.do">

60 <table width="100%" height="160" border="1" cellpadding="0" cellspacing="0"> <tr> <td height="17" colspan="2"><div align="center" class="style1"> </div></td> <tr> <td width="126" height="19"><strong> </strong></td> <td width="560"><input name="head" type="text" size="100%"></td> <tr> <td height="73"><strong> </strong></td> <td><p> <textarea name="content" cols="100%" rows="30"></textarea> </p> </td> <tr> <td height="19" colspan="2"><strong> </strong><%=newsutil.getcurrentdate()%><strong> </strong> <%=user.getusername()%> <strong> </strong> <select name="newstype"> <% for (int i = 0; newstypes!= null && i < newstypes.size(); i++) { Newstype newstype = (Newstype)newsTypes.get(i); %> <option value = '<%=newstype.getid()%>'><%=newstype.gettype()%></option> <%%> </select></td> <tr> <td height="18"> </td> <td><input type="submit" name="insert" value=" "> <input type="submit" name="update" value=" "> <input type="submit" name="delete" value=" "></td> </table> </form> </body> </html> NewsUtil.getCurrentDate() NewsUtil mynews com.gd.util regedit.jsp WEB-INF/jsp <%@page contenttype="text/html;charset=gbk"%> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" " <html>

61 <head> <meta http-equiv="content-type" content="text/html; charset=gb2312"> <title> </title> </head> <body> <form name="form1" method="post" action="/mynews/regedit.do"> <table width="100%" height="251" border="1" cellpadding="0" cellspacing="0"> <tr> <td height="17" colspan="2"><div align="center"><strong> </strong></div></td> <tr> <td width="18%"><strong> </strong></td> <td width="82%"><input type="text" name="username"></td> <tr> <td><strong> </strong></td> <td><input type="password" name="password1"></td> <tr> <td><strong> </strong></td> <td><input type="password" name="password2"></td> <tr> <td colspan="2"><div align="center"> <input type="submit" name="submit" value=" "> <input type="reset" name="submit" value=" "> </div></td> </table> </form> </body> </html> login.jsp WEB-INF/jsp login.jsp contenttype="text/html;charset=gbk"%> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" " <html> <head> <meta http-equiv="content-type" content="text/html; charset=gb2312"> <title> </title> </head> <body> <form name="form1" method="post" action="/mynews/login.do"> <table width="100%" height="251" border="1" cellpadding="0" cellspacing="0">

62 <tr> <td height="17" colspan="2"><div align="center"><strong> </strong></div></td> <tr> <td width="18%"><strong> </strong></td> <td width="82%"><input type="text" name="username"></td> <tr> <td><strong> </strong></td> <td><input type="password" name="password1"></td> <tr> <td><strong> </strong></td> <td><input type="password" name="password2"></td> <tr> <td colspan="2"><div align="center"> <input type="submit" name="submit" value=" "> <input type="reset" name="submit" value=" "> </div></td> </table> </form> </body> </html> error.jsp WEB-INF/jsp Exception error.jsp contenttype="text/html;charset=gbk"%> <html> <head> <meta http-equiv="content-type" content="text/html; charset=gb2312"> <title> </title> <style type="text/css"> <!--.style1 { color: #000000; font-weight: bold;.style2 {color: #FF > </style> </head> <% Exception ex = (Exception)request.getAttribute("Exception"); %> <body> <table width="100%" border="1"> <tr>

63 <td colspan="2"><div align="center"><strong> </strong></div></td> <tr> <td width="22%" height="141"><span class="style1"> </span></td> <td width="78%"><span class="style2"><%=ex.getmessage();%></span></td> </table> </body> </html> Sprng <bean id="exceptionresolver" class="org.springframework.web.servlet.handler.simplemappingexceptionresolver"> <property name="exceptionmappings"> <props> <prop key="java.sql.sqlexception">error</prop> <prop key="java.sql.ioexception">error</prop> </props> </bean> SQLException IOException /WEB-INF/jsp/ error.jsp 14.6 xml POJO Xampp mysql xampp 2 Xampp phpmyadmin 14.26

64 mynews mynews user 3 user user 2 user user 14.28

65 14.28 user 3 username password varchar 32 username user sql CREATE TABLE `user` ( `username` VARCHAR( 32 ) NOT NULL, `password` VARCHAR( 32 ) NOT NULL, PRIMARY KEY ( `username` ) ) ENGINE = MYISAM ; 4 user user

66 news 6 news news 2 news news news 3 id head content issuedate issueuser newstype id int

67 4 head varchar 200 content varchar 8000 issuedate Date issueuser varchar 32 newstype int 4 id news sql CREATE TABLE `news` ( `id` INT( 4 ) NOT NULL, `head` VARCHAR( 200 ) NOT NULL, `content` VARCHAR( 8000 ) NOT NULL, `issuedate` DATE NOT NULL, `issueuser` VARCHAR( 32 ) NOT NULL, `newstype` INT( 4 ) NOT NULL, PRIMARY KEY ( `id` ) ) ENGINE = MYISAM ; 4 news news userauthor username power username power 3 newstype id type 4 news id head content issuedate issueuser newstype id 1 newstype 2 newstype

68 newstype 2 newstype newstype newstype 3 id type id int 4 type varchar 32 id newstype sql CREATE TABLE `newstype` ( `id` INT( 4 ) NOT NULL, `type` VARCHAR( 32 ) NOT NULL, PRIMARY KEY ( `id` ) ) ENGINE = MYISAM ; 4 newstype 14.35

69 14.35 newstype