使用idea创建java web 项目

使用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>

访问