(7) 小项目

给个项目的文件排版图片（你可以直接模仿我的结构）

我认真讲每个包的作用，并且给你完整的代码（如果按照我的排版，你不需要更改代码）

Member.java：实体类

　　这个是对应数据库的列，实际上可以说是，通过操作实体类，操作数据库的数据

代码：

package edu.uc.bean;

public class Member implements java.io.Serializable {

    /**
     * 
     */
    private static final long serialVersionUID = 1L;

    private long userId;
    private String userName;
    private String userPass;
    private String nickName;
    private String email;
    private String mobile;
    private String myId;
    private String myIdkey;
    private String regIp;
    private java.util.Date regDate;
    private String lastLoginIp;
    private java.util.Date lastLoginTime;
    private String salt;
    private String secques;
    private String status;
    private String remark;
    private Long sortNum;
    
    
    
    public String getRemark() {
        return remark;
    }
    
    public void setRemark(String remark) {
        this.remark = remark;
    }

    public Long getSortNum() {
        return sortNum;
    }
    public void setSortNum(Long sortNum) {
        this.sortNum = sortNum;
    }

    private Long isDeleted;
    private Long createBy;
    private Long updateBy;
    private java.util.Date createOn;
    private java.util.Date updateOn;
    public long getUserId() {
        return userId;
    }
    public void setUserId(long userId) {
        this.userId = userId;
    }
    public String getUserName() {
        return userName;
    }
    public void setUserName(String userName) {
        this.userName = userName;
    }
    public String getUserPass() {
        return userPass;
    }
    public void setUserPass(String userPass) {
        this.userPass = userPass;
    }
    public String getNickName() {
        return nickName;
    }
    public void setNickName(String nickName) {
        this.nickName = nickName;
    }
    public String getEmail() {
        return email;
    }
    public void setEmail(String email) {
        this.email = email;
    }
    public String getMobile() {
        return mobile;
    }
    public void setMobile(String mobile) {
        this.mobile = mobile;
    }
    public String getMyId() {
        return myId;
    }
    public void setMyId(String myId) {
        this.myId = myId;
    }
    public String getMyIdkey() {
        return myIdkey;
    }
    public void setMyIdkey(String myIdkey) {
        this.myIdkey = myIdkey;
    }
    public String getRegIp() {
        return regIp;
    }
    public void setRegIp(String regIp) {
        this.regIp = regIp;
    }
    public java.util.Date getRegDate() {
        return regDate;
    }
    public void setRegDate(java.util.Date regDate) {
        this.regDate = regDate;
    }
    public String getLastLoginIp() {
        return lastLoginIp;
    }
    public void setLastLoginIp(String lastLoginIp) {
        this.lastLoginIp = lastLoginIp;
    }
    public java.util.Date getLastLoginTime() {
        return lastLoginTime;
    }
    public void setLastLoginTime(java.util.Date lastLoginTime) {
        this.lastLoginTime = lastLoginTime;
    }
    public String getSalt() {
        return salt;
    }
    public void setSalt(String salt) {
        this.salt = salt;
    }
    public String getSecques() {
        return secques;
    }
    public void setSecques(String secques) {
        this.secques = secques;
    }
    public String getStatus() {
        return status;
    }
    public void setStatus(String status) {
        this.status = status;
    }
    public Long getIsDeleted() {
        return isDeleted;
    }
    public void setIsDeleted(Long isDeleted) {
        this.isDeleted = isDeleted;
    }
    public Long getCreateBy() {
        return createBy;
    }
    public void setCreateBy(Long createBy) {
        this.createBy = createBy;
    }
    public Long getUpdateBy() {
        return updateBy;
    }
    public void setUpdateBy(Long updateBy) {
        this.updateBy = updateBy;
    }
    public java.util.Date getCreateOn() {
        return createOn;
    }
    public void setCreateOn(java.util.Date createOn) {
        this.createOn = createOn;
    }
    public java.util.Date getUpdateOn() {
        return updateOn;
    }
    public void setUpdateOn(java.util.Date updateOn) {
        this.updateOn = updateOn;
    }
    
    
    
    
}

 

