eclipse获取数据库中表中的数据

创建maven项目

数据库表：

 

创建实体类

 

 Book.java

package ssm.entity;

import java.util.Date;

public class Book {

    private String isbn;
    private String title;
    private String author;
    private double price;
    private String press;
    private int edition;
    private Date published;
    private int pages;
    private String packaging;
    private String format;
    private String form;
    private int words;
    public String getIsbn() {
        return isbn;
    }
    public void setIsbn(String isbn) {
        this.isbn = isbn;
    }
    public String getTitle() {
        return title;
    }
    public void setTitle(String title) {
        this.title = title;
    }
    public String getAuthor() {
        return author;
    }
    public void setAuthor(String author) {
        this.author = author;
    }
    public double getPrice() {
        return price;
    }
    public void setPrice(double price) {
        this.price = price;
    }
    public String getPress() {
        return press;
    }
    public void setPress(String press) {
        this.press = press;
    }
    public int getEdition() {
        return edition;
    }
    public void setEdition(int edition) {
        this.edition = edition;
    }
    public Date getPublished() {
        return published;
    }
    public void setPublished(Date published) {
        this.published = published;
    }
    public int getPages() {
        return pages;
    }
    public void setPages(int pages) {
        this.pages = pages;
    }
    public String getPackaging() {
        return packaging;
    }
    public void setPackaging(String packaging) {
        this.packaging = packaging;
    }
    public String getFormat() {
        return format;
    }
    public void setFormat(String format) {
        this.format = format;
    }
    public String getForm() {
        return form;
    }
    public void setForm(String form) {
        this.form = form;
    }
    public int getWords() {
        return words;
    }
    public void setWords(int words) {
        this.words = words;
    }
    @Override
    public String toString() {
        return "Book [isbn=" + isbn + ", title=" + title + ", author=" + author + ", price=" + price + ", press="
                + press + ", edition=" + edition + ", published=" + published + ", pages=" + pages + ", packaging="
                + packaging + ", format=" + format + ", form=" + form + ", words=" + words + "]";
    }
    
    
    

}

创建BookMapper

 

 

 

package ssm.mapper;

import java.util.List;

import org.apache.ibatis.session.SqlSession;

import ssm.entity.Book;
import ssm.util.MybatisUtil;

public interface BookMapper {
     public List<Book> selectAll();
}

创建BookMapper.xml

 

 

<?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="ssm.mapper.BookMapper">
    <select id="selectAll" parameterType="ssm.entity.Book" resultType="ssm.entity.Book">
        select isbn,title,author,price,press,edition,published,pages,packaging,format,form,words from tb_book
    </select>
</mapper>

创建MybatisStarter.java

 

 

package ssm;
import java.util.List;

import ssm.entity.Book;
import ssm.entity.User;
import ssm.mapper.BookMapper;
import ssm.mapper.UserMapper;
import ssm.util.MybatisUtil;


public class MybatisStarter {
    public static void main(String[] args) {
//        User user=new User();
//        user.setUpwd("12345") ;
//        user.setPhone("123456789") ;
//        user.setUname("zc") ;
//        user.setEmail("123456789@qq.com");
//        user.setRole(1);
//        UserDao dao=new UserDao();
//        dao.insert(user);
//        System.out.println(dao.selectAll());
        
        Book book = new Book();
        BookMapper bookDao= MybatisUtil.getSession().getMapper(BookMapper.class);
        List<Book> books =bookDao.selectAll();
        for(Book book1:books){
//            System.out.println(bookDao.selectAll());
            System.out.println(book1.toString());

        }


    }
}

 

 

 

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE configuration  
PUBLIC "-//mybatis.org//DTD Config 3.0//EN" 
"http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
    <environments default="dev">
        <environment id="dev">
            <transactionManager type="JDBC">

            </transactionManager>
            <dataSource type="POOLED">
                <property name="username" value="root"/>
                <property name="password" value="root"/>
                <property name="driver" value="com.mysql.jdbc.Driver"/>
                <property name="url" value="jdbc:mysql://localhost:3306/ssm?useSSL=false&amp;characterEncoding=utf8"/>
            </dataSource>
        </environment>
        <environment id="pro">
            <transactionManager type="JDBC">

            </transactionManager>
            <dataSource type="POOLED">
                <property name="username" value="root"/>
                <property name="password" value="root"/>
                <property name="driver" value="com.mysql.jdbc.Driver"/>
                <property name="url" value="jdbc:mysql://localhost:3306/ssm?useSSL=false&amp;characterEncoding=utf8"/>
            </dataSource>
        </environment>
    </environments>
    <mappers>
        <mapper resource="ssm/mapper/UserMapper.xml"></mapper>
        <mapper resource="ssm/mapper/BookMapper.xml"></mapper>
    </mappers>
</configuration>

pom.xml

<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/maven-v4_0_0.xsd">
  <modelVersion>4.0.0</modelVersion>
  <groupId>cn.tedu</groupId>
  <artifactId>myssm</artifactId>
  <packaging>war</packaging>
  <version>0.0.1-SNAPSHOT</version>
  <name>myssm Maven Webapp</name>
  <url>http://maven.apache.org</url>
  <dependencies>
  <!-- https://mvnrepository.com/artifact/org.mybatis/mybatis -->
    <dependency>
      <groupId>org.mybatis</groupId>
      <artifactId>mybatis</artifactId>
      <version>3.5.3</version>
    </dependency>
    <dependency>
      <groupId>mysql</groupId>
      <artifactId>mysql-connector-java</artifactId>
      <version>5.1.47</version>
    </dependency>
    <dependency>
      <groupId>junit</groupId>
      <artifactId>junit</artifactId>
      <version>3.8.1</version>
      <scope>test</scope>
    </dependency>
  </dependencies>
  <build>
    <finalName>myssm</finalName>
    <defaultGoal>compile</defaultGoal>
  </build>
</project>

 

MybatisStarter.java启动