房屋中介管理系统设计说明书

题目:课程:院（部）:专业:班级:学生学号:建筑大学计算机科学与技术学院程序设计实用案例选讲大作业说明书房地产中介管理系统程序设计实用案例选讲计算机科学与技术网络工程网络131高雷指导教师:完成日期:袁卫华2014/01/08错误!未定义书签。111232230331房地产中介管理系统一、问题描述二、设计思想三、系统结构四、程序流程（或模块划分）五、源程序六、系统测试及操作界面结论参考文献房地产中介管理系统一、问题描述某房屋中介公司主要的业务包括房屋出租和二手房买卖，请编程实现“房屋中介管理系统”，具体要求如下：一、房源基本信息管理，（房屋编号，户型（如两室一厅，三室两厅），具体地址（坐落位置）， 建造年月，状态（待售，待出租，已售，已出租等），价格（租金/月或售价），房主，联系方 式等），请编程实现这些基本信息的增、删、改、查等操作。二、 房屋出租操作，对于所有“待出租”状态的房屋，可以执行出租操作，其状态转换为“已 出租”，根据出租的月数，计算租金，并征收中介费（中介费一般等于一个月的租金）；处于“已出租” 状态的房屋不能执行该操作。三、房屋出售操作，对于所有“待出售”状态的房屋，可以执行出手操作，其状态转换为“已售”，根据房价和中介费计算方法（自己查），计算应该征收的中介费二、设计思想此管理系统主要实现对房源的增删改查四个主要功能，以及将数据输出保存文件。本系 统分为管理员和普通用户两个类别用户，管理员可以对房源信息的增删改查等操作，普通用 户无法更改信息，可以查询信息。另外，针对大量的用户，可以注册新的用户。管理员在添 加新的房源信息时需要确保输入每一个信息，否则会提醒管理员输入完整。修改信息可以修 改一个信息，也可以同时修改多个信息，修改成功会依次提示。查询时主要可以通过查询户 型以及房屋状态查询。用户查询到需要的房源时通过管理员修改房源信息，并将房屋的状态 改变出租或出售给用户。三、系统结构房地产管理系统包括7个主要类：BuildingSystem.Java :主操作界面，登录界面、选择用户类型等信息Admin.java管理员登录界面Admin1.java管理员操作界面RegisterExceptio n.java用于两次密码不一致时抛异常User.java普通用户登录界面User1.java普通用户操作界面ZhuCe.java新用户注册四、程序流程（或模块划分）图4-1程序流程图五、源程序Buildi ngStystempackage gaolei;public class Build in gSystem impleme nts Runn able,Act ion Liste ner JFrame f1;JPanel p1, p2,p3,p4;JLabel l21;JButt on fun cti on1, function2, function3, fun cti on4;JButt on end;Thread scollWorsThread;boolea n stopScorlli ng;Buildi ngSystem() f1 = new JFrame(-房屋中介管理系统-);p1 = new JPa nel();p1.setBackgro un d(Color.white);p1.setLayout (new GridLayout(5, 1, 5, 5);fun ctio n1 = new JButt on (”【管理员登录通道】”)；p1.add(fu nction 1);fun ctio n1.setBackgrou nd(Color.getHSBColor(100, 152, 188);function 1.addAct ion Liste ner(this);fun ctio n2 = new JButto n(”【普通用户登陆通道】”)；fun ctio n2.setBackgrou nd(Color.getHSBColor(100, 152, 188);p1.add(fu nctio n2);fun ctio n2.addActio nListe ner(this);fun ctio n3 = new JButto n(”【新用户注册】”)；p1.add(fu nctio n3);fun ctio n3.setBackgrou nd(Color.getHSBColor(100, 152, 188);fun ctio n3.addActio nListe ner(this);fun ctio n4 = new JButto n(”【系统信息】”)；p1.add(fu nction 4);fun ctio n4.setBackgrou nd(Color.getHSBColor(100, 152, 188);fun ctio n4.addActio nListe ner(this);end = new JButton(”【退出 程序】 ”)；p1.add(e nd);en d.setBackgrou nd(Color.getHSBColor(100, 152, 188);en d.addAct ion Liste ner(this);f1.add(BorderLayout.EAST, p1);p2 = new JPa nel();p2.setBackgrou nd(Color.getHSBColor(100, 10,255);p2.setLayout(new GridLayout(3, 1);JLabel empty1 = new JLabel();p2.add(empty1);l21 = new JLabel(高雷房地产公司欢迎您O(Q _n )O );l21.setForegrou nd(Color.DARK_GRAY);l21.setFont(new Font(”华文行楷,1,17);p2.add(l21);JLabel empty2 = new JLabel();p2.add(empty2);f1.add(BorderLayout.NORTH, p2);p3 = new JPa nel()private static final long serialVersionUID = 1L;public void pain t(Graphics g)ImageIc on icon=new ImageIc on (F:Java in formati on 12.p ng);Image image=ic on. getImage();g.drawImage(image, 0,0, n ull);p3.setBackgro un d(Color.white);JLabel nn = new JLabel();p3.add( nn);f1.add(BorderLayout.SOUTH, p3);p4 = new JPa nel()private static final long serialVersionUID = 1L;public void pain t(Graphics g)ImageIc on icon=new ImageIc on (F:Java in formati on 12.p ng);Image image=ic on. getImage();g.drawImage(image, 0,0, n ull); ;p4.setBackgro un d(Color.white);f1.add(BorderLayout.CENTER, p4);scollWorsThread = new Thread(this);scollWorsThread.start();f1.setResizable(false);f1.setSize(470, 285);f1.setVisible(true);f1.setLocatio n(400,);f1.setDefaultCloseOperati on (JFrame.EXIT_ON_CLOSE);public void run() while (true) int x = l21.getBou nds().x;int y = l21.getBou nds().y;x += 5;l21.setLocati on(x, y);if (x 420) x = 0;l21.setLocation(x, y);try Thread.sleep(1000); catch (In terruptedExcepti on e) if (stopScorlli ng = true) return;public void action Performed(Act ion Eve nt e)try if (e.getSource() = function new Admi n(); else if (e.getSource() = fun cti on2) new User(); else if (e.getSource() = fun cti on3) new ZhuCe(); else if (e.getSource() = fun cti on4) JOptionPane.showMessageDialog(null, this,系统简介,3); else if (e.getSource() = end) System.exit(1); catch (Exceptio n e1) e1.pri ntStackTrace();public static void main(String args) throws Exceptionnew Buildi ngSystem();Adminpackage gaolei;public class Build in gSystem impleme nts Runn able,Act ion Liste ner JFrame f1;JPanel p1, p2,p3,p4;JLabel l21;JButt on fun cti on1, function2, function3, fun cti on4;JButt on end;Thread scollWorsThread;boolea n stopScorlli ng;Buildi ngSystem() f1 = new JFrame(- 房屋中介管理系统-);p1 = new JPa nel();p1.setBackgro un d(Color.white);p1.setLayout (new GridLayout(5, 1, 5, 5);fun ctio n1 = new JButt on (”【管理员登录通道】 ”)；p1.add(fu nction 1);fun ctio n1.setBackgrou nd(Color.getHSBColor(100, 152, 188);function 1.addAct ion Liste ner(this);fun ctio n2 = new JButto n(”【普通用户登陆通道】”)；fun ctio n2.setBackgrou nd(Color.getHSBColor(100, 152, 188);p1.add(fu nctio n2);fun ctio n2.addActio nListe ner(this);fun ctio n3 = new JButto n(”【新用户注册】”)；p1.add(fu nctio n3);fun ctio n3.setBackgrou nd(Color.getHSBColor(100, 152, 188);fun ctio n3.addActio nListe ner(this);fun ctio n4 = new JButto n(”【系统信息】”)；p1.add(fu nction 4);fun ctio n4.setBackgrou nd(Color.getHSBColor(100, 152, 188);fun ctio n4.addActio nListe ner(this);end = new JButton(”【退出 程序】 ”)；p1.add(e nd);en d.setBackgrou nd(Color.getHSBColor(100, 152, 188);en d.addAct ion Liste ner(this);f1.add(BorderLayout.EAST, p1);p2 = new JPa nel();p2.setBackgrou nd(Color.getHSBColor(100, 10,255);p2.setLayout(new GridLayout(3, 1);JLabel empty1 = new JLabel();p2.add(empty1);l21 = new JLabel(高雷房地产公司欢迎您O(Q _n )O );l21.setForegrou nd(Color.DARK_GRAY);l21.setFont(new Font(华文行楷,1,17);p2.add(l21);JLabel empty2 = new JLabel();p2.add(empty2);f1.add(BorderLayout.NORTH, p2);p3 = new JPa nel()private static final long serialVersionUID = 1L;public void pain t(Graphics g)ImageIc on icon=new ImageIc on (F:Java in formati on 12.p ng); Image image=ic on. getImage();g.drawImage(image, 0,0, n ull); ;p3.setBackgro un d(Color.white);JLabel nn = new JLabel();p3.add( nn);f1.add(BorderLayout.SOUTH, p3);p4 = new JPa nel()private static final long serialVersionUID = 1L;public void pain t(Graphics g)ImageIc on icon=new ImageIc on (F:Java in formati on 12.p ng); Image image=ic on. getImage();g.drawImage(image, 0,0, n ull);p4.setBackgro un d(Color.white);f1.add(BorderLayout.CENTER, p4)scollWorsThread = new Thread(this);scollWorsThread.start();f1.setResizable(false);f1.setSize(470, 285);f1.setVisible(true);f1.setLocatio n(400,);fl.setDefaultCloseOperati on (JFrame.EXIT_ON_CLOSE);public void run() while (true) int x = l21.getBou nds().x;int y = l21.getBou nds().y;x += 5;l21.setLocati on(x, y);if (x 420) x = 0;l21.setLocation(x, y);try Thread.sleep(IOOO); catch (In terruptedExcepti on e) if (stopScorlli ng = true) return;public void action Performed(Act ion Eve nt e)try if (e.getSource() = function new Admi n(); else if (e.getSource() = fun cti on2) new User(); else if (e.getSource() = fun cti on3) new ZhuCe(); else if (e.getSource() = fun cti on4) 系统简介,3);JOpti onPan e.showMessageDialog( null, this, else if (e.getSource() = end) System.exit(l); catch (Exceptio n e1) el.pri ntStackTrace();public static void main(String args) throws Exceptionnew Buildi ngSystem();Admi n1package gaolei;public class Admi n1 exte nds JFrame impleme nts Actio nListe nerJFrame f;JLabel jl,j2,j3,j4,j5,j6,j7,j8;JTextField jf1,jf2,jf3,jf4,jf5,jf6,jf7,jf8;JButton jb1,jb2,jb3,jb4,jb5,jb6,jb7,jb8;JPa nel jp1;int id;int m=0;JTextArea result;Stri ng DBDriver=s un .jdbc.odbc.JdbcOdbcDriver;Stri ng conn ectio nStr=jdbc:odbc:Housel nfo1;Stateme nt stmt=n ull,s仁 null;Connection con=n ull;ResultSet rs=null;PreparedStateme nt stmt仁 null,stmt2=n ull,stmt3=n ull,stmt4=n ull; public Admi n1() f = new JFrame(” 房源基本信息”)；jp1= new JPa nel();jp1.setLayout (new GridLayout(5, 2);jl=new JLabel(j2=new JLabel(j3=new JLabel(j4=new JLabel(j5=new JLabel(j6=new JLabel(j7=new JLabel(j8=new JLabel(编号：”)； 房主：”)； 联系方式： 坐落位置： 建造年月： 价格：); 户型);房屋状态););););jf仁new JTextField(10);jf2=new JTextField(10);jf3=new JTextField(10);jf4=new JTextField(10);jf5=new JTextField(10);jf6=new JTextField(10);jf7=new JTextField(10);jf8=new JTextField(10);jb1= new JButto n(”jb2=new JButto n(”jb3=new JButton(jb4=new JButto n(”jp1.add(jl);jp1.add(jf1);jp1.add(j2);jp1.add(jf2);jp1.add(j3);jp1.add(jf3);jp1.add(j4);jp1.add(jf4);jp1.add(j5);jp1.add(jf5);jp1.add(j6);jp1.add(jf6);jp1.add(j7);jp1.add(jf7);录入”); 修改); 删除); 查询);jp1.add(j8);jp1.add(jf8);jpl.add(jbl);jp1.add(jb2);jp1.add(jb3);jp1.add(jb4);jbl.addAct ion Liste ner(this);jb2.addAct ion Liste ner(this);jb3.addAct ion Liste ner(this);jb4.addAct ion Liste ner(this);f.add(BorderLayout.NORTH, jp1);result = new JTextArea(60, 100);result.setEditable(false);JScrollPa ne jScrollPa ne=new JScrollPa ne(result);f.add(BorderLayout.CENTER, jScrollPa ne);f.setSize(500, 600);f.setLocati on(600, 80);f.setVisible(true);f.validate();public void in sert()int m=0;tryClass.forName(DBDriver);/加载驱动器表达式catch(ClassNotFo un dException e1)e1.pri ntStackTrace();Stri ng id=jf1.getText();Stri ng n ame=jf2.getText();Stri ng tel=jf3.getText();String loc=jf4.getText();Stri ng riqi=jf5.getText();Stri ng price=jf6.getText();Stri ng type=jf7.getText();Stri ng zt=jf8.getText();if(!id.equals()&!n ame.equals() & !tel.equals()&!loc.equals()&! riqi.equals()&!price.equals() & !type.equals()&!zt.equals()trycon=DriverMa nager.getCo nn ectio n(conn ectio nStr,);/建立数据库连接valuesStri ng sql仁INSERT INTOhouse(id, name,tel,loc,riqi,price,type,zt)(? ?);PreparedStateme nt stmt仁c on .prepareStateme nt(sql1);stmt1.setStri ng(1,id);stmt1.setStri ng(2 ,n ame);stmt1.setStri ng(3,tel);stmt1.setStri ng(4,loc);stmt1.setStri ng(5,riqi);stmt1.setStri ng(6,price);stmtl.setStri ng(7,type);stmtl.setStri ng(8,zt);stmt1.execute();stmt1.close();con. close();m=1;catch (SQLException e1) el.pri ntStackTrace();if(m=1)JOptio nPa ne.showMessageDialog(this,信息已经成功录入”)；if(m=0)JOptio nPa ne.showMessageDialog(this,您输入的不符合要求);public void xiugai()tryClass.forName(DBDriver);/加载驱动器表达式catch(ClassNotFou ndException e1)e1.pri ntStackTrace(); int n=0;Stri ng id=jf1.getText();Stri ng n ame=jf2.getText();Stri ng tel=jf3.getText();String loc=jf4.getText();Stri ng riqi=jf5.getText();Stri ng price=jf6.getText();Stri ng type=jf7.getText();Stri ng zt=jf8.getText();if(!id.equals()trycon=DriverMa nager.getCo nn ectio n(conn ectio nStr,);/建立数据库连接if(! name.equals()String sql2=Update house set name=? where id=?;stmt仁c on. prepareStateme nt(sql2);stmt1.setStri ng(2,id);stmt1.setStri ng(1, name);stmt1.execute();JOptio nPa ne.showMessageDialog(this,房主已经成功修改”)；if(!tel.equals()String sql3=Update house set tel=? where id=?;stmt仁c on. prepareStateme nt(sql3);stmt1.setStri ng(2,id);stmt1.setStri ng(1,tel);stmt1.execute();stmt1.close();JOptio nPa ne.showMessageDialog(this,联系方式已经成功修改”)；if(!loc.equals()String sql3=Update house set loc=? where id=?;stmt仁c on .prepareStateme nt(sql3);stmt1.setStri ng(2,id);stmt1.setStri ng(1,loc);stmt1.execute();stmt1.close();JOptio nPa ne.showMessageDialog(this,坐落位置已经成功修改);if(!riqi.equals()String sql3=Update house set riqi=? where id=?;stmt仁c on. prepareStateme nt(sql3);stmt1.setStri ng(2,id);stmt1.setStri ng(1,riqi);stmt1.execute();stmt1.close();JOptio nPan e.showMessageDialog(this,建造日期已经成功修改”)；if(!price.equals()String sql3=Update house set price=? where id=?;stmt仁c on. prepareStateme nt(sql3);stmt1.setStri ng(2,id);stmt1.setStri ng(1,price);stmt1.execute();stmt1.close();JOptionPane.showMessageDialog(this,价格已经成功修改”)；if(!type.equals()String sql3=Update house set type=? where id=?;stmt仁c on. prepareStateme nt(sql3);stmt1.setStri ng(2,id);stmt1.setStri ng(1,type);stmt1.execute();stmt1.close();JOptionPane.showMessageDialog(this,户型已经成功修改”)；if(!zt.equals()String sql3=Update house set zt=? where id=?;stmt仁c on. prepareStateme nt(sql3);stmt1.setStri ng(2,id);stmt1.setStri ng(1,zt);stmt1.execute();stmt1.close();JOptio nPan e.showMessageDialog(this,房屋状态已经成功修改”)；con. close();n=1;catch (SQLException e1) / TODO Auto-ge nerated catch blocke1.pri ntStackTrace();if(n=0)JOptio nPa ne.showMessageDialog(this,您输入的不符合要求”)；public void delete()int n=0;tryClass.forName(DBDriver);/加载驱动器表达式catch(ClassNotFo un dException e1)e1.pri ntStackTrace();Stri ng id=jf1.getText();Stri ng n ame=jf2.getText();Stri ng tel=jf3.getText();String loc=jf4.getText();Stri ng riqi=jf5.getText();Stri ng price=jf6.getText();Stri ng type=jf7.getText();Stri ng zt=jf8.getText();if(!id.equals()|! name.equals()|!tel.equals()|!loc.equals()|!riqi.equals()|!price.equals()|!type.equals()|!zt.equals()trycon=DriverMa nager.getCo nn ectio n(conn ectio nStr,);/建立数据库连接Stri ng sql2=delete from house where id=?;stmt仁c on. prepareStateme nt(sql2);stmt1.setStri ng(1,id);stmt1.execute();stmt1.close();con. close();n=1;catch (SQLException e1) / TODO Auto-ge nerated catch blocke1.pri ntStackTrace();if(n=1)JOptio nPa ne.showMessageDialog(this,信息已经成功删除 ”)；if(n=0)JOptio nPa ne.showMessageDialog(this,对不起，您输入的信息有误，未成功删除。); public void search()int n=0;tryClass.forName(DBDriver);/加载驱动器表达式catch(ClassNotFo un dException e1)el.pri ntStackTrace();Stri ng id=jf1.getText();Stri ng n ame=jf2.getText();Stri ng tel=jf3.getText();String loc=jf4.getText();Stri ng riqi=jf5.getText();Stri ng price=jf6.getText();Stri ng type=jf7.getText();Stri ngzt=jf8.getText();if(!id.equals()|! name.equals()|!tel.equals()|!loc.equals()|!riqi.equals()|!price.equals()|!type.equals()|!zt.equals()trycon=DriverMa nager.getCo nn ectio n(conn ectio nStr,);/建立数据库连接Stateme nt stmt=c on .createStateme nt();Stri ng sql=Select*from house where id=;sql=sql+”+id+”;rs=stmt.executeQuery(sql);while(rs. next()String id 1= rs.getString(id);String name仁rs.getString(name);String tel仁rs.getString(tel);String loc仁rs.getString(loc);String riqi1=rs.getStri ng(riqi);String price仁rs.getStri ng(price);String type仁rs.getStri ng(type);String zt 1= rs.getString(zt);String str= 房屋编号-+id1+n客户-+name1+n联系方式-+tel1+n 坐落位置+loc1+n建造日期+riqi1+n价格+price1+n户型 +type1+n房屋状态+zt1;result.appe nd(str);result.appe nd(n);JOptio nPa ne.showMessageDialog(this,成功查询到所需信息”)；stmt.close();con. close();n=1;catch (SQLException e1) / TODO Auto-ge nerated catch blocke1.pri ntStackTrace();if(n=0)JOptio nPan e.showMessageDialog(this,对不起，您所查询的信息不存在);public static void main(String args)new Adm in 1();public void acti on Performed(Act ion Eve nt e) if(e.getSource()=jb1)in sert();if(e.getSource()=jb2)xiugai();if(e.getSource()=jb3)delete();if(e.getSource()=jb4)search(); RegisterExceptio npackage gaolei;public class RegisterExcepti on exte nds Run timeExcepti onpublic RegisterExcepti on() super(用于登录异常的情况，例如密码两次输入不一致等情况);Userpackage gaolei;public class User exte nds JFrame impleme nts Actio nListe nerJLabel jl1,jl2;JTextField jf1,jf2;JPa nel jp1,jp2,jp3;JButton jb;Stri ng DBDriver=s un .jdbc.odbc.JdbcOdbcDriver;Stri ng connection Str=jdbc:odbc:NewUser;Stateme nt stmt=n ull,s仁 null;Connection con=n ull;int nu mber=0;User()nu mber=0;setTitle(” 普通用户登陆);setLayout (new FlowLayout();jp1= new JPa nel();jp2=new JPa nel();jp3=new JPa nel();jl1= new JLabel(请输入账户 ID ：);jp1.add(jl1);jf仁new JTextField(20);jp1.add(jf1);add(jp1);jl2=new JLabel(请输入密码：);jp2.add(jl2);jf2=new JTextField(20);jp2.add(jf2);add(jp2);jb=new JButton(”登陆);jp3.add(jb);add(jp3);jb.addAct ion Liste ner(this);jfl.addActi on Liste ner(this);jf2.addActi on Liste ner(this);setSize(350, 200);setLocatio n(300, 200);setVisible(true);validate。;public void Selects()int m=0;tryClass.forName(DBDriver);/加载驱动器catch(ClassNotFou ndException e1)e1.pri ntStackTrace();Stri ng id=jf1.getText();Stri ng password=jf2.getText();trycon=DriverMa nager.getC onn ectio n(conn ectio nStr,);Stateme nt stmt=c on .createStateme nt();ResultSet rs=n ull;if(!id.equals() & !password.equals()String selectsExpression 1=select * from user where id=;selectsExpression仁selectsExpression1+id+; rs=stmt.executeQuery(selectsExpressi on 1);while(rs. next()String password1=rs.getStri ng(password);if(password1.equals(password)new User1();m=1;if(m=0);JOptio nPan e.showMessageDialog(this,没有该用户或者密码错误elseJOptio nPan e.showMessageDialog(this,请输入完整信息！);stmt.close();con. close();catch (SQLException e1) / TODO Auto-ge nerated catch blockel.pri ntStackTrace();public void action Performed(Acti onEvent e) if(e.getSource()=jb)Selects();Userlpackage gaolei;public class Userl exte nds JFrame impleme nts Actio nListe ner JFrame f;JLabel jl,j2,j3,j4,j5,j6;JTextField jf1,jf2,jf3,jf4,jf5,jf6;JButton jb3,jb4,jb5,jb6,jb7,jb8;JPa nel jp1;int id;int m=0;JTextArea result;Stri ng DBDriver=s un .jdbc.odbc.JdbcOdbcDriver;Stri ng conn ectio nStr=jdbc:odbc:Housel nfo1;Stateme nt stmt=n ull,s1= null;Connection con=n ull;ResultSet rs=null;PreparedStateme nt stmt1= null,stmt2=n ull,stmt3=n ull,stmt4=n ull; public User1() f = new JFrame(”房源信息一览”)；jp1= new JPa nel();jp1.setLayout (new GridLayout(6, 2);jl=new JLabel( 坐落位置：”)；j2=new JLabel(建造年月：”)；j3=new JLabel(价格：);j4=new JLabel(户型：);j5=new JLabel(状态：);jf1=new JTextField(10);jf2=new JTextField(10);jf3=new JTextField(10);jf4=new JTextField(10);jf5=new JTextField(10);jb3=new JButton(”输出全部文件);jb4=new JButton(查询);jp1.add(jl);jp1.add(jf1);jp1.add(j2);jp1.add(jf2);jp1.add(j3);jp1.add(jf3);jp1.add(j4);jp1.add(jf4);jp1.add(j5);jp1.add(jf5);jp1.add(jb3);jp1.add(jb4);jb3.addAct ion Liste ner(this);jb4.addAct ion Liste ner(this);jf3.addActi on Liste ner(this);jf4.addActi on Liste ner(this);f.add(BorderLayout.NORTH, jpl);result = new JTextArea(60, 100);result.setEditable(false);JScrollPa ne jScrollPa ne=new JScrollPa ne(result);f.add(BorderLayout.CENTER, jScrollPa ne);f.setSize(500, 600);f.setLocati on(600, 80);f.setVisible(true);f.validate();public void search()int n=0;tryClass.forName(DBDriver);/ 加载驱动器表达式catch(ClassNotFo un dException e1)e1.pri ntStackTrace();Stri ng loc=jf1.getText();Stri ng riqi=jf2.getTex