com.qs.validation.ValidationCheck.java Source code

Introduction

Here is the source code for com.qs.validation.ValidationCheck.java

Source

/*
 * To change this license header, choose License Headers in Project Properties.
 * To change this template file, choose Tools | Templates
 * and open the template in the editor.
 */
package com.qs.validation;

import com.qs.dao.PostDao;
import com.qs.dao.UserDao;
import com.qs.entity.Post;
import com.qs.entity.User;
import java.io.IOException;
import java.io.Reader;
import java.util.List;
import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;

/**
 *
 * @author qiushi
 */
public class ValidationCheck {

    public SqlSession getSqlSession() {

        String resource = "mybatis_sql_config//mybatis_config.xml";
        Reader reader = null;
        try {
            reader = Resources.getResourceAsReader(resource);
        } catch (IOException e) {
            e.printStackTrace();

        }
        System.out.println(reader == null);
        org.apache.ibatis.logging.LogFactory.useLog4JLogging();
        SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(reader);
        SqlSession session = sqlSessionFactory.openSession();
        return session;
    }

    //?user
    public static List<User> getAllUser() {

        ValidationCheck vc = new ValidationCheck();
        SqlSession session = vc.getSqlSession();
        List<User> list = null;
        try {
            UserDao userDao = session.getMapper(UserDao.class);
            list = userDao.getAllUser();
            System.out.println(list.size());

        } finally {
            session.close();
        }

        return list;
    }

    //???
    public static List<String> getPasswordByName(String userName) {

        List<String> list = null;
        ValidationCheck vc = new ValidationCheck();
        SqlSession session = vc.getSqlSession();

        try {
            UserDao userDao = session.getMapper(UserDao.class);
            list = userDao.getPasswordByName(userName);
            if (!list.isEmpty()) {
                System.out.println(list.size() + list.get(0));
            }

        } finally {
            session.close();
        }

        return list;
    }

    //???? 
    public boolean checkUserNameExist(String userName) {

        List<String> list = null;
        ValidationCheck vc = new ValidationCheck();
        SqlSession session = vc.getSqlSession();
        try {

            UserDao userDao = session.getMapper(UserDao.class);
            //User test=userDao.getUserByUserName("admin");
            //System.out.println(test.getPassword()+"test ");
            list = userDao.getPasswordByName(userName);
            if (!list.isEmpty()) {
                System.out.println(list.size() + list.get(0));
                return false;
            } else {
                return true;
            }

        } catch (Exception e) {
            System.out.println(e);
            return false;
        } finally {
            session.close();
        }

    }

    public static void main(String[] args) {
        //getAllUser();
        //getPasswordByName("admin");
        ValidationCheck vc = new ValidationCheck();
        //System.out.println(vc.checkUserNameExist("admin")+"jieguojieguo");
        //ValidationCheck  vc=new ValidationCheck();
        SqlSession session = vc.getSqlSession();

        try {
            //UserDao userDao=session.getMapper(UserDao.class);
            PostDao postDao = session.getMapper(PostDao.class);
            List<Post> list = postDao.getAllPost();
            System.out.println(list.size());

        } catch (Exception e) {
            System.out.println(e);
        }

    }
}