江西理工2017校内实训(生产实习)总结报告-java

实习报告学院：江西理工大学商学院专业：软件工程（工程造价）班级：141班学号：14243132 学生：唐诗吟实习类型：□认识实习√生产实习□毕业实习指导教师：胡桂虹实习成绩：时间：2017 年7 月9 日目录前言 (3)一、实习目的 (3)二、实习时间、地点 (3)三、实习单位 (3)四、实习内容 (3)五、实习总结 (21)附录.............................................................................................. 错误！未定义书签。

评语 (3)前言一、实习目的进一步了解JA V A开发的相关知识，掌握java开发的基本技术，丰富java开发的实战经验。

学习MySQL的基础知识及正确的运用方法，通过实习，培养我们综合运用己有知识java语言的面向编程能力；培养我们的动手能力；培养我们良好的编程规范编程方法；增强自己的团队协作意识，了解软件开发的思考角度和主要流程。

二、实习时间、地点时间：2017年 6 月 23 日—2017年 7 月 13 日地点：江西理工大学三教三、实习单位实习单位：江西联微有限公司四、实习内容实习的项目、程序、方法、计算成果及示意图，按实习顺序逐项编写（不少于2000字），二级标题用小三、三级标题用四号，正文小四宋体，1.25倍行距，图标注在图形下方居中五号，表格标题在表格上方居中五号，图形及表格应按需编号，如图1、表1，图形表格内文字宋体五号。

4.1系统需求4.1.1 E-R图4.1.2数据库房间表4.1.3数据库客户表4.1.4数据库会员表4.2 系统实现4.2.1 客户管理功能在房间管理中实现注册会员，删除会员，修改会员。

4.2.1.1 客户管理功能界面设计(1)客户管理主界面显示所有客户信息以及对其做出增删改查和客户的增删改查。

4.2.1.1客户管理主界面(2)新增会员功能新增姓名，身份证，电话，类型点击插入完成会员新增。

4.2.1.2新增客户(3)删除房间功能选中或查询要删除客户，点击删除客户按钮，确认删除选中客户，删除客户完成。

4.2.1.3删除客户(4)会员管理主界面显示所有会员信息以及对其做出增删改查和会员的增删改查。

