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&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&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启动