java农家乐信息管理系统 java GUI+Mysql

package com.sust.farmhousemanage; import java.awt.*; import java.awt.event.MouseAdapter; import java.awt.event.MouseEvent; import java.util.List; import javax.swing.*; import java.sql.*; /** * @author 25868 */ public class ShowFarmHouseInfoFrame extends JFrame { FarmHouse fh = new FarmHouse(); JTextArea fhInfoListJTA = null; //对输出进行处理 public StringBuffer setStringLen(int len) { StringBuffer string = new StringBuffer(); for(int i = 0; i < 70-len; i++) { string.append(" "); } return string; } /** * 显示所有农家乐信息 */ public void showAllStuInfo(){ fhInfoListJTA.setText(""); List<FarmHouse> list = fh.queryAllStuInfo(); for(FarmHouse farmhouse:list) { String name = farmhouse.getfhName(); String addr = farmhouse.getfhAddr(); String pername = farmhouse.getfhPername(); String pertel = farmhouse.getfhPertel(); fhInfoListJTA.setText(fhInfoListJTA.getText() +name + setStringLen(name.getBytes().length).toString() + addr + setStringLen(addr.getBytes().length).toString() + pername + setStringLen(pername.getBytes().length).toString() + pertel + "\n"); } } /** * 构造函数 */ public ShowFarmHouseInfoFrame() { this.setSize(1000, 600); this.setLocationRelativeTo(null); this.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE); this.setLayout(null); //界面标题部分 JLabel titleJL = new JLabel("农家乐信息管理系统"); Font font = new Font("微软雅黑", 1, 20); titleJL.setFont(font); titleJL.setLayout(null); titleJL.setBounds(400, 10, 200, 20); //按钮部分 JPanel buttonJP = new JPanel(); buttonJP.setLayout(null); buttonJP.setBackground(Color.blue); buttonJP.setBounds(0, 50, 1000, 40); JButton jbAdd = new JButton("添加农家乐信息"); jbAdd.setBounds(0, 10, 175, 30); jbAdd.setBackground(Color.green); JButton jbDelete = new JButton("删除农家乐信息"); jbDelete.setBounds(275, 10, 175, 30); jbDelete.setBackground(Color.green); JButton jbModify = new JButton("修改农家乐信息"); jbModify.setBounds(550, 10, 175, 30); jbModify.setBackground(Color.green); JButton jbQuery = new JButton("查询农家乐信息"); jbQuery.setBounds(825, 10, 175, 30); jbQuery.setBackground(Color.green); //buttonJP.setLayout(new FlowLayout()); buttonJP.add(jbAdd); buttonJP.add(jbDelete); buttonJP.add(jbModify); buttonJP.add(jbQuery); JPanel listHeadJP = new JPanel(); listHeadJP.setBackground(Color.white); listHeadJP.setLayout(null); listHeadJP.setBounds(0, 120, 1000, 30); JLabel nameHeadJL = new JLabel(" 名 字"); nameHeadJL.setBackground(Color.gray); nameHeadJL.setBounds(50, 0, 175, 25); JLabel addrHeadJL = new JLabel(" 地 址"); addrHeadJL.setBackground(Color.gray); addrHeadJL.setBounds(325, 0, 175, 25); JLabel pernameHeadJL = new JLabel("负责人"); pernameHeadJL.setBackground(Color.gray); pernameHeadJL.setBounds(590, 0, 175, 25); JLabel pertelHeadJL = new JLabel(" 电 话"); pertelHeadJL.setBackground(Color.gray); pertelHeadJL.setBounds(875, 0, 175, 25); listHeadJP.add(nameHeadJL); listHeadJP.add(addrHeadJL); listHeadJP.add(pernameHeadJL); listHeadJP.add(pertelHeadJL); Font fhInfoListFont = new Font("微软雅黑", 0, 13); fhInfoListJTA = new JTextArea(20,20); fhInfoListJTA.setBounds(10, 152, 1000, 400); fhInfoListJTA.setBorder (BorderFactory.createEmptyBorder (1,1,1,5)); fhInfoListJTA.setColumns (20); fhInfoListJTA.setRows (20);//相当于设置文本区组件的初始大小,并不是说一行只能写0 fhInfoListJTA.setFont(fhInfoListFont); this.add(titleJL); this.add(buttonJP); this.add(listHeadJP); this.add(fhInfoListJTA); showAllStuInfo(); this.setVisible(true); //添加农家乐信息 jbAdd.addMouseListener(new MouseAdapter(){ //匿名内部类使用方法的临时变量需要提前，负责会让你改为final，改为final是为了延长变量的声明周期 JTextField numJTF = null; JTextField nameJTF = null; JTextField classJTF = null; JTextField professionalJTF = null; @Override public void mouseClicked(MouseEvent e) { final JFrame addJF = new JFrame(); addJF.setSize(310, 300); addJF.setBackground(Color.gray); addJF.setLocationRelativeTo(null); addJF.setVisible(true); addJF.setLayout(new FlowLayout()); JLabel numJL = new JLabel("名 字："); numJTF = new JTextField(20); JLabel nameJL = new JLabel("地 址："); nameJTF = new JTextField(20); JLabel classJL = new JLabel("负责人："); classJTF = new JTextField(20); JLabel professionalJL = new JLabel("电 话："); professionalJTF = new JTextField(20); //addJF.dispose();//销毁子窗口 addJF.add(numJL); addJF.add(numJTF); addJF.add(nameJL); addJF.add(nameJTF); addJF.add(classJL); addJF.add(classJTF); addJF.add(professionalJL); addJF.add(professionalJTF); JButton addJB = new JButton("添加"); addJF.add(addJB); addJB.addMouseListener(new MouseAdapter() { @Override public void mouseClicked(MouseEvent e) { String nameAdd = numJTF.getText(); String addrAdd = nameJTF.getText(); String pernameAdd = classJTF.getText(); String pertelAdd = professionalJTF.getText(); //输入的信息为空的处理 if(nameAdd == "" | addrAdd == "" | pernameAdd == "" | pertelAdd == "") { JFrame tipJF = new JFrame("提示"); tipJF.setVisible(true); tipJF.setSize(200,100); tipJF.setLocationRelativeTo(null); JLabel tipJL = new JLabel("请填入了所有的信息之后再点击提交"); tipJF.add(tipJL); }else { fh = new FarmHouse(); fh.addStuInfo(nameAdd, addrAdd, pernameAdd, pertelAdd); addJF.dispose(); JFrame addSuccessfulJF = new JFrame("提示"); addSuccessfulJF.setLocationRelativeTo(null); addSuccessfulJF.setSize(260, 100); addSuccessfulJF.setVisible(true); addSuccessfulJF.setLayout(new FlowLayout()); JLabel SuccessfulJL = new JLabel("添加农家乐信息成功！"); addSuccessfulJF.add(SuccessfulJL); } } }); } }); //删除农家乐信息 jbDelete.addMouseListener(new MouseAdapter() {