Spring_SSH整合之_架构的历史(四层架构整合JSP+MySQL+JavaBean+Hibernate)_3

<?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">

<!-- This mapping demonstrates how to use an "inverse" join to map an association 
	table as an association with one-to-many multiplicity at the level of the 
	object model. -->

<hibernate-mapping package="com.bjsxt.registration.model">
	<class name="User" table="user">
		<id name="id" type="integer" column="id">
			<generator class="native" />
		</id>
		<property name="username" type="string" column="username"/>
		<property name="password" type="string" column="password"/>
	</class>

</hibernate-mapping>

<!DOCTYPE hibernate-configuration PUBLIC
	"-//Hibernate/Hibernate Configuration DTD 3.0//EN"
	"http://www.hibernate.org/dtd/hibernate-configuration-3.0.dtd">

<hibernate-configuration>
	<session-factory name="foo">
		<!-- 数据库连接：方言、驱动、连接、用户名、密码 -->
		<property name="dialect">org.hibernate.dialect.MySQLDialect</property>
		<property name="connection.driver_class">com.mysql.jdbc.Driver</property>
		<property name="connection.url">jdbc:mysql://localhost:3306/spring</property>
		<property name="connection.username">root</property>
		<property name="connection.password">root</property>

		<!-- 显示SQL语句 -->
		<property name="show_sql">true</property>
		<!-- 自动构建表结构 -->
		<!-- <property name="hbm2ddl.auto">update</property> -->

		<!-- 映射配置 -->
		<mapping resource="com/bjsxt/registration/model/User.hbm.xml" />
	</session-factory>
</hibernate-configuration>

package com.bjsxt.registration.util;

import org.hibernate.SessionFactory;
import org.hibernate.cfg.Configuration;

public class HibernateUtil {
	private static SessionFactory sessionFactory;
	static {
		sessionFactory = new Configuration().configure().buildSessionFactory();
	}

	public static SessionFactory getSessionFactory() {
		return sessionFactory;
	}
}

package com.bjsxt.registration.service;

import org.hibernate.Session;
import org.hibernate.Transaction;
import com.bjsxt.registration.model.User;
import com.bjsxt.registration.util.HibernateUtil;

public class UserManager {

	public boolean exists(User u) {
		Session session = HibernateUtil.getSessionFactory().openSession();
		Transaction tx = session.beginTransaction();

		Long count = (Long) session.createQuery(//
				"select count(u) from User u where username=:name")//
				.setParameter("name", u.getUsername())//
				.uniqueResult();
		tx.commit();
		session.close();
		if (count > 0) {
			return true;
		}
		return false;
	}

	public void add(User u) {
		Session session = HibernateUtil.getSessionFactory().openSession();
		Transaction tx = session.beginTransaction();

		session.save(u);

		tx.commit();
		session.close();
	}
}

Test

package com.bjsxt.registration.service;

import org.junit.Assert;
import org.junit.Test;

import com.bjsxt.registration.model.User;

public class UserManagerTest {
	private UserManager um = new UserManager();

	@Test
	public void testExists() {
		User u = new User();
		u.setUsername("a");
		boolean exists = um.exists(u);
		Assert.assertEquals(true, exists);
	}

	@Test
	public void testAdd() {
		User u = new User();
		u.setUsername("e");
		u.setpassword("a");
		boolean exists = um.exists(u);
		if (!exists) {
			um.add(u);
			u.setUsername(u.getUsername());
			Assert.assertEquals(true,um.exists(u));
		} else {
			Assert.fail("not added");
		}
	}

}

package com.bjsxt.registration.model;

//贫血模型 充血模型
public class User {
	private Integer id;
	private String username;
	private String password;

	public Integer getId() {
		return id;
	}

	public void setId(Integer id) {
		this.id = id;
	}

	public String getUsername() {
		return username;
	}

	public void setUsername(String username) {
		this.username = username;
	}

	public String getpassword() {
		return password;
	}

	public void setpassword(String password) {
		this.password = password;
	}

}package com.bjsxt.registration.service;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;

import com.bjsxt.registration.model.User;

public class UserManager {
	public boolean exists(User u) throws Exception {
		Class.forName("com.mysql.jdbc.Driver");
		Connection conn = DriverManager.getConnection(
				"jdbc:mysql://localhost:3306/spring", "root", "root");

		String sqlQuery = "select count(*) from user where username = ?";
		PreparedStatement psQuery = conn.prepareStatement(sqlQuery);
		psQuery.setString(1, u.getUsername());
		ResultSet rs = psQuery.executeQuery();
		rs.next();
		int count = rs.getInt(1);
		psQuery.close();
		conn.close();
		if (count > 0) {
			return true;
		}
		return false;
	}

	public void add(User u) throws Exception {
		Class.forName("com.mysql.jdbc.Driver");
		Connection conn = DriverManager.getConnection(
				"jdbc:mysql://localhost:3306/spring", "root", "root");

		String sql = "insert into user values (null, ?, ?)";
		PreparedStatement ps = conn.prepareStatement(sql);
		ps.setString(1, u.getUsername());
		ps.setString(2, u.getpassword());
		ps.executeUpdate();
		ps.close();
		conn.close();
	}
}
<%@ page language="java" import="java.util.*" pageEncoding="GB18030"%>








   
   

   
   

   
   




	
用户注册

	
   
   

    
    
		用户名：
    
    
    
    

		密码：
    
    
    
    

		确认密码：
    
    
    
    

		
    
    
	
   
   


<%@ page language="java" import="java.util.*, java.sql.*"
	pageEncoding="GB18030"%>
<%@ page import="com.bjsxt.registration.model.User"%>
<%@ page import="com.bjsxt.registration.service.UserManager"%>
<%
	String path = request.getContextPath();
	String basePath = request.getScheme() + "://"
			+ request.getServerName() + ":" + request.getServerPort()
			+ path + "/";
	String username = request.getParameter("username");
	String password = request.getParameter("password");
	String password2 = request.getParameter("password2");

	User u = new User();
	u.setUsername(username);
	u.setpassword(password);

	UserManager um = new UserManager();
	boolean exits = um.exists(u);
	if (exits) {
		response.sendRedirect("registFail.jsp");
		return;
	}

	um.add(u);
	response.sendRedirect("registSuccess.jsp");
%><%@ page language="java" import="java.util.*" pageEncoding="GB18030"%>








   
   

   
   

   
   




	
Fail!


<%@ page language="java" import="java.util.*" pageEncoding="GB18030"%>








   
   

   
   

   
   




	
Success!