4.2.1.4会员管理主界面4.2.1.2 客户管理功能持久层Model实现package com.ssy.entity;public class Room {private String Id;private int type;private int flower;private String sate;private int tel;public String getId() {return Id;}public void setId(String id) {Id = id;}public int getType() {return type;}public void setType(int type) {this.type = type;}public int getFlower() {return flower;}public void setFlower(int flower) {this.flower = flower;}public String getSate() {return sate;}public void setSate(String sate) {this.sate = sate;}public int getTel() {return tel;}public void setTel(int tel) {this.tel = tel;}}4.3.1.3 客户管理功能数据访问层DAL实现package com.ssy.dao;import java.util.Vector;import com.ssy.entity.Room;public interface IRoomDao {public int insert(Room room) throws Exception;public Vector<Vector> find(String stateName) throws Exception;public Vector<Vector> find() throws Exception;public Vector<Vector> find(String stateName,String typeName) throws Exception;public int delete(String id) throws Exception;public int openRoom(String id,String roomState) throws Exception;public Vector<Vector> vagueFind(String id) throws Exception;public Vector<Vector> typeFind(String typeName) throws Exception;public Vector<Vector> typeFind() throws Exception;public int update(String id, String floor, String type) throws Exception;}4.2.1.4 客户管理功能业务层BLL实现package .impl;import java.util.List;import java.util.Vector;import .IUserInfoBiz;import com.ssy.dao.IUserInfoDao;import erInfoDaoImpl;import erInfo;public class UserInfoBizImpl implements IUserInfoBiz{IUserInfoDao userdao=new UserInfoDaoImpl();@Overridepublic int insert(UserInfo user) throws Exception {// TODO Auto-generated method stubreturn userdao.insert(user);}@Overridepublic Vector<Vector> seek() throws Exception {// TODO Auto-generated method stubreturn userdao.seek();}@Overridepublic List<UserInfo> login(String username, String password) { // TODO Auto-generated method stubreturn userdao.login(username, password);}@Overridepublic int update(String id, String password){// TODO Auto-generated method stubreturn userdao.update(id, password);}@Overridepublic int delete(String id) {// TODO Auto-generated method stubreturn userdao.delete(id);}@Overridepublic String findPass(String id) {// TODO Auto-generated method stubreturn userdao.findPass(id);}@Overridepublic String findUser(String id) {// TODO Auto-generated method stubreturn userdao.findUser(id);}@Overridepublic Vector<Vector> mfind(String info) {// TODO Auto-generated method stubreturn userdao.mfind(info);}}4.2.1.5 客户管理功能界面实现package com.ssy.dao.impl;import java.util.Vector;import com.ssy.dao.IRoomDao;import com.ssy.dao.MySqlhelper;import com.ssy.entity.Room;import erInfo;public class RoomDaoImpl extends MySqlhelper implements IRoomDao{@Overridepublic int insert(Room room) throws Exception {// TODO Auto-generated method stubint row=0;try {String sql="INSERT INTO tb_room(room_id,room_flower,room_type,room_state,room_tel)VALUES(?,?,?,?,?)";Object[]para={room.getId(),room.getFlower(),room.getType(),room.getSate(),roo m.getTel()};row=this.getUpdate(sql, para);} catch (Exception e) {System.out.println(e.getMessage()+"插入失败");}finally{this.close();}return row;}@Overridepublic Vector<Vector> find(String stateName) throws Exception { // TODO Auto-generated method stubVector<Vector> rooms=new Vector<Vector>();try {String sql="SELECT a.room_id,a.room_flower,b.type_name,a.room_state,a.room_tel FROM tb_room a,tb_type b WHERE a.room_type=b.type_id and a.room_state=? ORDER BY b.type_id DESC,a.room_flower DESC,a.room_id ASC";Object[] para={stateName};System.out.println(stateName);this.getSeek(sql, para);while(rs.next()){String id =rs.getString("room_id");int flower=rs.getInt("room_flower");String type=rs.getString("type_name");String state=rs.getString("room_state");int tel=rs.getInt("room_tel");//定义临时集合对象封装每一行的所有列信息Vector v = new Vector();//往集合中添加数据v.add(id);v.add(flower);v.add(type);v.add(state);v.add(tel);rooms.add(v);}} catch (Exception e) {System.out.println(e.getMessage()+"查询所有失败");// TODO: handle exception}finally{this.close();}return rooms;}@Overridepublic int update(String id,String floor,String type){// TODO Auto-generated method stubString sql="UPDATE tb_room SET room_flower=?,room_type=? WHERE room_id=?";Object[] para={floor,type,id};System.out.println(floor+" "+type+" "+id);int row=0;try {row=this.getUpdate(sql, para);} catch (Exception e) {// TODO Auto-generated catch blocke.printStackTrace();}finally{this.close();}return row;}@Overridepublic int delete(String id) throws Exception {// TODO Auto-generated method stubString sql="DELETE FROM tb_room WHERE room_id=?";Object[] para={id};int row=this.getUpdate(sql, para);return row;}public int openRoom(String id,String roomState) throws Exception{String sql="UPDATE tb_room SET room_state=? WHERE room_id=?";Object[] para={roomState,id};int row=0;try {row=this.getUpdate(sql, para);} catch (Exception e) {// TODO: handle exception}finally{this.close();}return row;}@Overridepublic Vector<Vector> vagueFind(String roomId) throws Exception {// TODO Auto-generated method stubVector<Vector> rooms=new Vector<Vector>();try {String sql="SELECT a.room_id,a.room_flower,b.type_name,a.room_state,a.room_tel FROM tb_room a,tb_type b WHERE a.room_type=b.type_id AND room_id LIKE '%"+roomId+"%' ORDER BY b.type_id DESC,a.room_flower DESC,a.room_id ASC";this.getSeek(sql, null);while(rs.next()){String id =rs.getString("room_id");int flower=rs.getInt("room_flower");String type=rs.getString("type_name");String state=rs.getString("room_state");int tel=rs.getInt("room_tel");//定义临时集合对象封装每一行的所有列信息Vector v = new Vector();//往集合中添加数据v.add(id);v.add(flower);v.add(type);v.add(state);v.add(tel);rooms.add(v);}} catch (Exception e) {System.out.println(e.getMessage()+"查询所有失败");// TODO: handle exception}finally{this.close();}return rooms;}@Overridepublic Vector<Vector> typeFind(String typeName) throws Exception {// TODO Auto-generated method stubVector<Vector> rooms=new Vector<Vector>();try{String sql="SELECT a.room_id,a.room_flower,b.type_name,a.room_state,a.room_tel FROM tb_room a,tb_type b WHERE a.room_type=b.type_id AND b.type_name=? ORDER BY b.type_id DESC,a.room_flower DESC,a.room_id ASC";Object[] para={typeName};this.getSeek(sql, para);while(rs.next()){String id =rs.getString("room_id");int flower=rs.getInt("room_flower");String type=rs.getString("type_name");String state=rs.getString("room_state");int tel=rs.getInt("room_tel");//定义临时集合对象封装每一行的所有列信息Vector v = new Vector();//往集合中添加数据v.add(id);v.add(flower);v.add(type);v.add(state);v.add(tel);rooms.add(v);}} catch (Exception e) {System.out.println(e.getMessage()+"查询所有失败");// TODO: handle exception}finally{this.close();}return rooms;}@Overridepublic Vector<Vector> find() throws Exception {// TODO Auto-generated method stubVector<Vector> rooms=new Vector<Vector>();try {String sql="SELECT a.room_id,a.room_flower,b.type_name,a.room_state,a.room_tel FROM tb_room a,tb_type b WHERE a.room_type=b.type_id ORDER BY b.type_id DESC,a.room_flower DESC,a.room_id ASC";this.getSeek(sql, null);while(rs.next()){String id =rs.getString("room_id");int flower=rs.getInt("room_flower");String type=rs.getString("type_name");String state=rs.getString("room_state");int tel=rs.getInt("room_tel");//定义临时集合对象封装每一行的所有列信息Vector v = new Vector();//往集合中添加数据v.add(id);v.add(flower);v.add(type);v.add(state);v.add(tel);rooms.add(v);}} catch (Exception e) {System.out.println(e.getMessage()+"查询所有失败");// TODO: handle exception}finally{this.close();}return rooms;}@Overridepublic Vector<Vector> typeFind() throws Exception {// TODO Auto-generated method stubVector<Vector> rooms=new Vector<Vector>();try{String sql="SELECT a.room_id,a.room_flower,b.type_name,a.room_state,a.room_tel FROM tb_room a,tb_type b WHERE a.room_type=b.type_id ORDER BY b.type_id DESC,a.room_flower DESC,a.room_id ASC";this.getSeek(sql, null);while(rs.next()){String id =rs.getString("room_id");int flower=rs.getInt("room_flower");String type=rs.getString("type_name");String state=rs.getString("room_state");int tel=rs.getInt("room_tel");//定义临时集合对象封装每一行的所有列信息Vector v = new Vector();//往集合中添加数据v.add(id);v.add(flower);v.add(type);v.add(state);v.add(tel);rooms.add(v);}} catch (Exception e) {System.out.println(e.getMessage()+"查询所有失败");// TODO: handle exception}finally{this.close();}return rooms;}@Overridepublic Vector<Vector> find(String stateName, String typeName) throws Exception {// TODO Auto-generated method stubVector<Vector> rooms=new Vector<Vector>();try {String sql="SELECT a.room_id,a.room_flower,b.type_name,a.room_state,a.room_tel FROM tb_room a,tb_type b WHERE a.room_type=b.type_id and a.room_state=? and b.type_name=? ORDER BY b.type_id DESC,a.room_flower DESC,a.room_id ASC";Object[] para={stateName,typeName};System.out.println(stateName+"-"+typeName);System.out.println(stateName);this.getSeek(sql, para);while(rs.next()){String id =rs.getString("room_id");int flower=rs.getInt("room_flower");String type=rs.getString("type_name");String state=rs.getString("room_state");int tel=rs.getInt("room_tel");//定义临时集合对象封装每一行的所有列信息Vector v = new Vector();//往集合中添加数据v.add(id);v.add(flower);v.add(type);v.add(state);v.add(tel);rooms.add(v);}} catch (Exception e) {System.out.println(e.getMessage()+"查询所有失败");// TODO: handle exception}finally{this.close();}return rooms;}五、实习总结此次只实训了短短的三周。