Java培训日记
week 4 day 02
今天是培训班的最后一天,是收工的一天,在经历了昨天的搬迁寝室之后,我将面临最后的答辩挑战。
我模仿着老师的项目,并更新了些新的功能。有点少,个人能力有限。不过这些新功能也算是自己的一点心血吧,在写新功能的时候会碰到一些很难拔的钉子,纠结所花的时间也算是浪费的有点意义,最后搞明白了就好。答辩时有点紧张,听了老师的建议,回来后进行了功能的完善。我个人对于项目中的良好交互有着深深的执著,因为自己之前用的软件交互不好很容易让人抓狂。
我这次写的是电影后台管理系统
以下为我新写的功能代码部分内容:
@Override
public void favouriteMovieType(int id) throws Exception {
//统计你最喜欢的电影种类
Connection conn = db.getConn();
PreparedStatement pstm = null;
ResultSet rs = null;
String sql_selectFavourite = "select id,type,count(*) as counts from tb_Movie group by type desc";
pstm = conn.prepareStatement(sql_selectFavourite);
rs = pstm.executeQuery();
System.out.println("你的电影种类如下:");
System.out.println("电影编号\t\t\t"+"电影类型\t\t\t"+"出现次数");
while (rs.next()){
System.out.println(rs.getInt("id")+"\t\t\t"+rs.getString("type")+"\t\t\t"+rs.getString("counts"));
}
db.closeConn(rs, pstm, conn);
}
@Override
public void searchMovie() throws Exception {
//根据电影类型搜索你喜欢的电影
Connection conn = db.getConn();
PreparedStatement pstm = null;
ResultSet rs = null;
System.out.println("请输入你想要查询的电影类型。");
Scanner scanner = new Scanner(System.in);
String sch = scanner.nextLine();
String sql_searchMovie = "select * from tb_Movie where type = '"+sch+"'";
pstm = conn.prepareStatement(sql_searchMovie);
rs = pstm.executeQuery();
System.out.println("搜索的电影信息如下:");
System.out.println("电影编号\t\t" + "电影名称\t\t\t" + "电影类型");
while(rs.next()){
System.out.println(rs.getInt("id")+"\t\t\t"+rs.getString("name")+"\t\t\t"+rs.getString("type"));
}
db.closeConn(rs, pstm, conn);
}
@Override
public void scoreMovie() throws Exception {
//为你看过的电影打分
Connection conn = db.getConn();
PreparedStatement pstm = null;
ResultSet rs = null;
PreparedStatement pstm1 = null;
String sql_selectAll = "select * from tb_Movie";
pstm = conn.prepareStatement(sql_selectAll);
rs = pstm.executeQuery();
System.out.println("所有电影信息如下:");
System.out.println("电影编号\t\t" + "电影名称\t\t\t" + "电影类型\t\t\t"+ "电影分数");
while(rs.next()){
System.out.println(rs.getInt("id")+"\t\t\t"+rs.getString("name")+"\t\t\t"+rs.getString("type")+"\t\t\t"+rs.getFloat("score"));
}
String sql_scoreMovie = "update tb_Movie set score = ? where id = ?";
Scanner scanner = new Scanner(System.in);
System.out.println("请输入你要打分的电影的编号。");
int id = scanner.nextInt();
System.out.println("请输入你要打的分数。");
float score = scanner.nextFloat();
pstm1.setFloat(1,score);
pstm1.setInt(2,id);
pstm1 = conn.prepareStatement(sql_scoreMovie);
rs=pstm1.executeQuery();
System.out.println("打分成功!");
System.out.println("打分后的信息如下:");
System.out.println("电影编号\t\t" + "电影名称\t\t\t" + "电影类型\\t\\t\\t"+ "电影分数");
while(rs.next()){
System.out.println(rs.getInt("id")+"\t\t\t"+rs.getString("name")+"\t\t\t"+rs.getString("type")+rs.getFloat("score"));
}
db.closeConn(rs, pstm, conn);
}
这些代码并不十分精确完美,希望经过这次培训,在之后的学习中能够将代码写的更好更完美!