1.smbms项目架构
2.利用maven进行smbms项目搭建准备工作
1.搭建maven项目环境
2.配置tomcat
3.启动tomcat进行测试能否运行
4.导入环境依赖(jar包)
5.创建项目包结构
6.编写实体类
7.编写基础公共类
8.导入静态资源文件
- 步骤1:
然后可以看到下面这个页面:
*步骤2:*配置tomcat服务器;
tomcat不配置下面一步,可能导致tomcat启动,浏览器页面显示404错误,配置完这一步就完美解决了。
*步骤3:*测试tomcat
*步骤4:*导包
*步骤5:*建立项目所需要的文件
*步骤6:*编写实体类
步骤7:
编写基础公共类:
1.数据库配置文件(resources/db.properties)
driver=com.mysql.jdbc.Driver
url=jdbc:mysql://localhost:3306?useUnicode=true&characterEncoding=utf-8
username=root
password=123456
2.编写数据库的公共类
package com.wang.dao;
import java.io.IOException;
import java.io.InputStream;
import java.sql.*;
import java.util.Properties;
//操作数据库的公共类
public class BaseDao{
private static final String driver;
private static final String url;
private static final String username;
private static final String password;
//静态代码块,类加载的时候就初始化
static{
Properties properties = new Properties();
//通过类加载器读取相应的资源
InputStream resourceAsStream = BaseDao.class.getClassLoader().getResourceAsStream("db.properties");
try {
properties.load(resourceAsStream);
} catch (IOException e) {
e.printStackTrace();
}
driver=properties.getProperty("driver");
url=properties.getProperty("url");
username=properties.getProperty("username");
password=properties.getProperty("password");
}
//获取数据库的链接
public static Connection getConnection() throws ClassNotFoundException, SQLException {
Connection connection=null;
Class.forName(driver);
connection= DriverManager.getConnection(url,username,password);
return connection;
}
//编写查询公共方法
public static ResultSet execute(Connection connection, String sql, Object[] params, PreparedStatement preparedStatement, ResultSet resultSet) throws SQLException {
preparedStatement=connection.prepareStatement(sql);
for(int i=0;i<params.length;i++){
preparedStatement.setObject(i+1,params[i]);
}
resultSet =preparedStatement.executeQuery();
return resultSet;
}
//编写增,删,改公共方法
public static int execute(Connection connection,PreparedStatement preparedStatement,Object[] params ) throws SQLException {
preparedStatement=connection.prepareStatement("sql");
for(int i=0;i<params.length;i++){
preparedStatement.setObject(i+1,params[i]);
}
int updateRows=preparedStatement.executeUpdate();
return updateRows;
}
//释放资源
public static boolean closeResource(Connection connection, PreparedStatement preparedStatement,ResultSet resultSet) throws SQLException {
boolean flag=true;
if(resultSet!=null){
resultSet.close();
resultSet=null;
flag=false;
}
if(preparedStatement!=null){
preparedStatement.close();
preparedStatement=null;
flag=false;
}
if(connection!=null){
connection.close();
connection=null;
flag=false;
}
return flag;
}
}
3.编写字符编码过滤器
package com.wang.filter;
import javax.servlet.*;
import java.io.IOException;
import java.util.logging.LogRecord;
public class CharacterEncodingFilter implements Filter {
@Override
public void init(FilterConfig filterConfig) throws ServletException {
}
@Override
public void doFilter(ServletRequest servletRequest, ServletResponse servletResponse, FilterChain filterChain) throws IOException, ServletException {
servletRequest.setCharacterEncoding("utf-8");
servletResponse.setCharacterEncoding("utf-8");
filterChain.doFilter(servletRequest,servletResponse);
}
@Override
public void destroy() {
}
}
步骤8:
导入静态资源:
到此为止,前期的准备工作已经完成,接下来会对项目进行完善。。。。