团队作业4——项目冲刺 Day6
团队作业4——项目冲刺 Day6
一、 昨天已完成的工作
用户界面的进一步设计、用户登录的后台进一步完善、数据库的进一步完善。
二、 今天计划完成的工作
用户界面的进一步设计、完成用户登录的后台设计、完成数据库的构建
三、 工作中遇到的困难
暂无
四、 发布项目燃尽图
五、 代码签入
六、 最新模块的代码
package cn.PaChat.Dao.Impl;
import cn.PaChat.Dao.FriendDao;
import cn.PaChat.Dao.function.JDBCUtils;
import cn.PaChat.Entity.User;
import cn.PaChat.Entity.UserFriend;
import org.springframework.jdbc.core.BeanPropertyRowMapper;
import org.springframework.jdbc.core.JdbcTemplate;
import java.util.ArrayList;
import java.util.List;
import java.util.Map;
public class FriendDaoImpl implements FriendDao {
private JdbcTemplate template =
JDBCUtils.getTemplate();
private String insertSQL =
"insert into user_friend values(?,?,?)";
private String deleteSQL =
"delete from user_friend where my_id=? AND friend_id-?";
private String getFriendsSQL =
"select friend_id from user_friend where my_id=?";
@Override
插入方法
public boolean insert(UserFriend
friend) {
if (friend == null) return false;
String friend_id =
friend.getFriend_id();
String my_id = friend.getMy_id();
String note = friend.getNote();
if
(friend_id==null||my_id==null||note==null) return false;
template.update(insertSQL,my_id,friend_id,note);
return true;
}
@Override
//删除方法
public boolean delete(UserFriend
friend) {
if (friend == null) return false;
String friend_id =
friend.getFriend_id();
String my_id = friend.getMy_id();
if (friend_id==null||my_id==null)
return false;
template.update(deleteSQL,my_id,friend_id);
return true;
}
@Override
//获取好友列表
public List<User>
getFriends(String id) {
if (id==null) return null;
List<User> user = new
ArrayList<>();
List<Map<String,
Object>> maps = template.queryForList(getFriendsSQL, id);
for (Map<String, Object> map
: maps) {
String friend_id = (String)
map.get("friend_id");
UserDaoImpl userDao = new
UserDaoImpl();
User search =
userDao.search(friend_id);
user.add(search);
}
return user;
}
}
PersonRecordDaoImpl类
package
cn.PaChat.Dao.Impl;
import cn.PaChat.Dao.PersonRecordDao;
import cn.PaChat.Dao.function.JDBCUtils;
import cn.PaChat.Entity.PersonRecord;
import org.junit.Test;
import org.springframework.jdbc.core.JdbcTemplate;
import java.sql.Timestamp;
import java.util.ArrayList;
import java.util.List;
import java.util.Map;
public class PersonRecordDaoImpl implements PersonRecordDao {
private JdbcTemplate template =
JDBCUtils.getTemplate();
private String insertSQL =
"insert into person_record values(?,?,?,?,?)";
private String deleteSQL =
"delete from person_record where id=?";
private String selectSQL =
"select * from person_record where receiver=?";
@Override
public boolean insert(PersonRecord
record) {
if(record==null) return false;
Timestamp date =
record.getDate();
String id = record.getId();
String message =
record.getMessage();
String receiver =
record.getReceiver();
String sender =
record.getSender();
if(date==null||id==null||message==null||receiver==null||
sender==null) return false;
template.update(insertSQL,id,date,sender,receiver,message);
return true;
}
@Override
public boolean delete(PersonRecord
record) {
if(record==null) return false;
String id = record.getId();
if(id==null) return false;
template.update(deleteSQL,id);
return true;
}
@Override
public List<PersonRecord>
search(String id){
if (id==null) return null;
List<PersonRecord> list =
new ArrayList<>();
List<Map<String,
Object>> maps = template.queryForList(selectSQL, id);
for (Map<String, Object>
map : maps) {
String id1 = (String)
map.get("id");
Timestamp date = (Timestamp)
map.get("date");
String sender = (String)
map.get("sender");
String receiver = (String)
map.get("receiver");
String message = (String)
map.get("message");
PersonRecord pr = new
PersonRecord(id1,date,sender,receiver,message);
list.add(pr);
}
return list;
}
// @Test
// public void search1(){
// List<PersonRecord> search
= search("1");
// System.out.println(search);
// }
}
七、 运行结果的截图
八、 总结
有时刚完成的模块十分粗糙,需要进行一些打磨。