使用idea创建java web 项目
项目下载地址:解压后的 demo02
1、环境准备
开发环境:idea 2020.1.1,jdk 1.8,tomcat9(jdk安装教程)(idea2020.1.1安装教程)(tomcat9)提取码:a6a0
下载相关的依赖(maven中央仓库)或者网盘下载,提取码:pglf
数据库
create database demo;
use demo;
create table user
(
id int auto_increment
primary key,
username varchar(20) null,
gender varchar(1) null,
age int(3) null
);
2、创建项目
选择创建的项目类型,配置tomcat版本
填你Tomcat所在的目录
选择模板创建
选择创建的项目名、位置、Tomcat版本
目录结构及用途如下:
3、编写HelloWorld案例
3.1、简单的helloworld
在这里写上HelloWorld!!
右上角点击更改项目相关部署信息
输入访问地址直接访问即可
localhost:8080/web
3.2、三层架构的HelloWorld
创建如下的目录结构
代码编写
druid.propertites
driverClassName=com.mysql.jdbc.Driver
url=jdbc:mysql:///demo
username=root
password=root
# 初始化连接数量
initialSize=5
# 最大连接数
maxActive=10
# 最大等待时间
maxWait=3000
JDBCUtil
package com.mystery.utils;
import com.alibaba.druid.pool.DruidDataSourceFactory;
import javax.sql.DataSource;
import java.io.IOException;
import java.io.InputStream;
import java.sql.Connection;
import java.sql.SQLException;
import java.util.Properties;
/**
* JDBC工具类 使用Durid连接池
*/
public class JDBCUtil {
/*1、通过静态代码块获取连接池信息*/
private static DataSource dataSource;
static{
try {
/*a.加载配置文件*/
Properties properties = new Properties();
/*将配置文件转换成流*/
InputStream inputStream =JDBCUtil.class.getClassLoader().getResourceAsStream("druid.properties");
/*将流写给Properties对象*/
properties.load(inputStream);
/*b.获取连接池对象*/
dataSource = DruidDataSourceFactory.createDataSource(properties);
} catch (IOException e) {
e.printStackTrace();
} catch (Exception e) {
e.printStackTrace();
}
}
/*2、获取连接池对象*/
public static DataSource getDataSource(){
return dataSource;
}
/*3、获取连接对象*/
public static Connection getConnection() throws SQLException {
return dataSource.getConnection();
}
}
IndexServlet
package com.mystery.controller;
import com.mystery.service.IUserService;
import com.mystery.service.impl.UserServiceImpl;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.io.IOException;
@WebServlet("/hello")
public class IndexServlet extends HttpServlet {
IUserService iUserService = new UserServiceImpl();
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
doPost(request,response);
}
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
request.setCharacterEncoding("utf-8");
System.out.println(iUserService);
String username = iUserService.getUserName(1);
request.setAttribute("username",username);
//转发
request.getRequestDispatcher("/WEB-INF/jsp/index.jsp").forward(request,response);
}
}
IUserService
package com.mystery.service;
public interface IUserService {
/*获取用户名*/
String getUserName(Integer id);
}
UserServiceImpl
package com.mystery.service.impl;
import com.mystery.dao.UserDao;
import com.mystery.service.IUserService;
public class UserServiceImpl implements IUserService {
private UserDao userDao = new UserDao();
/*获取用户名*/
@Override
public String getUserName(Integer id) {
return userDao.getUserName(id);
}
}
UserDao
package com.mystery.dao;
import com.mystery.entity.User;
import com.mystery.utils.JDBCUtil;
import org.springframework.jdbc.core.BeanPropertyRowMapper;
import org.springframework.jdbc.core.JdbcTemplate;
public class UserDao {
/*获取操作数据库的操作对象*/
private JdbcTemplate jdbcTemplate = new JdbcTemplate(JDBCUtil.getDataSource());
/*获取用户名*/
public String getUserName(Integer id) {
String sql = "select username from user where id = ? ";
User user = jdbcTemplate.queryForObject(sql,new BeanPropertyRowMapper<>(User.class),id);
return user.getUsername();
}
}
User
package com.mystery.entity;
public class User {
private Integer id;
private String username;
private String gender;
private Integer age;
public User() {
}
public User(Integer id, String username, String gender, Integer age) {
this.id = id;
this.username = username;
this.gender = gender;
this.age = age;
}
public Integer getId() {
return id;
}
public void setId(Integer id) {
this.id = id;
}
public String getUsername() {
return username;
}
public void setUsername(String username) {
this.username = username;
}
public String getGender() {
return gender;
}
public void setGender(String gender) {
this.gender = gender;
}
public Integer getAge() {
return age;
}
public void setAge(Integer age) {
this.age = age;
}
@Override
public String toString() {
return "User{" +
"id=" + id +
", username='" + username + '\'' +
", gender='" + gender + '\'' +
", age=" + age +
'}';
}
}
index.jsp
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
<title>javaweb</title>
</head>
<body>
${username}
</body>
</html>
访问