Java基础入门day65

day65

web项目

页面设计

仿照小米官网，将首页保存到本地为一个html页面，再将html页面保存为jsp页面，在项目中的web.xml文件中配置了欢迎页

<welcome-file-list>
 <welcome-file>TypesServlet</welcome-file>
</welcome-file-list>

package com.saas.servlet;
​
import com.saas.entity.Types;
import com.saas.service.ITypesService;
import com.saas.service.impl.TypesServiceImpl;
​
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;
import java.util.List;
​
@WebServlet("/TypesServlet")
public class TypesServlet extends HttpServlet {
​
 private ITypesService typesService = new TypesServiceImpl();
​
 @Override
 protected void service(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
     List<Types> types = typesService.getAllTypes();
​
     req.setAttribute("types", types);
​
     req.getRequestDispatcher("types.jsp").forward(req, resp);
 }
}

package com.saas.service;
​
import com.saas.entity.Types;
​
import java.util.List;
​
public interface ITypesService {
 List<Types> getAllTypes();
}

package com.saas.service.impl;
​
import com.saas.dao.ITypesDao;
import com.saas.dao.impl.TypesDaoImpl;
import com.saas.entity.Types;
import com.saas.service.ITypesService;
​
import java.util.List;
​
public class TypesServiceImpl implements ITypesService {
​
 private ITypesDao typesDao = new TypesDaoImpl();
​
 @Override
 public List<Types> getAllTypes() {
     return typesDao.getAllTypes();
 }
}

package com.saas.dao;
​
import com.saas.entity.Types;
​
import java.util.List;
​
public interface ITypesDao {
 List<Types> getAllTypes();
}

package com.saas.dao.impl;
​
import com.saas.dao.ITypesDao;
import com.saas.entity.Types;
import com.saas.util.DruidUtil;
import org.apache.commons.dbutils.QueryRunner;
import org.apache.commons.dbutils.handlers.BeanListHandler;
​
import java.sql.SQLException;
import java.util.List;
​
public class TypesDaoImpl implements ITypesDao {
​
 private QueryRunner qr = new QueryRunner(DruidUtil.getDataSource());
​
​
 @Override
 public List<Types> getAllTypes() {
     try {
         return qr.query("select * from types", new BeanListHandler<Types>(Types.class));
     } catch (SQLException e) {
         throw new RuntimeException(e);
     }
 }
}

package com.saas.util;
​
import com.alibaba.druid.pool.DruidDataSource;
import com.alibaba.druid.pool.DruidDataSourceFactory;
​
import javax.sql.DataSource;
​
public class DruidUtil {
​
 private static Env env = Env.getInstance();
​
 public static DataSource getDataSource()
 {
     try {
         DruidDataSource dataSource = (DruidDataSource) DruidDataSourceFactory.createDataSource(env);
​
         dataSource.setUrl(env.getProperty("url"));
         dataSource.setUsername(env.getProperty("user"));
         dataSource.setPassword(env.getProperty("pass"));
         dataSource.setDriverClassName(env.getProperty("driver"));
​
         return dataSource;
     } catch (Exception e) {
         throw new RuntimeException(e);
     }
 }
}

package com.saas.util;
​
import java.io.IOException;
import java.util.Properties;
​
public class Env extends Properties {
​
 private static final long serialVersionUID = 1L;
​
 private static Env env = new Env();
​
 private Env() {
     super();
     try {
         load(getClass().getResourceAsStream("/db.properties"));
     } catch (IOException e) {
         throw new RuntimeException(e);
     }
 }
​
 public static Env getInstance() {
     return env;
 }
​
 public static String get(String key) {
     return env.getProperty(key);
 }
}

driver=com.mysql.jdbc.Driver
url=jdbc:mysql://localhost:3306/mi?characterEncoding=utf-8
user=root
pass=Abc@1234

页面代码

将页面展示出来