Spring 使用配置完成从前台页面输入到查询数据库的例子

跟着下面的例子走吧

 

1   Spring数据源配置

<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close"> 
        <property name="driverClassName" value="com.mysql.jdbc.Driver"></property>
        <property name="url" value="jdbc:mysql://127.0.0.1:3306/daoxiang"></property>
        <property name="username" value="root"></property>
        <property name="password" value="root"></property>  
    </bean>

2  定义Spring JDBC模板类bean

<bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate">
        <property name="dataSource" ref="dataSource"></property>
    </bean>

3  页面输入

<form action="Login" method="post">       
		    <Table>
		        <Tr> 
		            <td>用户名:</Td>  
		            <td><input type="text" name="username" /></Td>
		        </Tr> 
		        <Tr> 
		            <td>密码:</Td>
		            <td><input type="password" name="password" /></Td> 
		        </Tr> 
		        <Tr> 
		            <td><input type="submit" name="submit" value="登录"/></Td>
		            <td><input type="reset" name="reset" value="重置"/></Td>
		        </Tr> 
		    </Table>  
    </form> 

4  Struts 接收

<action name="Login" class="com.struts2.action.LoginAction">
            <result name="success">/welcome.jsp</result>
            <result name="error">/error.jsp</result>    
        </action>  

5 相应的Dao接口

public interface YuangongDao{  
	/**
	 * Description:验证用户登陆
	 * @param Yuangong 用户
	 * @return Yuangong
	 */	  
	public boolean checkYuangong(String wName,String wPassword);
}

6  Dao实现类

public class YuangongDaoImpl implements YuangongDao{  
	private JdbcTemplate jdbcTemplate; 
	public boolean checkYuangong(String wName, String wPassord) {
		System.out.println(wPassord); 
		String sql="select count(*) from yuangong where wName=? and wPassord=? ";
		int count = jdbcTemplate.queryForInt(sql,new Object[]{wName,wPassord});
		return count>0;
	}
	public void setJdbcTemplate(JdbcTemplate jdbcTemplate) {
		this.jdbcTemplate = jdbcTemplate;
	}
}

7  Spring配置Dao

<bean id="yuangongDao" class="com.struts2.daoImpl.YuangongDaoImpl">   
        <property name="jdbcTemplate" ref="jdbcTemplate" ></property>
    </bean>

8  Service

public class LoginService { 
    private YuangongDao yuangongDao;
    public boolean login(Yuangong yuangong) throws Exception{
        boolean flag=false;
        if(yuangongDao.checkYuangong(yuangong.getwName(), yuangong.getwPassord())){
            flag=true; 
        }
        return flag;
    } 
	public YuangongDao getYuangongDao() {
		return yuangongDao;
	}
	public void setYuangongDao(YuangongDao yuangongDao) {
		this.yuangongDao = yuangongDao;
	}
}

 

9 Spring 配置Service

 <bean id="loginService" class="com.struts2.service.LoginService">
        <property name="yuangongDao" ref="yuangongDao"></property>
     </bean>   

10 Action

public class LoginAction extends ActionSupport implements Action{
    private static final long serialVersionUID  =   1L ; 
    private String username;
    private String password;
    private LoginService loginService;
    @Override   
    public void validate(){  
    }
    public String execute() throws Exception{ 
        Yuangong yuangong=new Yuangong();
        yuangong.setwName(username);
        yuangong.setwPassord(password);
        boolean result=this.loginService.login(yuangong);
        if(result){
            return this.SUCCESS;  
        }else{
            return this.ERROR ;
        }  
    }
    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;
    }
    public LoginService getLoginService() {
        return loginService;
    }
   public void setLoginService(LoginService loginService) {
       this.loginService = loginService;
    }
}

完成