用java写个GUI界面，实现桌面托盘，并能够实现从数据库获取数据，播放音乐

第一步：实现桌面托盘代码，包括设计窗体的图标，托盘的图标（注意图片最好是16*16像素），按键布局等

package com.lin.schedule;import java.awt.AWTException;import java.awt.BorderLayout;import java.awt.FlowLayout;import java.awt.Frame;import java.awt.GridLayout;import java.awt.Image;import java.awt.MenuItem;import java.awt.PopupMenu;import java.awt.SystemTray;import java.awt.Toolkit;import java.awt.TrayIcon;import java.awt.event.ActionEvent;import java.awt.event.ActionListener;import java.awt.event.MouseAdapter;import java.awt.event.MouseEvent;import java.awt.event.WindowAdapter;import java.awt.event.WindowEvent;import java.net.URL;import javax.swing.ImageIcon;import javax.swing.JButton;import javax.swing.JFrame;import javax.swing.JPanel;import javax.swing.JScrollPane;import javax.swing.JTextArea;@SuppressWarnings("serial")public class TestFrame extends JFrame{private TrayIcon trayIcon=null;//托盘图标private SystemTray systemTray=null;//系统托盘public static final int TEXTAREA_ROWS=10;public static final int TEXTAREA_CLOUMS=30;public TestFrame() {if(SystemTray.isSupported()){systemTray=SystemTray.getSystemTray();//实例try {URL path=TestFrame.class.getResource("/images/22.jpg");//图片像素最好16*16ImageIcon icon = new ImageIcon(path);Image image = icon.getImage();trayIcon=new TrayIcon(image); //创建托盘图标this.setIconImage(image);//更改窗体图标systemTray.add(trayIcon); //设置添加托盘 //添加窗口监听事件this.addWindowListener(new WindowAdapter(){//适配器接收window事件 @Overridepublic void windowIconified(WindowEvent e)//窗口图标化（最小化）触发{dispose();//释放本机所有资源}});//为图标设置鼠标监听器trayIcon.addMouseListener(new MouseAdapter(){@Overridepublic void  mouseClicked(MouseEvent e){if(e.getClickCount()==2){setExtendedState(Frame.NORMAL);setVisible(true); }}});} catch (AWTException e1) {e1.printStackTrace();}     // 设置标题        setTitle("定时任务窗口");        // 设置布局        setLayout(new FlowLayout());        // 按钮对象数组        /* JButton[] btn = new JButton[3];*/        JButton btn1=new JButton("增加数据");        JButton btn2=new JButton("更新数据");        JButton btn3=new JButton("删除数据");        JButton btn4=new JButton("查询数据");        JButton btn5=new JButton("退出");        //设置板面局部按钮靠西        JPanel westPanel=new JPanel();        westPanel.setLayout(new GridLayout(5,1));        westPanel.add(btn1);        westPanel.add(btn2);        westPanel.add(btn3);        westPanel.add(btn4);        westPanel.add(btn5);        /*add(westPanel,BorderLayout.WEST);*/        this.getContentPane().add(westPanel,BorderLayout.WEST);//添加面板到框架中                  //添加按钮的监听事件                btn4.addActionListener(new ActionListener() {@Overridepublic void actionPerformed(ActionEvent e) {if(e.getSource()==btn4){MyPanel mp = new MyPanel();                mp.getData();}}});                      btn5.addActionListener(new ActionListener() {@Overridepublic void actionPerformed(ActionEvent e) {if(e.getSource()==btn5){System.exit(0);}}});                JTextArea textArea=new JTextArea(TEXTAREA_ROWS, TEXTAREA_CLOUMS);JScrollPane scrollPane=new JScrollPane(textArea); //一个轻量级的可滚动视图 创建一个 JScrollPane，显示指定组件的内容，在垂直和水平两个每当组件的内容大于视图滚动条出现add(scrollPane, BorderLayout.CENTER);        // 设置窗体的一些属性，比如点击关闭按钮时的操作        setDefaultCloseOperation(EXIT_ON_CLOSE);        // 窗体是否可调整大小        setResizable(true);        // 窗体的大小        setSize(500, 250);        // 居中显示        setLocationRelativeTo(null);        // 将窗体显示在屏幕上        setVisible(true);    }}    public static void main(String[] args) {    // 用的时候直接new出来就可以了，代码都在构造函数里面写了        new TestFrame();    }}

第二步：能够点击窗体按钮，弹出对话框，在对话框中显示数据库读取的数据

package com.lin.schedule;import java.awt.BorderLayout;import java.awt.Container;import java.awt.event.ActionEvent;import java.awt.event.ActionListener;import java.sql.Connection;import java.sql.PreparedStatement;import java.sql.ResultSet;import java.sql.ResultSetMetaData;import java.sql.SQLException;import javax.swing.JButton;import javax.swing.JDialog;import javax.swing.JFrame;import javax.swing.JLabel;import javax.swing.SwingConstants;public class MyPanel {Connection conn = null;PreparedStatement pStat = null;ResultSet rs = null;ResultSetMetaData m = null;public void getData(){DB db = new DB();try {String sql = "select * from t_customers";conn = db.getConn();pStat = db.prepare(conn, sql);rs = pStat.executeQuery();m = rs.getMetaData();int columns=m.getColumnCount();String str = "<html>";for(int i=1;i<=columns;i++){if(i==1){str += "<tr>"; str +="<td>" + m.getColumnName(i)+"</td>";}else if(i==columns){str +="<td>" + m.getColumnName(i) + "</td></tr>";}else{str +="<td>" + m.getColumnName(i) + "</td>";}}while (rs.next()) {for(int i=1;i<=columns;i++){if(i==1){str += "<tr>"; str +="<td>" +rs.getString(i)+"</td>";}else if(i==columns){str +="<td>" + rs.getString(i) + "</td></tr>";}else{str +="<td>" + rs.getString(i) + "</td>";}}}str += "</html>";if(rs!=null){/*JDialog dialog = new JDialog();//dialog.setBounds(300, 200, 500, 400);dialog.setSize(200,200);JLabel jl = new JLabel();System.out.println(str);jl.setVerticalAlignment(SwingConstants.CENTER);dialog.add(jl);jl.setText("<html><tr><td>Id</td><td>Name</td><td>Age</td></tr><tr><td>1</td><td>TOM</td><td>21</td></tr><tr><td>2</td><td>MIKE</td><td>24</td></tr><tr><td>3</td><td>JACK</td><td>30</td></tr><tr><td>4</td><td>jerry</td><td>25</td></tr><tr><td>5</td><td>LINDA</td><td>30</td></tr></html>");dialog.setVisible(true);MusicPlayer mp = new MusicPlayer();mp.MuiscPlay();        Thread.sleep(4000);dialog.dispose();  */ JFrame fr = new JFrame("查询结果");//窗体 Container cont = fr.getContentPane();//容器     JDialog dialog = new JDialog(fr);//JDialog     JButton button = new JButton("关闭");//按钮     JLabel label=new JLabel();//文本标签     button.addActionListener(new ActionListener() {@Overridepublic void actionPerformed(ActionEvent e) { dialog.setVisible(false);//“关闭”JDialog,用System.exit()会让主窗体也被关掉}});//添加监听器         //    fr.setLayout(null);//绝对布局        fr.setLocationRelativeTo(null);//居中显示        button.setBounds(200, 360, 100, 20);//设置位置        fr.setSize(500,420);//设置窗体大小        cont.add(button);//将按钮添加至容器//        label.setBounds(225, 225, 30, 30);//label大小        label.setSize(100, 100);        label.setText(str);        cont.add(label,BorderLayout.CENTER);        fr.setVisible(true);//显示窗体}} catch (SQLException e) {e.printStackTrace();} /*catch (InterruptedException e) {e.printStackTrace();}*/finally {try {rs.close();pStat.close();conn.close();} catch (SQLException e) {e.printStackTrace();}}}}

第二步中虽然写了数据库的查询语句，但是可以先注释掉之后再添上。

第三步写数据库的查询语句

package com.lin.schedule;import java.sql.*;public class DB {public static Connection getConn() {Connection conn = null;try {Class.forName("com.mysql.jdbc.Driver");conn = DriverManager.getConnection("jdbc:mysql://localhost/study1?user=root&password=root");} catch (ClassNotFoundException e) {e.printStackTrace();} catch (SQLException e) {e.printStackTrace();}return conn;}public static PreparedStatement prepare(Connection conn,  String sql) {PreparedStatement pstmt = null; try {if(conn != null) {pstmt = conn.prepareStatement(sql);}} catch (SQLException e) {e.printStackTrace();}return pstmt;}public static PreparedStatement prepare(Connection conn,  String sql, int autoGenereatedKeys) {PreparedStatement pstmt = null; try {if(conn != null) {pstmt = conn.prepareStatement(sql, autoGenereatedKeys);}} catch (SQLException e) {e.printStackTrace();}return pstmt;}public static Statement getStatement(Connection conn) {Statement stmt = null; try {if(conn != null) {stmt = conn.createStatement();}} catch (SQLException e) {e.printStackTrace();}return stmt;}/*public static ResultSet getResultSet(Connection conn, String sql) {Statement stmt = getStatement(conn);ResultSet rs = getResultSet(stmt, sql);close(stmt);return rs;}*/public static ResultSet getResultSet(Statement stmt, String sql) {ResultSet rs = null;try {if(stmt != null) {rs = stmt.executeQuery(sql);}} catch (SQLException e) {e.printStackTrace();}return rs;}public static void executeUpdate(Statement stmt, String sql) {try {if(stmt != null) {stmt.executeUpdate(sql);}} catch (SQLException e) {e.printStackTrace();}}public static void close(Connection conn) {try {if(conn != null) {conn.close();conn = null;}} catch (SQLException e) {e.printStackTrace();}}public static void close(Statement stmt) {try {if(stmt != null) {stmt.close();stmt = null;}} catch (SQLException e) {e.printStackTrace();}}public static void close(ResultSet rs) {try {if(rs != null) {rs.close();rs = null;}} catch (SQLException e) {e.printStackTrace();}}}

运行结果如图：