创建的maven的java项目
结构如下:
pom.xml中添加以下依赖
<dependencies>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.6</version>
<scope>runtime</scope>
</dependency>
<dependency>
<groupId>javax.servlet</groupId>
<artifactId>servlet-api</artifactId>
<version>2.5</version>
<scope>provided</scope>
</dependency>
<dependency>
<groupId>javax.servlet.jsp</groupId>
<artifactId>jsp-api</artifactId>
<version>2.0</version>
<scope>test</scope>
</dependency>
<dependency>
<groupId>junit</groupId>
<artifactId>junit</artifactId>
<version>4.12</version>
<scope>test</scope>
</dependency>
</dependencies>
javabean Goods
package zr.domain;
public class Goods {
private Integer id;
private String goodsNum;
public Integer getId() {
return id;
}
public void setId(Integer id) {
this.id = id;
}
public String getGoodsNum() {
return goodsNum;
}
public void setGoodsNum(String goodsNum) {
this.goodsNum = goodsNum;
}
@Override
public String toString() {
return "Goods{" +
"id=" + id +
", goodsNum='" + goodsNum + '\'' +
'}';
}
}
Dao
接口GoodsDao
package zr.dao;
import zr.domain.Goods;
import java.sql.SQLException;
import java.util.List;
public interface GoodsDao {
public List<Goods> findAll() throws Exception;
}
实现类GoodsDaoImpl
package zr.dao.Impl;
import zr.dao.GoodsDao;
import zr.domain.Goods;
import java.sql.*;
import java.util.ArrayList;
import java.util.List;
/**
* 要想从数据库中取出数据
* 必须有四个属性:数据库驱动,连接数据库的地址,数据库用户名,密码
*/
public class GoodsDaoImpl implements GoodsDao {
public List<Goods> findAll() throws Exception {
PreparedStatement ps=null;
Connection connection=null;
ResultSet resultSet=null;
List<Goods> list=null;
try{
//加载驱动类
Class.forName("com.mysql.jdbc.Driver");
//先获取connection对象
connection = DriverManager.getConnection("jdbc:mysql:///goodsmarket?serverTimezone=UTC","root","root");
//获取真正操作数据的对象
ps=connection.prepareCall("select * from goodsinfo");
//执行数据库查询操作
resultSet = ps.executeQuery();
//把数据库结果集转成java的List集合
list=new ArrayList<Goods>();
while(resultSet.next()){
Goods goods=new Goods();
goods.setId((Integer) resultSet.getObject(1));
goods.setGoodsNum((String) resultSet.getObject(3));
list.add(goods);
}
}catch (Exception e){
e.printStackTrace();
}finally {
connection.close();
ps.close();
resultSet.close();
}
return list;
}
}
在test/java下的GoodsTest测试类
package zr.test;
import org.junit.Test;
import zr.dao.GoodsDao;
import zr.dao.Impl.GoodsDaoImpl;
import zr.domain.Goods;
import java.util.List;
public class GoodsTest {
@Test
public void findAll() throws Exception {
GoodsDao goodsDao=new GoodsDaoImpl();
List<Goods> all = goodsDao.findAll();
for (Goods goods : all) {
System.out.println(goods);
}
}
}
然后点击测试,这里面注意如果提示不支持发行版本5,可以按照下面这篇博客进行修改
https://blog.csdn.net/qq_22076345/article/details/82392236
按照上面这篇博客,根据自己本地安装的jdk的版本来修改
mysql数据库的表为:
程序运行结果为:
到此就用maven实现了数据库数据的获取