mainframe.java

简单的留言版

        lbl1last.setText("末 页");
        lbl1last.setBounds(new Rectangle(342, 356, 37, 15));
        lbl1id.setBackground(Color.white);
        lbl1id.setFont(new java.awt.Font("宋体", Font.BOLD, 16));
        lbl1id.setForeground(Color.yellow);
        lbl1id.setText("学号：");
        lbl1id.setBounds(new Rectangle(540, 431, 57, 34));
        lbl1out.setText("[ 退出登陆 ]");
        lbl1out.setVisible(false);
        lbl1out.setBounds(new Rectangle(610, 62, 91, 22));
        lbl1pho.setText("班级相册");
        lbl1pho.setBounds(new Rectangle(473, 133, 60, 24));
        jPanel2.setBounds(new Rectangle(28, 0, 430, 580));
        jPanel1.add(tImage);
        tImage.add(jPanel2);
        tImage.add(lbl1send);
        tImage.add(btn1no);
        tImage.add(btn1send);
        tImage.add(txt1id);
        tImage.add(lbl1for);
        tImage.add(txt1display);
        tImage.add(lbl1sendto);
        tImage.add(pwd1);
        tImage.add(btn1login);
        tImage.add(lbl1pwd);
        tImage.add(btn1cancle);
        tImage.add(lbl1fir);
        tImage.add(lbl1next);
        tImage.add(cbxgetname);
        tImage.add(lbl1last);
        tImage.add(lbl1id);
        tImage.add(lbl1pho);
        tImage.add(lbl1out);
        tImage.add(lbl1prvMeg);
        tImage.add(lbl1Data);
        tImage.add(lbl1Reg);
        tImage.add(lbl1chk);
        tImage.add(lbl1Meg);
        tImage.add(lbl1wel);
        tImage.add(lbl1Admin);
        tImage.add(jScrollPane1);
        tImage.add(jScrollPane2);
        jScrollPane2.getViewport().add(txt1send);
        tImage.add(jPanel3);
        jScrollPane1.getViewport().add(txt1display);
        contentPane.add(jPanel1, java.awt.BorderLayout.CENTER);
        jpho.add(ti, java.awt.BorderLayout.CENTER);
        ConterjPopupMenu.add(milHelp);
        ConterjPopupMenu.add(milAbout);
        lbl1prvMeg.setVisible(false);
        jPanel3.setVisible(false);

    }

    /*自定义播放音乐的方法*/
    public void Music() {
        try {
            //创建一个媒体定位器(MediaLocator)对象，再利用该媒体定位器对象创建一个JMF对象
            player = Manager.createPlayer(new MediaLocator("file:" +
                    "Music\\清晨-萨克斯.mp3"));
            //将PlayerFrame对象注册为来自JMF对象的控制器事件的动作监听器
            player.addControllerListener(this);
            //让JMF播放器对象预先提取媒体文件的内容
            player.prefetch();
        } catch (Exception ex) {

        }
    }

    //Player 播放器对象的控制器事件监听器
    public void controllerUpdate(ControllerEvent e) {
        //如果预取媒体文件内容结束时
        if (e instanceof PrefetchCompleteEvent) {
            //让JMF播放器对象开始播放该媒体
            player.start();
            return;
        }
    }

    /*自定义获取系统当前时间方法,返回 String 类型*/
    public String TestTime() {
        //得到当前的系统时间
        Time objTime = new Time(System.currentTimeMillis());
        /*得到当前的系统日期*/
        Calendar objCal = Calendar.getInstance();
        String time = objCal.get(Calendar.YEAR) + "-" +
                      (objCal.get(Calendar.MONTH) + 1) + "-" +
                      objCal.get(Calendar.DATE) + " " +
                      objTime.toString();
        return time;
    }

    /*自定义给 cbxgetname 赋值方法*/
    public void setcbx() {
        String sql = "select id from stumeg";
        ResultSet rscbx = db.GetRs(sql);
        try {
            cbxgetname.removeAllItems();
            cbxgetname.addItem("大家");
            while (rscbx.next()) {
                cbxgetname.addItem(rscbx.getString(1));
            }
            rscbx.close();
        } catch (Exception ex) {

        }
    }

    /*自定义给留言管理的 cbxmId 赋值方法*/
    public void setcbxmId() {
        String sql = "select id from stumeg";
        ResultSet rscbx = db.GetRs(sql);
        try {
            cbxmId.removeAllItems();
            cbxmId.addItem("");
            while (rscbx.next()) {
                cbxmId.addItem(rscbx.getString(1).trim());
            }
            rscbx.close();
        } catch (Exception ex) {

        }
    }


    /*自定义查询公共留言方法*/
    public void select() {
        txt1display.setEditable(true);
        txt1display.setText(null);
        try {
            //定义 SQL2000 查询语句，得到留言人的姓名，时间，内容
            String sql = "select p.pmeg_id,s.sname,p.pmeg_date,p.pmeg_con from stumeg as s inner join pubmeg as p on(p.pmeg_send =s.id ) order by p.pmeg_id desc";
            //执行 sql 语句，让 ResultSet 对象得到查询结果
            rs = db.GetRs(sql);
            // ------count 计数  将前5条留言显示在 txt1display 中 ;
            int count = 0;
            while (rs.next()) {
                txt1display.append("ID:"+rs.getString(1)+"  " + rs.getString(2) + "   " +
                                   rs.getString(3) + "\n");
                txt1display.append("内容：" + rs.getString(4) + "\n\n");
                count++;
                if (rs.isLast()||count == 5)
                    break;
            }
        } catch (Exception ex) {
            JOptionPane.showMessageDialog(this, "select方法：" + ex);
        }
        txt1display.setEditable(false);
    }


    /*班级相册事件*/
    public void lbl1pho_mouseClicked(MouseEvent e) {
        if (lbl1wel.getText().equals("你还没有登陆!")) {
            JOptionPane.showMessageDialog(this, "请先登陆!");
        } else {
            //隐藏发送留言内容
            jScrollPane2.setVisible(false);
            txt1send.setVisible(false);
            txt1send.setText("");
            //隐藏留言管理的面板
            jPanel3.setVisible(false);
            txtmNum.setText("");
            cbxmId.removeAllItems();
            //隐藏留言内容
            jScrollPane1.setVisible(false);
            txt1display.setVisible(false);
            jPanel2.setVisible(true);
            btn1send.setVisible(false);
            btn1cancle.setVisible(false);
            cbxgetname.setVisible(false);
            //定义 SQL2000 查询语句，查询相片的存放路径
            String sql = "select pho_url from pho";
            //执行 sql 语句， ResultSet 对象接收查询
            rspho = db.GetRs(sql);
            try {
                rspho.next();
                ti.setImage(rspho.getString(1));
                ti.setSize(360, 270);
                ti.add(jpho);
            } catch (Exception ex) {

            }
        }
    }

    /*相册上一张事件*/
    public void lblPhoft_mouseClicked(MouseEvent e) {
        try {
            //判断 ResultSet 对象是否已到第一行
            if (rspho.isFirst()) {
                JOptionPane.showMessageDialog(this, "已经到第一张");
            } else {
                //指针移动到此 ResultSet 对象的上一行
                rspho.previous();
                ti.setImage(rspho.getString(1));
                ti.setSize(360, 270);
                ti.add(jpho);
            }
        } catch (Exception ex) {

        }
    }

    /*相册下一张事件*/
    public void lblPholt_mouseClicked(MouseEvent e) {
        try {
            //判断 ResultSet 对象是否已到最后一行
            if (rspho.isLast()) {
                JOptionPane.showMessageDialog(this, "已经到最后一张");
            } else {
                //指针移动到此 ResultSet 对象的下一行
                rspho.next();
                ti.setImage(rspho.getString(1));
                ti.setSize(360, 270);
                ti.add(jpho);
            }
        } catch (Exception ex) {

        }
    }

    /*公共留言事件*/
    public void lbl1Meg_mouseClicked(MouseEvent e) {
        if (lbl1wel.getText().equals("你还没有登陆!")) {
            JOptionPane.showMessageDialog(this, "请先登陆!");
        } else {
            select();
            //显示公共留言内容
            jScrollPane2.setVisible(true);
            txt1send.setVisible(true);
            txt1send.setText("");
            lbl1sendto.setVisible(true);
            lbl1send.setVisible(true);
            jPanel3.setVisible(false);
            jPanel2.setVisible(false);
            txtmNum.setText("");
            cbxmId.removeAllItems();
            jScrollPane1.setVisible(true);
            txt1display.setVisible(true);
            btn1send.setVisible(true);
            btn1cancle.setVisible(true);
            cbxgetname.setVisible(true);
        }
    }

    /*用户注册事件*/
    public void lbl1Reg_mouseClicked(MouseEvent e) {
        RegFrame rf = new RegFrame(this);
        rf.setSize(300, 400);
        rf.setBounds(370, 180, 300, 400);
        rf.setVisible(true);
        //主窗口锁定
        this.setEnabled(false);
    }

    /*登陆事件*/
    public void btn1login_actionPerformed(ActionEvent e) {
        //定义查询语句，根据用户输入的学号查询对应的密码、姓名、留言状态, ResultSet 对象接收返回结果
        String sql = "select spwd,sname,sstau from stuMeg where id = '" +
                     txt1id.getText() + "'";
        ResultSet rslog = db.GetRs(sql);
        try {
            /*判断是否输入学号，以及学号是否存在和密码的对错*/
            if (txt1id.getText().trim().length() == 0) {
                JOptionPane.showMessageDialog(this, "请输入学号");
            } else if (rslog != null && rslog.next() != true) {
                JOptionPane.showMessageDialog(this, "对不起，没有您输入的用户名！");
            } else if (pwd1.getText().equals(rslog.getString(1))) {
                /*下面是把学号、密码、登陆、取消等隐藏*/
                lbl1id.setVisible(false);
                lbl1pwd.setVisible(false);
                txt1id.setVisible(false);
                pwd1.setVisible(false);
                pwd1.setText(null);
                btn1login.setVisible(false);
                btn1no.setVisible(false);
                lbl1Reg.setVisible(false);
                lbl1wel.setText(rslog.getString(2) + "已登陆！");
                lbl1out.setVisible(true);
                lbl1prvMeg.setVisible(true);
                //隐藏公共留言内容
                jScrollPane1.setVisible(true);
                txt1display.setVisible(true);
                //显示公共留言内容
                jScrollPane1.setVisible(true);
                //个人资料-显示
                lbl1Data.setVisible(true);
                //留言-发送留言内容区解锁
                txt1send.setEditable(true);
                //留言-发送键解锁
                btn1send.setEnabled(true);
                //留言-取消键解锁
                btn1cancle.setEnabled(true);
                //留言To-对象解锁
                cbxgetname.setEnabled(true);
                /*下面的if---else断送是否有新的留言*/
                if (rslog.getInt(3) == 1) {
                    JOptionPane.showMessageDialog(this, "您有新的留言，请查看！");
                }
                //调用定义方法
                setcbx();
                //关闭音乐播放
                player.stop();
                //关闭 ResultSet 对象
                rslog.close();
            } else {
                JOptionPane.showMessageDialog(this, "密码错误");
            }
        } catch (Exception ex) {
            JOptionPane.showMessageDialog(this, ex.getMessage() + "登陆事件出错！");
        }
    }

    /*个人留言查看事件*/
    public void lbl1prvMeg_mouseClicked(MouseEvent e) {
        try {
            //定义 SQL2000 查询语句，根据用户查询对应个人留言, ResultSet 对象接收返回结果
            String sql = "select * from prvmeg where gmeg_get='" +
                         txt1id.getText() +
                         "'";
            ResultSet rsmeg = db.GetRs(sql);
            /*判断是否个人留言为空*/
            if (rsmeg != null && rsmeg.next() != true) {
                JOptionPane.showMessageDialog(this, "您没有个人留言");
            } else {
                MegFrame mf = new MegFrame(this);
                mf.setSize(525, 330);
                mf.setBounds(260, 180, 525, 330);
                mf.setVisible(true);
                this.setEnabled(false);
            }
            //关闭 ResultSet 对象
            rsmeg.close();
        } catch (Exception ex) {

        }
    }

    /*信息查询事件*/
    public void lbl1chk_mouseClicked(MouseEvent e) {
        if (lbl1wel.getText().equals("你还没有登陆!")) {
            JOptionPane.showMessageDialog(this, "请先登陆!");
        } else {
            ChkFrame cf = new ChkFrame(this);
            cf.setSize(570, 347);
            cf.setBounds(240, 180, 570, 347);
            cf.setVisible(true);
            //主窗口锁定
            this.setEnabled(false);
        }
    }

    /*退出登陆事件*/
    public void lbl1out_mouseClicked(MouseEvent e) {
      int faly=  JOptionPane.showConfirmDialog(this,"您确认要退出吗?","确认",JOptionPane.YES_NO_OPTION);
      if(faly==0){
          lbl1wel.setText("你还没有登陆!");
          lbl1prvMeg.setVisible(true);
          lbl1id.setVisible(true);
          lbl1pwd.setVisible(true);
          txt1id.setText("A1Q6073-");