基于springMVC和hibernate实现的简单登陆

1使用的工具

①myeclipse

②mysql

2需要的jar包 

因为我们使用了myeclipse，大部分的jar不需要我们下载，直接使用就可以了，此外我们只需要引入mysql驱动jar，自行百度。

3创建工程

3.1 创建web project 

3.2 在这个项目下右键选择MyEclipse-->add spring ...

需要选择五个包（稍后截图）

3.3继续右键选择MyEclipse-->add hibernate..

配置的截图稍后上传

4配置web.xml

 <servlet>
  <servlet-name>dispatcher</servlet-name>
  <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
  <init-param>
   <param-name>contextConfigLocation</param-name>
   <param-value>/WEB-INF/applicationContext.xml</param-value>
  </init-param>
 </servlet>
 <servlet-mapping>
  <servlet-name>dispatcher</servlet-name>
  <url-pattern>*.do</url-pattern>
 </servlet-mapping>

5配置applicationContext.xml

<?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:p="http://www.springframework.org/schema/p"
	xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.0.xsd">


	<bean id="dataSource"
		class="org.apache.commons.dbcp.BasicDataSource">
		<property name="driverClassName"
			value="com.mysql.jdbc.Driver">
		</property>
		<property name="url" value="jdbc:mysql://localhost:3306/test"></property>
		<property name="username" value="yaosai"></property>
	</bean>
	<bean id="sessionFactory"
		class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
		<property name="dataSource">
			<ref bean="dataSource" />
		</property>
		<property name="hibernateProperties">
			<props>
				<prop key="hibernate.dialect">
					org.hibernate.dialect.MySQLDialect
				</prop>
				<prop key="hibernate.hbm2ddl.auto">update</prop>
			</props>
			
		</property>
		<property name="mappingResources">
		<list>
		 <value>/yaosai/ccut/po/user.hbm.xml</value>
		</list>
		</property>
	</bean>
	<bean id="logindao" class="yaosai.ccut.dao.LoginDao">
		<property name="sessionFactory" ref="sessionFactory"></property>
	</bean>
	<bean id ="seriver" class="yaosai.ccut.servier.MServier">
		<property name="logindao" ref="logindao"></property>
	</bean>
	<bean  name="/logincontroller.do" class="yaosai.ccut.controller.Mcontroller">
		<property name="seriver" ref="seriver"></property>
	</bean>
		
	</beans>

6编写 po对象 及基于xml配置

6.1.po对象用来存取前台传递过来的账号密码

package yaosai.ccut.po;

public class User {
	private int id;
	private String username;
	private String password;
	public int getId() {
		return id;
	}
	public void setId(int 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;
	}
	
	
}

6.2.user.hbm.xml的配置

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd" >
<hibernate-mapping>
	<class name="yaosai.ccut.po.User" table="t_usser">
	 	<id name="id">
	 	 <generator class="native"></generator>
	 	 </id>
	 	 <property name="username"></property>
	 	 <property name="password"></property>
	</class>
</hibernate-mapping>

7 编写操作数据库Dao 类bean

接口dao

package yaosai.ccut.dao;

public interface LoginDaoInterFace {
	int queryByusernameandPassword(String username,String password);
}

实现接口

package yaosai.ccut.dao;

import java.util.List;

import org.springframework.orm.hibernate3.support.HibernateDaoSupport;

public class LoginDao extends HibernateDaoSupport implements LoginDaoInterFace {

	public int queryByusernameandPassword(String username, String password) {
		System.out.println(username);
		List l =this.getHibernateTemplate().
		find("from User as user where user.username = ? and user.password = ?",username,password);
		return l.size();
	}

}

8 服务bean

接口

package yaosai.ccut.servier;

import yaosai.ccut.dao.LoginDao;
import yaosai.ccut.po.User;


public interface SeriverInterFace {
	boolean foundUser(User user);
}

实现接口

package yaosai.ccut.servier;

import yaosai.ccut.dao.LoginDao;
import yaosai.ccut.dao.LoginDaoInterFace;
import yaosai.ccut.po.User;

public class MServier implements SeriverInterFace {
	private LoginDaoInterFace logindao;
	
	
	public LoginDaoInterFace getLogindao() {
		return logindao;
	}


	public void setLogindao(LoginDaoInterFace logindao) {
		this.logindao = logindao;
	}


	public boolean foundUser(User user) {
		System.out.println(user.getPassword());
		int size =logindao.queryByusernameandPassword(user.getUsername(), user.getPassword());
		//int size = 5;
		System.out.println(size);
		if(size>0)return true;
		else return false;
	}

}

9controller 控制类bean 对应mvc中 的c

package yaosai.ccut.controller;

import org.springframework.web.servlet.ModelAndView;
import org.springframework.web.servlet.mvc.SimpleFormController;

import yaosai.ccut.po.User;
import yaosai.ccut.servier.SeriverInterFace;

@SuppressWarnings("deprecation")
public class Mcontroller extends SimpleFormController{
	private SeriverInterFace seriver;

	public SeriverInterFace getSeriver() {
		return seriver;
	}

	public void setSeriver(SeriverInterFace seriver) {
		this.seriver = seriver;
	}

	public Mcontroller() {
		this.setCommandClass(User.class);
	}
	@Override
	protected ModelAndView onSubmit(Object command) throws Exception {
	    User uesr = (User)command;
	   boolean b = seriver.foundUser(uesr);
		if(b){
			return new ModelAndView("success.jsp","user",uesr);
		}else{
			return new ModelAndView("error.jsp");
	}
	}
	
}

10 把bean加入到applicationContent中就完成大部分的工作，把jar引入工程。