如题
问题截图
项目结构图
各结构代码如下
goodsMapper.java
package com.mapper;
import com.pojo.goods;
import org.apache.ibatis.annotations.Select;
import java.util.List;
public interface goodsMapper {
// 查询所有
@Select("select * from 固定资产信息表")
List<goods> selectAll();
}
goodsService.java
package com.service;
import com.mapper.goodsMapper;
import com.pojo.goods;
import com.util.sqlSessionFactoryUtils;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import java.util.List;
public class goodsService {
SqlSessionFactory factory = sqlSessionFactoryUtils.getSqlSessionFactory();
//查询所有
public List<goods> selectAll(){
SqlSession sqlSession = factory.openSession();
goodsMapper mapper = sqlSession.getMapper(goodsMapper.class);
List<goods> goods = mapper.selectAll();
sqlSession.close();
return goods;
}
}
sqlSessionFactoryUtils.java
```java
package com.util;
import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;
import java.io.IOException;
import java.io.InputStream;
public class sqlSessionFactoryUtils {
private static SqlSessionFactory sqlSessionFactory;
static {
//静态代码块会随着类的加载而自动执行,且只执行一次
try {
String resource = "mybatis-config.xml";
InputStream inputstream = Resources.getResourceAsStream(resource);
sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputstream);
} catch (IOException e) {
e.printStackTrace();
}
}
public static SqlSessionFactory getSqlSessionFactory() {
return sqlSessionFactory;
}
}
selectAllServlet.java
package com.web;
import com.pojo.goods;
import com.service.goodsService;
import javax.servlet.*;
import javax.servlet.http.*;
import javax.servlet.annotation.*;
import java.io.IOException;
import java.util.List;
@WebServlet("/selectAllServlet")
public class selectAllServlet extends HttpServlet {
goodsService service = new goodsService();
@Override
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
List<goods> goods = service.selectAll();
request.setAttribute("goods",goods);
request.getRequestDispatcher("/goods.jsp").forward(request,response);
}
@Override
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
}
}
goodsMapper.xml
```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="com.mapper.goodsMapper">
</mapper>
mybatis-config.xml
```xml
<configuration>
<!--起别名-->
<typeAliases>
<package name="com.pojo"/>
</typeAliases>
<environments default="development">
<environment id="development">
<transactionManager type="JDBC"/>
<dataSource type="POOLED">
<property name="driver" value="com.mysql.jdbc.Driver"/>
<property name="url" value="jdbc:mysql:///managementsystem?useSSL=false&useServerPrepStmts=true"/>
<property name="username" value="root"/>
<property name="password" value="1234"/>
</dataSource>
</environment>
</environments>
<mappers>
<!--扫描mapper-->
<package name="com.mapper"/>
</mappers>
<bean id="viewResolver" class="org.springframework.web.servlet.view.InternalResourceViewResolver">
<property name="prefix" value="/"/>
<property name="suffix" value=".jsp"/>
</bean>
</configuration>
web.xml
<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns="http://xmlns.jcp.org/xml/ns/javaee"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee http://xmlns.jcp.org/xml/ns/javaee/web-app_3_1.xsd"
version="3.1"
metadata-complete="false">
</web-app>
goods.jsp
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<%@ page isELIgnored="false"%>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>企业固定资产信息表</title>
</head>
<body>
<input type="button" value="新增"><br>
<hr>
<table border="1" cellSpacing="0" width="800">
<tr>
<th>固定资产编号</th>
<th>固定资产名称</th>
<th>单位数量</th>
<th>均价</th>
</tr>
<c:forEach items="${goods}" var="goods" varStatus="status">
<tr align="center">
<%--<td>${brand.id}</td>--%>
<td>${status.count}</td>
<td>${goods.id}</td>
<td>${goods.name}</td>
<td>${goods.number}</td>
<td>${goods.averagePrice}</td>
<%--<c:if test="${goods.status == 1}">
<td>启用</td>
</c:if>
<c:if test="${goods.status != 1}">
<td>禁用</td>
</c:if>--%>
<%--<td><a href="#"> 修改 </a> <a href = "#">删除</a></td>--%>
</tr>
</c:forEach>
</table>
</body>
</html>
index.html
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>企业固定资产管理系统</title>
</head>
<body>
<a href="/system/selectAllServlet">
查询所有
</a>
</body>
</html>
还有maven
pom.xml
```xml
<?xml version="1.0" encoding="UTF-8"?>
<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/xsd/maven-4.0.0.xsd">
<modelVersion>4.0.0</modelVersion>
<groupId>org.example</groupId>
<artifactId>system</artifactId>
<version>1.0-SNAPSHOT</version>
<packaging>war</packaging>
<properties>
<maven.compiler.source>8</maven.compiler.source>
<maven.compiler.target>8</maven.compiler.target>
</properties>
<dependencies>
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>3.5.5</version>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.34</version>
</dependency>
<dependency>
<groupId>javax.servlet</groupId>
<artifactId>javax.servlet-api</artifactId>
<version>3.1.0</version>
<scope>provided</scope>
</dependency>
<dependency>
<groupId>javax.servlet.jsp</groupId>
<artifactId>jsp-api</artifactId>
<version>2.2</version>
<scope>provided</scope>
</dependency>
<dependency>
<groupId>jstl</groupId>
<artifactId>jstl</artifactId>
<version>1.2</version>
</dependency>
<dependency>
<groupId>taglibs</groupId>
<artifactId>standard</artifactId>
<version>1.1.2</version>
</dependency>
</dependencies>
<build>
<plugins>
<plugin>
<groupId>org.apache.tomcat.maven</groupId>
<artifactId>tomcat7-maven-plugin</artifactId>
<version>2.2</version>
</plugin>
</plugins>
</build>
</project>
就是一个简单的读取表格
代码都没有报错和飘红,各位有没有什么解决的方法?
初学者卡在这里了……
访问路径不对,或项目名不对。要是不会操作,可以找我远程
看一下war包的名字,是不是项目名不对
启动类增加@ServletComponentScan这个注解
如有帮助,请采纳,十分感谢!
这里设置了视图解析器的前缀和后缀的问题
重启项目换个浏览器访问
1、先测试tomcat是否运行成功
2、没问题的情况下看下系统中有没有默认的前缀
3、然后拼接上controller中的请求路径
路径不对
你的请求地址改成这个,/selectAllServlet
Tomcat启动成功访问404:源服务器未能找到目标资源的表示或者是不愿公开一个已经存在的资源表示。
https://blog.csdn.net/weixin_43309946/article/details/103223091
Web.xml中配置一个默认页面地址。web-inf 中的文件对外不可直接访问。
<welcome-file-list>
<welcome-file>index.html</welcome-file>
</welcome-file-list>