汉语国际网站建设,深圳画册设计公司排行榜,国家企信网官网登录入口,wordpress实用功能目录 1.搭建一个maven web项目 2.配置Tomcat 3.测试项目是否能够跑起来 4.导入项目中会遇到的Jar包 5.项目结构搭建 6.项目实体类搭建 7.编写基础公共类 1.数据库配置文件 2.编写数据库的公共类 3.编写字符编码过滤器 3.1web配置注册 4.导入静态资源 1.搭建一个maven web项目 …
目录 1.搭建一个maven web项目 2.配置Tomcat 3.测试项目是否能够跑起来 4.导入项目中会遇到的Jar包 5.项目结构搭建 6.项目实体类搭建 7.编写基础公共类 1.数据库配置文件 2.编写数据库的公共类 3.编写字符编码过滤器 3.1web配置注册 4.导入静态资源 1.搭建一个maven web项目 2.配置Tomcat 3.测试项目是否能够跑起来 4.导入项目中会遇到的Jar包 jspservletmysql驱动jstlstandard 5.项目结构搭建 6.项目实体类搭建 ORM映射 表---类映射 7.编写基础公共类 1.数据库配置文件 db.properties
drivercom.mysql.jdbc.Driver
urljdbc:mysql//localhost:3306?useUnicodetruecharacterutf-8
usernameroot
password2001 2.编写数据库的公共类
package com.kuang.dao;import java.io.IOException;
import java.io.InputStream;
import java.sql.*;
import java.util.Properties;//操作数据库的公共类
public class BaseDao {private static String driver;private static String username;private static String password;private static String url;//静态代码块类加载的时候就初始化了static {Properties properties new Properties();//通过类加载器读取对应的资源 等价于 Class.forName()也是一个类加载器但这个类加载器是加载配置文件的把配置文件放入输入流中。InputStream is BaseDao.class.getClassLoader().getResourceAsStream(db.properties);try {properties.load(is);} catch (IOException e) {e.printStackTrace();}driverproperties.getProperty(driver);urlproperties.getProperty(url);usernameproperties.getProperty(username);passwordproperties.getProperty(password);}//获取数据库的链接public static Connection getConnection(){Connection connectionnull;try {Class.forName(driver);connectionDriverManager.getConnection(url,username,password);} catch (Exception e) {e.printStackTrace();}return connection;}//编写查询公共方法public static ResultSet execute(Connection connection, String sql, Object[] param, PreparedStatement preparedStatement,ResultSet resultSet){try {preparedStatement connection.prepareStatement(sql);for (int i 0; i param.length ; i) {preparedStatement.setObject(i1,param[i]);}resultSet preparedStatement.executeQuery();} catch (SQLException e) {e.printStackTrace();}return resultSet;}//编写增删改公共方法public static int execute(Connection connection, String sql, Object[] param, PreparedStatement preparedStatement) throws SQLException {preparedStatement connection.prepareStatement(sql);for (int i 0; i param.length ; i) {preparedStatement.setObject(i1,param[i]);}int updateRows preparedStatement.executeUpdate();return updateRows;}//关闭方法public static boolean closeResource(Connection connection,PreparedStatement preparedStatement,ResultSet resultSet){boolean flagtrue;if (resultSet!null){try {resultSet.close();//GC回收resultSetnull;} catch (SQLException e) {e.printStackTrace();flagfalse;}}if (preparedStatement!null){try {preparedStatement.close();preparedStatementnull;} catch (SQLException e) {e.printStackTrace();flagfalse;}}if (connection!null){try {connection.close();connectionnull;} catch (SQLException e) {e.printStackTrace();flagfalse;}}return flag;}}3.编写字符编码过滤器
package com.kuang.filter;import javax.servlet.*;
import java.io.IOException;public class CharacterEncodingFilter implements Filter {Overridepublic void init(FilterConfig filterConfig) throws ServletException {}Overridepublic void doFilter(ServletRequest servletRequest, ServletResponse servletResponse, FilterChain filterChain) throws IOException, ServletException {servletRequest.setCharacterEncoding(utf-8);servletResponse.setCharacterEncoding(utf-8);filterChain.doFilter(servletRequest,servletResponse);}Overridepublic void destroy() {}
}3.1web配置注册 filterfilter-nameCharacterEncodingFilter/filter-namefilter-classcom.kuang.filter.CharacterEncodingFilter/filter-class/filterfilter-mappingfilter-nameCharacterEncodingFilter/filter-nameurl-pattern/*/url-pattern/filter-mapping 4.导入静态资源
