【狂神说Java】JavaWeb项目—SMBMS(超市管理项目)

SMBMS(超市管理项目)

数据库：

项目如何搭建？
考虑是不是用maven？ jar包，依赖

搭建项目准备工作

1. 搭建一个maven web 项目

2. 配置Tomcat

3. 测试项目是否能够跑起来

4. 导入项目中需要的jar包;
   jsp，Servlet，mysql驱动jstl，stand…

5. 构建项目包结构
   

6. 编写实体类
   ROM映射:表-类映射

7. 编写基础公共类
   1、 数据库配置文件（mysql5.xx和8.xx的编写有差异）

   driver=com.mysql.jdbc.Driver
   #在和mysql传递数据的过程中，使用unicode编码格式，并且字符集设置为utf-8
   url=jdbc:mysql://127.0.0.1:3306/smbms?useSSL=false&useUnicode=true&characterEncoding=utf-8
   user=root
   password=root
   

   2、编写数据库的公共类

package dao;

import java.io.IOException;
import java.io.InputStream;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Properties;

/**
 * 操作数据库的基类--静态类
 * @author Administrator
 *
 */
public class BaseDao {
   
	
	static{
   //静态代码块,在类加载的时候执行
		init();
	}
	
	private static String driver;
	private static String url;
	private static String user;
	private static String password;
	
	//初始化连接参数,从配置文件里获得
	public static void init(){
   
		Properties params=new Properties();
		String configFile = "database.properties";
		InputStream is=BaseDao.class.getClassLoader().getResourceAsStream(configFile);
		try {
   
			params.load(is);
		} catch (IOException e) {
   
			e.printStackTrace();
		}
		driver=params.getProperty("driver");
		url=params.getProperty("url");
		user=params.getProperty("user");
		password=params.getProperty("password");

	}   
	
	
	/**
	 * 获取数据库连接
	 * @return
	 */
	public static Connection getConnection(){
   
		Connection connection = null;
		try {
   
			Class.forName(driver);
			connection = DriverManager.getConnection(url, user, password);
		} catch (Exception e) {
   
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		
		return connection;
	}
	/**
	 * 查询操作
	 * @param connection
	 * @param pstm
	 * @param rs
	 * @param sql
	 * @param params
	 * @return
	 */
	public static ResultSet execute(Connection connection,PreparedStatement pstm,ResultSet rs,
			String sql,Object[] params) throws Exception{
   
		pstm = connection.prepareStatement(sql);
		for(int i = 0; i < params.length; i++){
   
			pstm.setObject(i+1, params[i]);
		}
		rs = pstm.executeQuery();
		return rs;
	}
	/**
	 * 更新操作
	 * @param connection
	 * @param pstm
	 * @param sql
	 * @param params
	 * @return
	 * @throws Exception
	 */
	public static int execute(Connection connection,PreparedStatement pstm,
			String sql,Object[] params) throws Exception{
   
		int updateRows = 0;
		pstm = connection.prepareStatement(sql);
		for(int i = 0; i < params.length; i++){
   
			pstm.setObject(i+1, params[i]);
		}
		updateRows = pstm.executeUpdate();
		return updateRows;
	}
	
	/**
	 * 释放资源
	 * @param connection
	 * @param pstm
	 * @param rs
	 * @return
	 */
	public static boolean closeResource(Connection connection,PreparedStatement pstm,ResultSet rs){
   
		boolean flag = true;
		if(rs != null){
   
			try {
   
				rs.close();
				rs = null;//GC回收
			} catch (SQLException e) {
   
				// TODO Auto-generated catch block
				e.printStackTrace();
				flag = false;
			}
		}
		if(pstm != null){
   
			try {
   
				pstm.close();
				pstm = null;//GC回收
			} catch (SQLException e) {
   
				// TODO Auto-generated catch block
				e.printStackTrace();
				flag = false;
			}
		}
		if(connection != null){
   
			try {
   
				connection.close();
				connection = null;//GC回收
			} catch (SQLException e) {
   
				// TODO Auto-generated catch block
				e.printStackTrace();
				flag = false;
			}
		}
		
		return flag;
	}

}

3、编写字符编码过滤器

8. 导入静态资源

登录功能实现

1. 编写前端页面
2. 设置首页
   1.设置欢迎首页

  <welcome-file-list>
    <welcome-file>login.jsp</welcome-file>
  </welcome-file-list>

3. 编写dao层登录用户登录的接口

public User getLoginUser(Connection connection, String userCode) throws Exception;

4. 编写dao层接口的实现类

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;

import dao.BaseDao;
import pojo.User;

public class UserDaoImpl implements UserDao{
   
	//持久层只做查询数据库的内容
	public User getLoginUser(Connection connection, String userCode) throws Exception{
   
		//准备三个对象
		PreparedStatement pstm = null;
		ResultSet rs = null;
		User user = null;
		//判断是否连接成功
		if(null != connection){
   
			String sql = "select * from smbms_user where userCode=?";
			Object[] params = {
   userCode};
			rs = BaseDao.execute(connection, pstm, rs, sql, params);
			if(rs.next()){
   
				user = new User();
				user.setId(rs.getInt("id"));
				user.setUserCode(rs.getString("userCode"));
				user.setUserName(rs.getString("userName"));
				user.setUserPassword(rs.getString("userPassword"));
				user.setGender(rs.getInt("gender"));
				user.setBirthday(rs.getDate("birthday"));
				user.setPhone(rs.getString("phone"));
				user.setAddress(rs.getString("address"));
				user.setUserRole(rs.getInt("userRole"));
				user.setCreatedBy(rs.getInt("createdBy"));
				user.setCreationDate(rs.getTimestamp("creationDate"));
				user.setModifyBy(rs.getInt("modifyBy"));
				user.setModifyDate(rs.getTimestamp("modifyDate"));
			}
			BaseDao.closeResource(null, pstm, rs);
		}
		return user;
	}	
}

5. 业务层接口

//用户登录
public User login(String userCode, String userPassword);

6. 业务层实现类

import java.sql.Connection;

//import org.junit.Test;

import dao.BaseDao;
import dao.user.UserDao;
import dao.user.UserDaoImpl;
import pojo.User;