JavaWeb_书城项目配置步骤及流程

1.新建Java Enterprise项目，在java下新建相关软件包，并将web项目导入

2.新建数据库表，新建实例，编写数据库连接工具类和数据库关闭连接工具类，测试

package pojo;

public class t_user {
    private int id;
    private String username;
    private String password;
    private String email;

    public t_user() {
    }

    public t_user(int id, String username, String password, String email) {
        this.id = id;
        this.username = username;
        this.password = password;
        this.email = email;
    }

    public int getId() {
        return id;
    }

    public void setId(int id) {
        this.id = id;
    }

    public String getUsername() {
        return username;
    }

    public void setUsername(String username) {
        this.username = username;
    }

    public String getPassword() {
        return password;
    }

    public void setPassword(String password) {
        this.password = password;
    }

    public String getEmail() {
        return email;
    }

    public void setEmail(String email) {
        this.email = email;
    }

    @Override
    public String toString() {
        return "t_user{" +
                "id=" + id +
                ", username='" + username + '\'' +
                ", password='" + password + '\'' +
                ", email='" + email + '\'' +
                '}';
    }
}

public class JDBCUtils {
    /**
     * 数据库连接工具类
     */
    private static DataSource dataSource;
    static {
        try {
            Properties properties=new Properties();
            properties.load(ClassLoader.getSystemClassLoader().getResourceAsStream("jdbc.properties"));
            //properties.load(JDBCUtils.class.getClassLoader().getResourceAsStream("jdbc.properties"));
            System.out.println(properties.getProperty("username"));
            dataSource= DruidDataSourceFactory.createDataSource(properties);
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
    public static Connection getConnection(){
        Connection connection=null;
        try {
            connection = dataSource.getConnection();
        } catch (SQLException throwables) {
            throwables.printStackTrace();
        }
        return connection;
    }

    /**
     * 数据库关闭工具类
     */
    public static  void getConnectionClose(Connection connection){
        if (connection!=null){
            try {
                connection.close();
            } catch (SQLException throwables) {
                throwables.printStackTrace();
            }
        }
    }
}

 driverClassName=com.mysql.jdbc.Driver url=jdbc:mysql://localhost:3306/bookproject?useUnicode=true&characterEncoding=UTF8&serverTimezone=UTC

username=root

password=123456

注：idea2020版本后，在Java Enterprise项目中，在写jdbc.properties时，默认路径不放在src之下，要放到resources目录下，并将resources提升为根路径。不然空指针异常。

流程：https://blog.csdn.net/FoverLove1314/article/details/118991697

步骤：

1.右击resources-->Mark Directory as点击-->Resources Root

2.在 File -->Project Structure–>Modules–>Resources 中找到resources目录-->右击选中Resources-->OK

3.编写通用的增删改和查询语句,用于灵活调用

注：abstract和接口和实现类关系：实现类继承abstract实现接口

public abstract class BaseDao {
    QueryRunner queryRunner=new QueryRunner();

    /**
     * 通用的增、删、改方法
     */
    public int update(String sql,Object ...args){
        Connection connection =