以前一直接触.net相关的web开发,现在猛然使用javaWeb还是很不习惯,就连搭个框架也是第一次。
一、谈谈项目架构
一开始接触.net相关的开发所以对于.net相关的开发还是比较熟悉的,但我在学校学的java方向的开发,而我打算把这两种平台结合起来,使用java做后台也就是服务提供者,将所有业务逻辑在java平台完成并使用我比较熟悉的.net做Web端的开发。这样一来安卓app,web端就都有了。客户端统一通过分布式框架调用服务。找了很久最终选择了Hprose,这一轻量级、跨语言、跨平台、无侵入式、高性能动态远程对象调用引擎库。之所以选择它一方面是因为学习成本低,另一方面是它的跨平台调用非常轻松高效,因为我们要使用.net做web需要调用java发布的服务!大概看了一下Hprose的文档,发现使用内置的HproseServlet发布服务开发速度比较快也比较简单,所以准备使用这种方式发布服务。可问题来了,传统的ssh架构感觉有点重了,准备使用.net开发web端所以感觉没有必要整合Struts,于是就是hibernate+spring+hprose这种架构。
二、数据库设计
一个小网上书城,所以设计的还有欠缺,以实用为主,主要是练手java开发~~。所以使用了navicat简单设计了一下,不过没有设计表关联,取而代之的是后来一个一个添加关系的,发现这个设计工具有点问题,图示:
其实表关联一看就能看出来~~,接下来就是hibernate一些映射了,同样也是使用插件生成model和映射文件
稍作修改就是这样--
三、spring3+hibernate4配置
因为model和映射文件是自动生成所以稍加配置就好,需要注意的是复合主键的设置,自动生成的会把复合主键对应一个复合模型。如商品评论表的复合主键类型:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
|
package com.book.model;
// Generated 2015-11-2 9:07:06 by Hibernate Tools 4.0.0.Final
import java.util.Date;
/**
* CommentsId generated by hbm2java
*/
public class CommentsPk implements java.io.Serializable {
private Book book;
private User user;
private Date commentsDate;
public CommentsPk() {
}
public CommentsPk(Book book, User user, Date commentsDate) {
this .book = book;
this .user = user;
this .commentsDate = commentsDate;
}
public Book getBook() {
return this .book;
}
public void setBook(Book book) {
this .book = book;
}
public User getUser() {
return this .user;
}
public void setUser(User user) {
this .user = user;
}
public Date getCommentsDate() {
return this .commentsDate;
}
public void setCommentsDate(Date commentsDate) {
this .commentsDate = commentsDate;
}
public boolean equals(Object other) {
if (( this == other))
return true ;
if ((other == null ))
return false ;
if (!(other instanceof CommentsPk))
return false ;
CommentsPk castOther = (CommentsPk) other;
return (( this .getBook() == castOther.getBook()) || ( this .getBook() != null && castOther.getBook() != null
&& this .getBook().equals(castOther.getBook())))
&& (( this .getUser() == castOther.getUser()) || ( this .getUser() != null && castOther.getUser() != null
&& this .getUser().equals(castOther.getUser())))
&& (( this .getCommentsDate() == castOther.getCommentsDate())
|| ( this .getCommentsDate() != null && castOther.getCommentsDate() != null
&& this .getCommentsDate().equals(castOther.getCommentsDate())));
}
public int hashCode() {
int result = 17 ;
result = 37 * result + (getBook() == null ? 0 : this .getBook().hashCode());
result = 37 * result + (getUser() == null ? 0 : this .getUser().hashCode());
result = 37 * result + (getCommentsDate() == null ? 0 : this .getCommentsDate().hashCode());
return result;
}
}
|
商品评论表模型:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
|
package com.book.model;
// Generated 2015-10-30 14:56:21 by Hibernate Tools 4.0.0.Final
import java.sql.Date;
/**
* Comments generated by hbm2java
*/
public class Comments implements java.io.Serializable {
private String content;
private String pic;
private Integer client;
private CommentsPk id;
public Comments()
{
}
public String getContent() {
return content;
}
public void setContent(String content) {
this .content = content;
}
public String getPic() {
return pic;
}
public void setPic(String pic) {
this .pic = pic;
}
public Integer getClient() {
return client;
}
public void setClient(Integer client) {
this .client = client;
}
public CommentsPk getId() {
return id;
}
public void setId(CommentsPk id) {
this .id = id;
}
public Comments(String content, String pic, Integer client, CommentsPk id) {
super ();
this .content = content;
this .pic = pic;
this .client = client;
this .id = id;
}
}
|
相应的Hibernate 映射文件:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
|
<? xml version = "1.0" ?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://www.hibernate.org/dtd/hibernate-mapping-3.0.dtd">
<!-- Generated 2015-10-30 14:56:21 by Hibernate Tools 4.0.0.Final -->
< hibernate-mapping >
< class name = "com.book.model.Comments" table = "comments" catalog = "bookstore" >
< composite-id name = "id" class = "com.book.model.CommentsPk" >
< key-many-to-one name = "book" class = "com.book.model.Book" >
< column name = "BookID" />
</ key-many-to-one >
< key-many-to-one name = "user" class = "com.book.model.User" >
< column name = "UserID" />
</ key-many-to-one >
< key-property name = "commentsDate" type = "timestamp" >
< column name = "CommentsDate" length = "19" />
</ key-property >
</ composite-id >
< property name = "content" type = "string" >
< column name = "Content" length = "65535" />
</ property >
< property name = "pic" type = "string" >
< column name = "Pic" length = "65535" />
</ property >
< property name = "client" type = "java.lang.Integer" >
< column name = "Client" />
</ property >
</ class >
</ hibernate-mapping >
|
因为商品评论表有两个是外键所以使用了key-many-to-one标签。
由于采用spring3.2+hibernate4.1所以得到sessionFactory的方式只限于sessionFactory.getCurrentSession();但是必须开启事物:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
|
<bean id= "transactionManager"
class = "org.springframework.orm.hibernate4.HibernateTransactionManager" >
<property name= "sessionFactory" ref= "sessionFactory" />
</bean>
<!-- 事务的传播特性 -->
<tx:advice id= "txadvice" transaction-manager= "transactionManager" >
<tx:attributes>
<tx:method name= "add*" propagation= "REQUIRED" />
<tx:method name= "delete*" propagation= "REQUIRED" />
<tx:method name= "modify*" propagation= "REQUIRED" />
<!--hibernate4必须配置为开启事务 否则 getCurrentSession()获取不到-->
<tx:method name= "*" propagation= "REQUIRED" read-only= "true" />
</tx:attributes>
</tx:advice>
|
以上都是我配置的时候出现问题的地方。下面是spring配置文件:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
|
<?xml version= "1.0" encoding= "UTF-8" ?>
<beans xmlns= "http://www.springframework.org/schema/beans"
xmlns:xsi= "http://www.w3.org/2001/XMLSchema-instance" xmlns:aop= "http://www.springframework.org/schema/aop"
xmlns:context= "http://www.springframework.org/schema/context" xmlns:tx= "http://www.springframework.org/schema/tx"
xsi:schemaLocation="http: //www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.2.xsd
http: //www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-3.2.xsd
http: //www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-3.2.xsd
http: //www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-3.2.xsd">
<!-- 启用spring注解支持 -->
<context:annotation-config />
<bean id= "dataSource" class = "org.apache.commons.dbcp.BasicDataSource" destroy-method= "close" >
<property name= "driverClassName" value= "com.mysql.jdbc.Driver" />
<property name= "url"
value= "jdbc:mysql://127.0.0.1/bookstore?useUnicode=true&characterEncoding=UTF-8" />
<property name= "username" value= "root" />
<property name= "password" value= "yangyang" />
</bean>
<!-- 可追加配置二级缓存 -->
<bean id= "sessionFactory" class = "org.springframework.orm.hibernate4.LocalSessionFactoryBean" >
<property name= "dataSource" ref= "dataSource" />
<property name= "mappingDirectoryLocations" >
<list>
<value>classpath:config</value>
</list>
</property>
<property name= "hibernateProperties" >
<props>
<prop key= "hibernate.dialect" >org.hibernate.dialect.MySQLDialect</prop>
<prop key= "hibernate.show_sql" > true </prop>
<prop key= "hibernate.hbm2ddl.auto" >update</prop>
<prop key= "hibernate.temp.use_jdbc_metadata_defaults" > false </prop>
<prop key= "current_session_context_class" >thread</prop>
</props>
</property>
</bean>
<!-- 配置事务管理器 -->
<bean id= "transactionManager"
class = "org.springframework.orm.hibernate4.HibernateTransactionManager" >
<property name= "sessionFactory" ref= "sessionFactory" />
</bean>
<!-- 事务的传播特性 -->
<tx:advice id= "txadvice" transaction-manager= "transactionManager" >
<tx:attributes>
<tx:method name= "add*" propagation= "REQUIRED" />
<tx:method name= "delete*" propagation= "REQUIRED" />
<tx:method name= "modify*" propagation= "REQUIRED" />
<!--hibernate4必须配置为开启事务 否则 getCurrentSession()获取不到-->
<tx:method name= "*" propagation= "REQUIRED" read-only= "true" />
</tx:attributes>
</tx:advice>
<!-- 那些类那些方法使用事务 -->
<aop:config>
<!-- 只对业务逻辑层实施事务 -->
<aop:pointcut id= "allManagerMethod"
expression= "execution(* com.book.test.*.*(..))" />
<aop:advisor pointcut-ref= "allManagerMethod" advice-ref= "txadvice" />
</aop:config>
<bean name= "basedao" class = "com.book.dao.impl.AdressDao" />
<bean name= "orderdao" class = "com.book.dao.impl.OrderDao" />
</beans>
|
一切就绪之后我们使用servlet测试:
1
2
3
4
5
6
7
8
|
<servlet>
<servlet-name>test</servlet-name>
<servlet- class >com.book.test.Test</servlet- class >
</servlet>
<servlet-mapping>
<servlet-name>test</servlet-name>
<url-pattern>/index</url-pattern>
</servlet-mapping>
|
1
2
3
4
5
6
7
8
|
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
// TODO Auto-generated method stub
BeanFactory factor = WebApplicationContextUtils.getRequiredWebApplicationContext(request.getSession().getServletContext());
OrderDao dao= factor.getBean(OrderDao. class );
Object[] list= dao.get( 1 ).getOrderitems().toArray();
System.out.println(((Orderitem)list[ 0 ]).getOrdercount());
}
|
因为没有使用structs我们需要自己查找spring的BeanFactory来获得dao bean 这也是需要注意的地方,纠结好久。
运行结果:
成功加载订单表订单1项目订购数量。
毕竟第一次使用java开发这类项目,慢慢学习吧,希望大家可以喜欢JavaWeb搭建的网上图书商城框架,对大家的学习有所帮助。