springmvc＋spring＋mybatis实现用户登录功能（上）

 4.0.0
 com.mjl
 testssm
 war
 1.0-SNAPSHOT
 testssm Maven Webapp
 http://maven.apache.org


 
 UTF-8
 4.1.4.RELEASE
 2.5.0
 
 
 


  junit
  junit
  4.12
  test
 


 
 
  org.springframework
  spring-core
  ${spring.version}
 

 
  org.springframework
  spring-beans
  ${spring.version}
 

 
  org.springframework
  spring-context
  ${spring.version}
 

 
  org.springframework
  spring-tx
  ${spring.version}
 

 
  org.springframework
  spring-web
  ${spring.version}
 

 
  org.springframework
  spring-webmvc
  ${spring.version}
 

 
  org.springframework
  spring-jdbc
  ${spring.version}
 

 
  org.springframework
  spring-test
  ${spring.version}
  test
 

 
 
  org.mybatis
  mybatis
  3.2.8
 

 
 
  org.mybatis
  mybatis-spring
  1.2.2
 

 
 
  mysql
  mysql-connector-java
  5.1.34
 

 
 
  com.mchange
  c3p0
  0.9.5-pre8
 

 
  org.aspectj
  aspectjweaver
  1.8.4
 
 
 
  log4j
  log4j
  1.2.17
 

 
 
  javax.servlet
  servlet-api
  3.0-alpha-1
 
 
  javax.servlet
  jstl
  1.2
 
 
 
  org.codehaus.jackson
  jackson-mapper-asl
  1.9.13
 
 
 
  commons-io
  commons-io
  2.4
 

 
  commons-fileupload
  commons-fileupload
  1.2.2
 
 
 
 testssm
 

<?xml version="1.0" encoding="utf-8"?>

 
 
 
  contextConfigLocation
  
   classpath*:config/applicationContext.xml
  
 
 
 
  org.springframework.web.context.ContextLoaderListener
 
 
 
  encodingFilter
  org.springframework.web.filter.CharacterEncodingFilter
  
   encoding
   UTF-8
  
  
   forceEncoding
   true
  
 
 
  encodingFilter
  /*
 

<?xml version="1.0" encoding="UTF-8"?>


 
 
 
 
 
 
  
  
  
  
  
  
  
  
  
  
  
  
  
  
 

 
 
  
  
  
  
  
  
 
 
 
   

 
 
 
  
 

<?xml version="1.0" encoding="UTF-8" ?>


 
 
  
 

create database if not exists db_ssm character set utf8;
use db_ssm;
create table tb_user(
id int(10) auto_increment,
username varchar(20) not null,
password varchar(20) not null,
primary key (id)
)ENGINE=InnoDB DEFAULT CHARSET utf8 COLLATE utf8_general_ci;

insert into tb_user(id,username,password) values(1,'alvin',1234);

package com.mjl.model;

/**
 * Created by alvin on 15/9/7.
 */
public class User {
 private int id;
 private String username;
 private String password;

 public String getPassword() {
  return password;
 }

 public void setPassword(String password) {
  this.password = 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;
 }
}

package com.mjl.dao;

import com.mjl.model.User;

/**
 * Created by alvin on 15/9/7.
 * 此类为接口模式下的配置
 */

public interface IUserDao {
 //这里以接口形式定义了数据库操作方法,我们只需
 // 在Mybatis映射文件中对其进行映射就可以直接使用
 public User selectById(int id);
 public User selectByName(String username);
}

<?xml version="1.0" encoding="UTF-8" ?>


 

 
 
  select * from tb_user where username = #{username}
 

 

   select * from tb_user where id = #{id}
 

package com.mjl.test;

import com.mjl.dao.IUserDao;


import com.mjl.model.User;
import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;


/**
 * Created by Alvin on 15/9/6.
 */
public class Test {
 private static ApplicationContext ac;
 static {
  ac = new ClassPathXmlApplicationContext("config/applicationContext.xml");
 }

 public static void main(String[] args) {
  IUserDao mapper = (IUserDao) ac.getBean("IUserDao");
  System.out.println("获取alvin");
  User user = mapper.selectByName("alvin");

  System.out.println(user.getId()+":"+"username:"+user.getUsername());
  System.out.println("password:"+user.getPassword());

 }
}