自动构建工具

Ant + Ivy / Maven / Gradle

数据库连接池

server.xml配置

<Resource 
                        name="jdbc/hr" auth="Container"
                        type="javax.sql.DataSource"
                        factory="org.apache.tomcat.jdbc.pool.DataSourceFactory" 
                        MaxIdle="10" maxActive="100" maxWait="5000"
                        username="root" password="123456"
                        driverClassName="com.mysql.jdbc.Driver"
                        url="jdbc:mysql://localhost:3306/hr?useUnicode=true&characterEncoding=utf-8"
                        />

数据库配置类

    private static DataSource dataSource = null;
    
    static {
        try {
            Context ctx = new InitialContext();
            dataSource = (DataSource) ctx.lookup("java:comp/env/jdbc/house");
        } catch (NamingException e) {
            e.printStackTrace();
        }
    }
    
    private DbConfig() {
        throw new AssertionError();
    }
    
    public static Connection getConnection() {
        try {
            return dataSource.getConnection();
        } catch (SQLException e) {
            throw new DbException("创建数据库连接失败", e);
        }
    }