JAVAEE作业

1、作业内容

在数据库testData中，建立表格T_CUSTOMER（ACCOUNT，PASSWPRD，CNAME），插入一些数据，

要求：

​ 1、制作一个登陆验证程序，输入账号和密码，如果匹配，则提示“XXX登陆成功”，否则提示登录失败。

​ 其中XXX来自于表中内容。

​ 2、必须使用Spring+MyBatis框架整合

2、过程

1、建立数据库

CREATE DATABASE `testdata` ;

USE `testdata`;

CREATE TABLE `t_customer` (
  `ACCOUNT` varchar(20) NOT NULL,
  `PASSWORD` varchar(40) DEFAULT NULL,
  `CNAME` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`ACCOUNT`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

insert  into `t_customer`(`ACCOUNT`,`PASSWORD`,`CNAME`) values 
('24988','249887','廖'),
('l24988','lsy24988','lsy'),
('qaz123','qaz123qaz','zhang');

2、导包

导入Spring和MyBatis包

3、建立数据库操作层

1、创建Spring-MyBatis配置文件

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
       xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd">

        <bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
            <property name="driverClassName" value="com.mysql.cj.jdbc.Driver"/>
            <property name="url" value="jdbc:mysql://localhost:3306/testdata?useSSL=false&amp;useUnicode=true&amp;characterEncoding=utf-8"/>
            <property name="username" value="root"/>
            <property name="password" value="123456"/>
        </bean>

        <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
            <property name="dataSource" ref="dataSource" />
            <property name="mapperLocations" value="classpath:com/mybatis/mapper/*.xml"/>
        </bean>

        <bean id="sqlSession" class="org.mybatis.spring.SqlSessionTemplate">
            <constructor-arg index="0" ref="sqlSessionFactory"/>
        </bean>

</beans>

2.实体类pojo

public class User {
private String account;
private String password;
private String cname;

    public User(String account, String password) {
        this.account = account;
        this.password = password;
    }

    public String getAccount() {
        return account;
    }

    public void setAccount(String account) {
        this.account = account;
    }

    public String getPassword() {
        return password;
    }

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

    public String getCname() {
        return cname;
    }

    public void setCname(String cname) {
        this.cname = cname;
    }

    @Override
    public String toString() {
        return "User{" +
                "account='" + account + '\'' +
                ", password='" + password + '\'' +
                ", cname='" + cname + '\'' +
                '}';
    }
}

3.Mapper

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
        PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.mybatis.mapper.UserMapper">
    <!--验证登录-->
    <select id="login" parameterType="User"
    resultType="User">
        select * from t_customer where account=#{account}
        and password=#{password}
    </select>
</mapper>

4.登陆实现

import org.apache.ibatis.session.SqlSession;
import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;

import java.io.InputStream;
import java.util.Scanner;

public class enter {
    public static void main(String[] args) {
        User user = new User();
        System.out.println("请输入账号和密码，以回车键结束");
        Scanner sc=new Scanner(System.in);
        user.setAccount(sc.next());
        user.setPassword(sc.next());


        ApplicationContext context = new ClassPathXmlApplicationContext("Spring-mybatis-conf.xml");
        SqlSession sqlSession = context.getBean("sqlSession", SqlSession.class);
        User res = sqlSession.selectOne("com.mybatis.mapper.UserMapper.login",user);
        if(res!=null)
            System.out.println("欢迎"+res.getCname()+"登录！");
        else
            System.out.println("登录失败！");

    }
}