import?java.awt.BorderLayout;
import?java.awt.EventQueue;
import?java.awt.Graphics;
import?java.awt.Image;
import?java.awt.event.ActionEvent;
import?java.awt.event.ActionListener;
import?java.sql.SQLException;

import?javax.swing.Jframe;
import?javax.swing.JPanel;
import?javax.swing.border.EmptyBorder;
import?javax.swing.filechooser.FileNameExtensionFilter;
import?javax.swing.JLabel;
import?javax.swing.JOptionPane;
import?javax.swing.JTextField;
import?javax.swing.ImageIcon;
import?javax.swing.JButton;
import?javax.swing.JFileChooser;

public?class?AddMusic?extends?Jframe?{

	private?JPanel?contentPane;
	private?JTextField?textField_2;
	JFileChooser?jfc=new?JFileChooser（）;
	private?DBconnect?dbc=new?DBconnect（）;

	public?AddMusic（）?{
		setResizable（false）;
		setDefaultCloseOperation（Jframe.DISPOSE_ON_CLOSE）;
		setBounds（600?300?422?321）;
		contentPane?=?new?JPanel（）;
		contentPane.setBorder（new?EmptyBorder（5?5?5?5））;
		setContentPane（contentPane）;
		contentPane.setLayout（null）;
		
		JLabel?label_2?=?new?JLabel（“\u6B4C\u66F2\u8DEF\u5F84“）;
		label_2.setBounds（47?101?72?18）;
		contentPane.add（label_2）;
		
		JButton?btnNewButton?=?new?JButton（“\u9009\u62E9“）;
		btnNewButton.addActionListener（new?ActionListener（）?{
			
			@Override
			public?void?actionPerformed（ActionEvent?e）?{
				//?TODO?自動生成的方法存根
				?FileNameExtensionFilter?filter??=?new?FileNameExtensionFilter（“Allowd?File““mp3“）;//設置過濾器
	????????????????jfc.setFileFilter（filter）;
	????????????????int?value?=?jfc.showOpenDialog（btnNewButton）;

	????????????????if?（value?==?JFileChooser.APPROVE_OPTION）{
				textField_2.setText（jfc.getSelectedFile（）.getPath（））;}
			}
		}）;
		btnNewButton.setBounds（286?97?113?27）;
		contentPane.add（btnNewButton）;
		
		textField_2?=?new?JTextField（）;
		textField_2.setBounds（133?98?124?24）;
		contentPane.add（textField_2）;
		textField_2.setColumns（10）;
		
		JButton?button?=?new?JButton（“\u6DFB\u52A0“）;
		button.addActionListener（new?ActionListener（）?{
			
			@Override
			public?void?actionPerformed（ActionEvent?e）?{
				//?TODO?自動生成的方法存根
			
				try?{
					
				String?regex=“[-.]“;
				String?music[]=jfc.getSelectedFile（）.getName（）.split（regex）;
					String?s=“\\\\“;
					music[1]=music[1].replaceAll（“\‘““\‘\‘“）;
					String?str=textField_2.getText（）.replaceAll（s?“\\\\\\\\“）;
					str=str.replaceAll（“\‘““\‘\‘“）;
					if（dbc.getStatement（）.executeQuery（“SELECT?*?FROM?MUSICIMFORMATION?WHERE?MUSICNAME=‘“+music[1]+“‘and?singer=‘“+music[0]+“‘“）.next（））{
						JOptionPane.showMessageDialog（button?“該音樂已存在“?“提示“?JOptionPane.WARNING_MESSAGE）;
					}
					else{
						dbc.getStatement（）.execute（“INSERT?INTO?MUSICIMFORMATION?VALUES（‘“+music[1]+“‘‘“+music[0]+“‘‘“+music[2]+“‘‘“+str+“‘）“）;
						JOptionPane.showMessageDialog（button?“添加成功“?“提示“?JOptionPane.WARNING_MESSAGE）;
						}
				}?catch?（SQLException?e1）?{
					//?TODO?自動生成的?catch?塊
					e1.printStackTrace（）;
				}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

?????文件???????4132??2017-11-19?19:35??簡易音樂播放器\Dump20171119.sql

?????文件????????764??2017-06-04?14:05??簡易音樂播放器\點歌系統\.classpath

?????文件????????388??2017-06-04?13:11??簡易音樂播放器\點歌系統\.project

?????文件????????598??2017-06-04?13:11??簡易音樂播放器\點歌系統\.settings\org.eclipse.jdt.core.prefs

?????文件???????1475??2017-09-26?14:55??簡易音樂播放器\點歌系統\bin\AddMusic$1.class

?????文件???????2513??2017-09-26?14:55??簡易音樂播放器\點歌系統\bin\AddMusic$2.class

?????文件????????910??2017-09-26?14:55??簡易音樂播放器\點歌系統\bin\AddMusic$3.class

?????文件???????2190??2017-09-26?14:55??簡易音樂播放器\點歌系統\bin\AddMusic.class

?????文件???????2202??2017-09-26?14:55??簡易音樂播放器\點歌系統\bin\AddUser$1.class

?????文件????????904??2017-09-26?14:55??簡易音樂播放器\點歌系統\bin\AddUser$2.class

?????文件???????3103??2017-09-26?14:55??簡易音樂播放器\點歌系統\bin\AddUser.class

?????文件????????692??2017-09-26?14:55??簡易音樂播放器\點歌系統\bin\Adminframe$1.class

?????文件????????708??2017-09-26?14:55??簡易音樂播放器\點歌系統\bin\Adminframe$2.class

?????文件????????699??2017-09-26?14:55??簡易音樂播放器\點歌系統\bin\Adminframe$3.class

?????文件????????698??2017-09-26?14:55??簡易音樂播放器\點歌系統\bin\Adminframe$4.class

?????文件????????696??2017-09-26?14:55??簡易音樂播放器\點歌系統\bin\Adminframe$5.class

?????文件????????706??2017-09-26?14:55??簡易音樂播放器\點歌系統\bin\Adminframe$6.class

?????文件????????705??2017-09-26?14:55??簡易音樂播放器\點歌系統\bin\Adminframe$7.class

?????文件????????648??2017-09-26?14:55??簡易音樂播放器\點歌系統\bin\Adminframe$8.class

?????文件????????922??2017-09-26?14:55??簡易音樂播放器\點歌系統\bin\Adminframe$9.class

?????文件???????2733??2017-09-26?14:55??簡易音樂播放器\點歌系統\bin\Adminframe.class

?????文件????????945??2017-09-26?14:55??簡易音樂播放器\點歌系統\bin\AlterMusic$1.class

?????文件????????947??2017-09-26?14:55??簡易音樂播放器\點歌系統\bin\AlterMusic$2.class

?????文件???????2379??2017-09-26?14:55??簡易音樂播放器\點歌系統\bin\AlterMusic$3.class

?????文件???????2464??2017-09-26?14:55??簡易音樂播放器\點歌系統\bin\AlterMusic.class

?????文件???????2305??2017-09-26?14:55??簡易音樂播放器\點歌系統\bin\AlterPassword$1.class

?????文件????????940??2017-09-26?14:55??簡易音樂播放器\點歌系統\bin\AlterPassword$2.class

?????文件???????2382??2017-09-26?14:55??簡易音樂播放器\點歌系統\bin\AlterPassword.class

?????文件???????2467??2017-09-26?14:55??簡易音樂播放器\點歌系統\bin\AlterUserPassword$1.class

?????文件????????964??2017-09-26?14:55??簡易音樂播放器\點歌系統\bin\AlterUserPassword$2.class

............此處省略63個文件信息