### 新建
Java EE项目详细步骤
#### 1
. 准备工作
- **IDE**
: IntelliJ IDEA
- **数据库**
: MySQL 5
.5
.62
- **数据库管理工具**
: Navicat
- **端口**
: 3306
- **开发框架**
: Spring, Spring MVC, MyBatis
- **应用服务器**
: Tomcat 7
.0 或以上
#### 2
. 创建项目
1
. **打开IntelliJ IDEA**
- 选择 `File`
-> `New`
-> `Project`。
- 选择 `
Java Enterprise`，勾选 `Web Application` 和 `Spring`。
- 点击 `Next`，选择 `Tomcat 7
.0` 作为应用服务器。
- 点击 `Next`，输入项目名称和位置，点击 `Finish`。
2
. **配置项目结构**
- 右键项目根目录，选择 `New`
-> `Directory`，创建以下目录结构：
```
src/main/
java/com/example/bookstore
src/main/resources
src/main/webapp/WEB
-INF
```
#### 3
. 添加依赖
1
. **打开 `pom
.xml` 文件**，添加以下依赖：
```
xml
<dependencies>
<!
-- Spring
-->
<dependency>
<groupId>
org.springframework</groupId>
<artifactId>spring
-webmvc</artifactId>
<version>5
.3
.10</version>
</dependency>
<dependency>
<groupId>
org.springframework</groupId>
<artifactId>spring
-jdbc</artifactId>
<version>5
.3
.10</version>
</dependency>
<!
-- MyBatis
-->
<dependency>
<groupId>
org.mybatis
.spring
.boot</groupId>
<artifactId>mybatis
-spring
-boot
-starter</artifactId>
<version>2
.1
.3</version>
</dependency>
<!
-- MySQL Connector
-->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql
-connector
-java</artifactId>
<version>5
.1
.49</version>
</dependency>
<!
-- Servlet API
-->
<dependency>
<groupId>
javax
.servlet</groupId>
<artifactId>
javax
.servlet
-api</artifactId>
<version>4
.0
.1</version>
<scope>provided</scope>
</dependency>
<!
-- JSP API
-->
<dependency>
<groupId>
javax
.servlet
.jsp</groupId>
<artifactId>jsp
-api</artifactId>
<version>2
.2</version>
<scope>provided</scope>
</dependency>
</dependencies>
```
2
. **配置 `web
.xml`**
- 打开 `src/main/webapp/WEB
-INF/web
.xml`，添加以下内容：
```
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
-i
nstance"
xsi
:schemaLocation="
http://xmlns.jcp.org/
xml/
ns/
javaee http://xmlns.jcp.org/
xml/
ns/
javaee/web
-app_3_1
.xsd"
version="3
.1">
<servlet>
<servlet
-name>dispatcher</servlet
-name>
<servlet
-class>
org.springframework
.web
.servlet
.DispatcherServlet</servlet
-class>
<
init-param>
<
param-name>contextConfigLocation</
param-name>
<
param-value>/WEB
-INF/spring/appServlet/servlet
-context
.xml</
param-value>
</
init-param>
<load
-on
-startup>1</load
-on
-startup>
</servlet>
<servlet
-mapping>
<servlet
-name>dispatcher</servlet
-name>
<url
-pattern>/</url
-pattern>
</servlet
-mapping>
</web
-app>
```
3
. **配置 `servlet
-context
.xml`**
- 在 `src/main/webapp/WEB
-INF/spring/appServlet` 目录下创建 `servlet
-context
.xml`，添加以下内容：
```
xml
<?
xml version="1
.0" encoding="UTF
-8"?>
<bea
ns xmlns="
http://www
.springframework
.org/schema/bea
ns"
xmlns:xsi="
http://www
.w3
.org/2001/
XMLSchema
-i
nstance"
xmlns:context="
http://www
.springframework
.org/schema/context"
xmlns:mvc="
http://www
.springframework
.org/schema/mvc"
xsi
:schemaLocation="
http://www
.springframework
.org/schema/bea
ns http://www
.springframework
.org/schema/bea
ns/spring
-bea
ns.xsd
http://www
.springframework
.org/schema/context
http://www
.springframework
.org/schema/context/spring
-context
.xsd
http://www
.springframework
.org/schema/mvc
http://www
.springframework
.org/schema/mvc/spring
-mvc
.xsd">
<context
:component
-scan base
-package="com
.example
.bookstore"/>
<mvc
:annotation
-driven/>
<bean class="
org.springframework
.web
.servlet
.view
.InternalResourceViewResolver">
<property name="prefix" value="/WEB
-INF/views/"/>
<property name="suffix" value="
.jsp"/>
</bean>
<bean id="dataSource" class="
org.springframework
.jdbc
.datasource
.DriverManagerDataSource">
<property name="driverClassName" value="com
.mysql
.jdbc
.Driver"/>
<property name="url" value="jdbc
:mysql
://localhost
:3306/bookstore?useSSL=false&useUnicode=true&characterEncoding=UTF
-8"/>
<property name="username" value="root"/>
<property name="password" value="password"/>
</bean>
<bean id="sqlSessionFactory" class="
org.mybatis
.spring
.SqlSessionFactoryBean">
<property name="dataSource" ref="dataSource"/>
<property name="mapperLocatio
ns" value="classpath*
:mappers/*
.xml"/>
</bean>
<bean class="
org.mybatis
.spring
.mapper
.MapperScannerConfigurer">
<property name="basePackage" value="com
.example
.bookstore
.mapper"/>
</bean>
</bea
ns>
```
#### 4
. 创建数据库
1
. **启动Navicat**
- 连接到MySQL服务器，主机为 `localhost`，端口为 `3306`，用户名为 `root`，密码为 `password`。
2
. **创建数据库**
- 右键数据库列表，选择 `新建数据库`，输入数据库名称 `bookstore`，点击 `确定`。
3
. **创建表**
- 在 `bookstore` 数据库中执行以下SQL语句：
```sql
CREATE TABLE `user` (
`USER_ID` BIGINT(20) NOT NULL AUTO_INCREMENT,
`USERNAME` VARCHAR(50) NOT NULL,
`PASSWORD` VARCHAR(100) NOT NULL,
`SALT` VARCHAR(50) DEFAULT NULL,
`PHONE` VARCHAR(20) DEFAULT NULL,
`ADDRESS` VARCHAR(255) DEFAULT NULL,
PRIMARY KEY (`USER_ID`),
UNIQUE KEY `username_unique` (`USERNAME`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
CREATE TABLE `book` (
`BOOK_ID` INT(32) NOT NULL AUTO_INCREMENT,
`TITLE` VARCHAR(32) NOT NULL,
`AUTHOR` VARCHAR(32) NOT NULL,
`ISBN` VARCHAR(32) NOT NULL UNIQUE,
`PRICE` DOUBLE(10,2) NOT NULL,
PRIMARY KEY (`BOOK_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
CREATE TABLE `cart` (
`CART_ID` INT(32) NOT NULL AUTO_INCREMENT,
`USER_ID` BIGINT(20) NOT NULL,
`BOOK_ID` INT(32) NOT NULL,
`PRICE` DOUBLE(10,2) NOT NULL,
`QUANTITY` INT(10) NOT NULL,
PRIMARY KEY (`CART_ID`),
FOREIGN KEY (`USER_ID`) REFERENCES `user`(`USER_ID`),
FOREIGN KEY (`BOOK_ID`) REFERENCES `book`(`BOOK_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
CREATE TABLE `orders` (
`ORDER_ID` INT(32) NOT NULL AUTO_INCREMENT,
`USER_ID` BIGINT(20) NOT NULL,
`ORDER_TIME` DATETIME NOT NULL,
`CART_ID` INT(32) NOT NULL,
`TOTAL_PRICE` DOUBLE(10,2) NOT NULL,
`PHONE` VARCHAR(20) NOT NULL,
`ADDRESS` VARCHAR(255) NOT NULL,
`STATUS` VARCHAR(32) NOT NULL,
PRIMARY KEY (`ORDER_ID`),
FOREIGN KEY (`USER_ID`) REFERENCES `user`(`USER_ID`),
FOREIGN KEY (`CART_ID`) REFERENCES `cart`(`CART_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
```
#### 5
. 编写代码
1
. **创建实体类**
- 在 `src/main/
java/com/example/bookstore/entity` 目录下创建以下实体类：
- `User
.java`
```
java
package com
.example
.bookstore
.entity;
import lombok
.Data;
@Data
public class User {
private Long userId;
private String username;
private String password;
private String salt;
private String phone;
private String address;
}
```
- `Book
.java`
```
java
package com
.example
.bookstore
.entity;
import lombok
.Data;
@Data
public class Book {
private Integer bookId;
private String title;
private String author;
private String isbn;
private Double price;
}
```
- `Cart
.java`
```
java
package com
.example
.bookstore
.entity;
import lombok
.Data;
@Data
public class Cart {
private Integer cartId;
private Long userId;
private Integer bookId;
private Double price;
private Integer quantity;
}
```
- `Order
.java`
```
java
package com
.example
.bookstore
.entity;
import lombok
.Data;
@Data
public class Order {
private Integer orderId;
private Long userId;
private String orderTime;
private Integer cartId;
private Double totalPrice;
private String phone;
private String address;
private String status;
}
```
2
. **创建Mapper接口**
- 在 `src/main/
java/com/example/bookstore/mapper` 目录下创建以下Mapper接口：
- `UserMapper
.java`
```
java
package com
.example
.bookstore
.mapper;
import com
.example
.bookstore
.entity
.User;
import
org.apache
.ibatis
.annotatio
ns.*;
@Mapper
public interface UserMapper {
@Select("SELECT * FROM user WHERE username = #{username}")
User findByUsername(String username);
@Update("UPDATE user SET photo_path = #{photoPath} WHERE id = #{id}")
int updateUserPhotoPath(User user);
@Select("SELECT * FROM user WHERE phone_number = #{phoneNumber}")
User findByPhoneNumber(String phoneNumber);
}
```
- `BookMapper
.java`
```
java
package com
.example
.bookstore
.mapper;
import com
.example
.bookstore
.entity
.Book;
import
org.apache
.ibatis
.annotatio
ns.Mapper;
import
org.apache
.ibatis
.annotatio
ns.Select;
@Mapper
public interface BookMapper {
@Select("SELECT * FROM book WHERE title LIKE CONCAT('%', #{keyword}, '%') OR author LIKE CONCAT('%', #{keyword}, '%')")
List<Book> searchBooksByKeyword(String keyword);
}
```
3
. **创建Service层**
- 在 `src/main/
java/com/example/bookstore/service` 目录下创建以下Service接口及其实现类：
- `UserService
.java`
```
java
package com
.example
.bookstore
.service;
import com
.example
.bookstore
.entity
.User;
public interface UserService {
User findByUsername(String username);
boolean validatePassword(User user, String inputPassword);
int updateUserPhotoPath(User user);
User findByPhoneNumber(String phoneNumber);
}
```
- `UserServiceImpl
.java`
```
java
package com
.example
.bookstore
.service;
import com
.example
.bookstore
.entity
.User;
import com
.example
.bookstore
.mapper
.UserMapper;
import
org.springframework
.bea
ns.factory
.annotation
.Autowired;
import
org.springframework
.stereotype
.Service;
import
org.springframework
.tra
nsaction
.annotation
.Tra
nsactional;
@Service
@Tra
nsactional
public class UserServiceImpl implements UserService {
@Autowired
private UserMapper userMapper;
@Override
public User findByUsername(String username) {
return userMapper
.findByUsername(username);
}
@Override
public boolean validatePassword(User user, String inputPassword) {
String encryptedInputPassword = DigestUtils
.md5DigestAsHex((inputPassword + user
.getSalt())
.getBytes());
return encryptedInputPassword
.equals(user
.getPassword());
}
@Override
public int updateUserPhotoPath(User user) {
return userMapper
.updateUserPhotoPath(user);
}
@Override
public User findByPhoneNumber(String phoneNumber) {
return userMapper
.findByPhoneNumber(phoneNumber);
}
}
```
4
. **创建Controller层**
- 在 `src/main/
java/com/example/bookstore/controller` 目录下创建以下Controller类：
- `UserController
.java`
```
java
package com
.example
.bookstore
.controller;
import com
.example
.bookstore
.entity
.User;
import com
.example
.bookstore
.service
.UserService;
import
org.springframework
.bea
ns.factory
.annotation
.Autowired;
import
org.springframework
.http.HttpStatus;
import
org.springframework
.http.Respo
nseEntity;
import
org.springframework
.web
.bind
.annotation
.*;
@RestController
@RequestMapping("/user")
public class UserController {
@Autowired
private UserService userService;
@PostMapping("/login")
public Respo
nseEntity<?> login(@RequestBody User user) {
User
foundUser = userService
.findByUsername(user
.getUsername());
if (
foundUser != null && userService
.validatePassword(
foundUser, user
.getPassword())) {
return Respo
nseEntity
.ok(
foundUser);
} else {
return Respo
nseEntity
.status(
HttpStatus
.UNAUTHORIZED)
.body("
Invalid credentials");
}
}
@PostMapping("/register")
public Respo
nseEntity<?> register(@RequestBody User user) {
// Implement registration logic
return Respo
nseEntity
.ok("User registered successfully");
}
}
```
#### 6
. 配置Tomcat
1
. **打开 `Run/Debug Configuratio
ns`**
- 选择 `+`
-> `Tomcat Server`
-> `Local`。
- 配置 `Server` 选项卡，选择 `Tomcat 7
.0`。
- 配置 `Deployment` 选项卡，添加 `Artifact`，选择 `bookstore
:war exploded`。
2
. **启动项目**
- 点击 `Run` 按钮启动项目。
- 打开浏览器，访问 `
http://localhost
:8080/bookstore` 查看效果。
### 总结
通过以上步骤，你可以成功创建一个基于
Java EE的在线图书商城系统项目。项目的结构清晰，采用了Spring、Spring MVC和MyBatis等主流框架，数据库使用MySQL，前端页面使用JSP。希望这些步骤对你有所帮助！如果有任何问题，欢迎随时提问。
扫一扫
4221
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
