上个博客完成了登录和注册的功能,本次在上次添加了登录成功跳转数据库商品信息的页面
跳转新表
一.创建一个用户功能类GoodsDao链接数据库查询内容
public class GoodsDao {
Goods goods=null;
Connection con=null;
PreparedStatement pstm=null;
ResultSet rs = null;
List<Goods> goodslist=null;
public List<Goods> selectAll(){
try {
con = JDBCUtil.getCon();
String sql ="select * from t_goods";
pstm = con.prepareStatement(sql);
rs = pstm.executeQuery();
goodslist= new ArrayList<>();
while (rs.next()){
goods=new Goods();
goods.setGid(rs.getInt("gid"));
goods.setGname(rs.getString("gnam