MemberDao.java: dao层(接口）

　　主要是各各操作的定义，比如你需要一个更新操作，可以update（）方法

代码：

package edu.uc.dao;

import java.util.*;

import edu.uc.bean.Member;

public interface MemberDao {

     Long delete(Long id);//删除操作，返回是Long类型
    
     Member load(Long id);//根据id查询操作
    
     Long update(Member bean);//更新操作，返回Long类型
     
     Long insert(Member bean);//添加操作
     
    
     Member loadByName(String name);//通过名字查询
    
    
     List<Member> list();//输出数据
    
     List<Member> listByName(String name);//通过名字查询，输出数据
    
}

MemberDaoImpl.java:就是实现上面接口里面的方法，具体的实现操作和逻辑

　　里面包括连接数据库的操作和sql语言的查询数据库等

代码：

package edu.uc.dao.impl;
import java.sql.*;
import java.util.*;
import com.liuvei.common.DbFun;
import edu.uc.bean.*;
import edu.uc.dao.*;
import edu.uc.util.*;
public class MemberDaoImpl implements MemberDao {

    public Member load(Long id) {
         Member bean = null;
        // 0.定义变量
        StringBuffer sbSQL = new StringBuffer();
        
         List<Object> paramsList = new ArrayList<Object>();

        // 1.组合SQL
         sbSQL.append(" select * from Member");
         sbSQL.append(" where userId = ?");
         sbSQL.append(" order by userId asc");
         
         // 2.添加参数
         // paramsList.add(id);
         paramsList.add(id);

         // 3.转换类型
         String sql = sbSQL.toString();
         Object[] params = paramsList.toArray();

         Connection conn = null;
         ResultSet rs = null;
         try {
         // 4.取得连接对象
         conn = DbUtil.getConn();

         // 5.执行sql
         rs = DbFun.query(conn, sql, params);

         // 6) 多行转为对象列表
         if (rs.next()) {
         bean = toBean(rs);
         }
         } catch (SQLException e) {
         // TODO: handle exception
         e.printStackTrace();
         throw new RuntimeException(e);
         } finally {


        DbUtil.close(conn);
         }
         return bean;
        }
         
    
 @Override
  public Member loadByName(String name) {
    Member bean = null;
   // 0.定义变量
   StringBuffer sbSQL = new StringBuffer();
    List<Object> paramsList = new ArrayList<Object>();

   // 1.组合SQL
    sbSQL.append(" select * from Member");
    sbSQL.append(" where userName = ?");
    sbSQL.append(" order by userId asc");
   // 2.添加参数
   // paramsList.add(id);
    paramsList.add(name);

   // 3.转换类型
    String sql = sbSQL.toString();
    Object[] params = paramsList.toArray();

    Connection conn = null;
    ResultSet rs = null;
    try {
   // 4.取得连接对象
    conn = DbUtil.getConn();

   // 5.执行sql
    rs = DbFun.query(conn, sql, params);

   // 6. 多行转为对象列表
    if (rs.next()) {
    bean = toBean(rs);
    }
    } catch (SQLException e) {
    // TODO: handle exception
    e.printStackTrace();
    throw new RuntimeException(e);
    } finally {
   DbUtil.close(conn);
    }
    return bean;
   }
 
 
 @Override
 public List<Member> list() {
     // TODO Auto-generated method stub
     List<Member> list = new ArrayList<>();

     // 0.定义变量
     StringBuffer sbSQL = new StringBuffer();
      List<Object> paramsList = new ArrayList<Object>();

     // 1.组合SQL
      sbSQL.append(" select * from Member");
      sbSQL.append(" order by userId asc");
      // 2.添加参数
      // paramsList.add(id);


      // 3.转换类型
      String sql = sbSQL.toString();
      Object[] params = paramsList.toArray();

      Connection conn = null;
      ResultSet rs = null;
      try {
      // 4.取得连接对象
      conn = DbUtil.getConn();

      // 5.执行sql
      rs = DbFun.query(conn, sql, params);

      // 6) 多行转为对象列表
      Member bean = null;
      while (rs.next()) {
      bean = toBean(rs);
      
      list.add(bean);
      }
      } catch (SQLException e) {
      // TODO: handle exception
      e.printStackTrace();
      throw new RuntimeException(e);
      } finally {
     DbUtil.close(conn);
      }
      return list;
 }
 
 @Override
 public List<Member> listByName(String name) {
     // TODO Auto-generated method stub
     List<Member> list = new ArrayList<>();

     // 0.定义变量
     StringBuffer sbSQL = new StringBuffer();
      List<Object> paramsList = new ArrayList<Object>();

     // 1.组合SQL
      sbSQL.append(" select * from Member");
      sbSQL.append(" where userName like ?");
      sbSQL.append(" order by userId asc");
      // 2.添加参数
       paramsList.add("%"+name+"%");


      // 3.转换类型
      String sql = sbSQL.toString();
      Object[] params = paramsList.toArray();

      Connection conn = null;
      ResultSet rs = null;
      try {
      // 4.取得连接对象
      conn = DbUtil.getConn();

      // 5.执行sql
      rs = DbFun.query(conn, sql, params);

      // 6) 多行转为对象列表
      Member bean = null;
      while (rs.next()) {
      bean = toBean(rs);
      
      list.add(bean);
      }
      } catch (SQLException e) {
      // TODO: handle exception
      e.printStackTrace();
      throw new RuntimeException(e);
      } finally {
     DbUtil.close(conn);
      }
      return list;
 }
 
 
 
 private Member toBean(ResultSet rs) {
 Member bean = new Member();
 try {
 bean.setUserId(rs.getLong("userId"));
 bean.setUserName(rs.getString("userName"));

 bean.setUserPass(rs.getString("userPass"));
 bean.setNickName(rs.getString("nickName"));
 bean.setEmail(rs.getString("email"));
 bean.setMobile(rs.getString("Mobile"));

 bean.setMyId(rs.getString("myId"));
 bean.setMyIdkey(rs.getString("myIdKey"));
 bean.setRegIp(rs.getString("regIp"));
 bean.setRegDate(rs.getDate("regDate"));

 bean.setLastLoginIp(rs.getString("lastLoginIp"));
 bean.setLastLoginTime(rs.getDate("lastLoginTime"));
 bean.setSalt(rs.getString("salt"));
 bean.setSecques(rs.getString("secques"));

 bean.setRemark(rs.getString("remark"));
 bean.setSortNum(rs.getLong("sortNum"));
 bean.setStatus(rs.getString("status"));
 bean.setIsDeleted(rs.getLong("isDeleted"));

 bean.setCreateBy(rs.getLong("createBy"));
 bean.setUpdateBy(rs.getLong("updateBy"));
 bean.setCreateOn(rs.getDate("createOn"));
 bean.setUpdateOn(rs.getDate("updateOn"));

 } catch (SQLException e) {
 // TODO Auto-generated catch block
 e.printStackTrace();

 throw new RuntimeException(e);
 }
 return bean;
 }


@Override
public Long insert(Member bean) {
    // TODO Auto-generated method stub
    Long result = 0L;
    // 0.定义变量
    StringBuffer sbSQL = new StringBuffer();
    List<Object> paramsList = new ArrayList<Object>();

    // 1.组合SQL
     sbSQL.append(" Insert Into Member");
     sbSQL.append(" (");
     sbSQL.append(" userName,userPass,nickName,email");
     sbSQL.append(" ,myId,myIdKey,regIp,regDate");
     sbSQL.append(" ,lastLoginIp,lastLoginTime,salt,secques");
     sbSQL.append(" ,remark,sortNum,status,isDeleted");
     sbSQL.append(" ,createBy,updateBy,createOn,updateOn");
     sbSQL.append(" )");
     sbSQL.append(" values(?,?,?,? ,?,?,?,? ,?,?,?,? ,?,?,?,? ,?,?,?,?)");
     // 2.添加参数
     paramsList.add(bean.getUserName());
     paramsList.add(bean.getUserPass());
     paramsList.add(bean.getNickName());
     paramsList.add(bean.getEmail());
     
     paramsList.add(bean.getMyId());
     paramsList.add(bean.getMyIdkey());
     paramsList.add(bean.getRegIp());
     paramsList.add(bean.getRegDate());
     
     paramsList.add(bean.getLastLoginIp());
     paramsList.add(bean.getLastLoginTime());
     paramsList.add(bean.getSalt());
     paramsList.add(bean.getSecques());
     
     paramsList.add(bean.getRemark());
     paramsList.add(bean.getSortNum());
     paramsList.add(bean.getStatus());
     paramsList.add(bean.getIsDeleted());
     
     paramsList.add(bean.getCreateBy());
     paramsList.add(bean.getUpdateBy());
     paramsList.add(bean.getCreateOn());
     paramsList.add(bean.getUpdateOn());
     // 3.转换类型
     String sql = sbSQL.toString();
     Object[] params = paramsList.toArray();

     Connection conn = null;

     try {
     // 4.取得连接对象
     conn = DbUtil.getConn();

     // 5.执行sql
     result = DbFun.update(conn, sql, params);

     
     } catch (Exception e) {
     // TODO: handle exception
     e.printStackTrace();
     throw new RuntimeException(e);
     } finally {


    DbUtil.close(conn);
     }
     return result;
    
}
 

@Override
public Long update(Member bean) {
    // TODO Auto-generated method stub
    Long result = 0L;
    // 0.定义变量
    StringBuffer sbSQL = new StringBuffer();
    List<Object> paramsList = new ArrayList<Object>();

    // 1.组合SQL
     sbSQL.append(" Update Member ");
     sbSQL.append(" set");
     sbSQL.append(" userName=?,userPass=?,nickName=?,email=?");
     sbSQL.append(" ,myId=?,myIdKey=?,regIp=?,regDate=?");
     sbSQL.append(" ,lastLoginIp=?,lastLoginTime=?,salt=?,secques=?");
     sbSQL.append(" ,remark=?,sortNum=?,status=?,isDeleted=?");
     sbSQL.append(" ,createBy=?,updateBy=?,createOn=?,updateOn=?");
     sbSQL.append(" where userId=?");
     // 2.添加参数
     paramsList.add(bean.getUserName());
     paramsList.add(bean.getUserPass());
     paramsList.add(bean.getNickName());
     paramsList.add(bean.getEmail());
     
     paramsList.add(bean.getMyId());
     paramsList.add(bean.getMyIdkey());
     paramsList.add(bean.getRegIp());
     paramsList.add(bean.getRegDate());
     
     paramsList.add(bean.getLastLoginIp());
     paramsList.add(bean.getLastLoginTime());
     paramsList.add(bean.getSalt());
     paramsList.add(bean.getSecques());
     
     paramsList.add(bean.getRemark());
     paramsList.add(bean.getSortNum());
     paramsList.add(bean.getStatus());
     paramsList.add(bean.getIsDeleted());
     
     paramsList.add(bean.getCreateBy());
     paramsList.add(bean.getUpdateBy());
     paramsList.add(bean.getCreateOn());
     paramsList.add(bean.getUpdateOn());
     
     paramsList.add(bean.getUserId());
     // 3.转换类型
     String sql = sbSQL.toString();
     Object[] params = paramsList.toArray();

     Connection conn = null;

     try {
     // 4.取得连接对象
     conn = DbUtil.getConn();

     // 5.执行sql
     result = DbFun.update(conn, sql, params);

     
     } catch (Exception e) {
     // TODO: handle exception
     e.printStackTrace();
     throw new RuntimeException(e);
     } finally {


    DbUtil.close(conn);
     }
     return result;
}

@Override
public Long delete(Long id) {
    // TODO Auto-generated method stub
    Long result = 0L;
    // 0.定义变量
    StringBuffer sbSQL = new StringBuffer();
    List<Object> paramsList = new ArrayList<Object>();

    // 1.组合SQL
     sbSQL.append(" Delete From Member ");
     sbSQL.append(" where userId=?");
     // 2.添加参数
     paramsList.add(id);
     // 3.转换类型
     String sql = sbSQL.toString();
     Object[] params = paramsList.toArray();

     Connection conn = null;

     try {
     // 4.取得连接对象
     conn = DbUtil.getConn();

     // 5.执行sql
     result = DbFun.update(conn, sql, params);

     
     } catch (Exception e) {
     // TODO: handle exception
     e.printStackTrace();
     throw new RuntimeException(e);
     } finally {


    DbUtil.close(conn);
     }
     return result;
    
}
}

MemberService.java

　　可以看做高一层的dao层

代码：

package edu.uc.service;

import java.util.List;

import edu.uc.bean.Member;

public interface MemberService {
    
    Long delete(Long id);
    
     Member load(Long id);
    
     Long update(Member bean);
     
     Long insert(Member bean);
    
     Member loadByName(String name);
     
     List<Member> list();
    
     List<Member> listByName(String name);
    
}

MemberServiceImpl

　　通过调用dao层实现操作的组合

代码：

package edu.uc.service.impl;

import java.util.List;

import edu.uc.bean.Member;
import edu.uc.dao.MemberDao;
import edu.uc.dao.impl.MemberDaoImpl;
import edu.uc.service.MemberService;

public class MemberServiceImpl implements MemberService{
    
    
    private MemberDao memberDao = new MemberDaoImpl();

    @Override
    public Member loadByName(String name) {
        // TODO Auto-generated method stub
        return memberDao.loadByName(name);
    }

    @Override
    public List<Member> list() {
        // TODO Auto-generated method stub
        return memberDao.list();
    }

    @Override
    public List<Member> listByName(String name) {
        // TODO Auto-generated method stub
        return memberDao.listByName(name);
    }

    @Override
    public Long insert(Member bean) {
        // TODO Auto-generated method stub
        return memberDao.insert(bean);
    }

    @Override
    public Member load(Long id) {
        // TODO Auto-generated method stub
        return memberDao.load(id);
    }

    @Override
    public Long update(Member bean) {
        // TODO Auto-generated method stub
        return memberDao.update(bean);
    }

    @Override
    public Long delete(Long id) {
        // TODO Auto-generated method stub
        return memberDao.delete(id);
    }

}

上面的是实现底层的操作基本好了，明天实现的是界面

我现在给你个视频，关于我项目运行的演示：

 难搞由于不会，所以对不起了各位，有问题可以说，