基于javaweb的KTV点歌系统源码+数据库（高分项目）.zip

package com.andrewx.home; import java.awt.EventQueue; import javax.swing.JInternalFrame; import javax.swing.JLabel; import javax.swing.JOptionPane; import javax.swing.JPanel; import javax.swing.JButton; import javax.swing.JFrame; import javax.swing.JScrollBar; import javax.swing.JScrollPane; import javax.swing.JTable; import javax.swing.border.EmptyBorder; import javax.swing.table.DefaultTableCellRenderer; import javax.swing.table.DefaultTableModel; import javax.swing.table.JTableHeader; import com.andrewx.ktv_system.musictype.EnglishMusic; import com.geng.database.AdminHandleJDBC; import com.geng.database.MusicVO; import java.awt.event.ActionListener; import java.awt.event.MouseAdapter; import java.awt.event.MouseEvent; import java.text.ParseException; import java.text.SimpleDateFormat; import java.util.ArrayList; import java.awt.event.ActionEvent; import javax.swing.JTextField; import java.awt.Color; import java.awt.SystemColor; import java.awt.Font; public class EnglishMusicHandlePage extends JFrame { /** * */ private static final long serialVersionUID = 1L; private JScrollPane jsp; private JTable tableInfo; private DefaultTableModel dtm; private JTextField txtEnMusicName; private JTextField txtEnMusicAuthor; private JTextField txtEnMusicDate; private JTextField txtEnMusicType; private JTextField txtChangeName; private JTextField txtChangeAuthor; private JTextField txtChangeDate; private JTextField txtChangeType; private JTextField txtDelName; private JTextField txtDelAuthor; private JTextField txtDelDate; private JTextField txtDelType; private JTextField txtSearchName; private JTextField txtSearchAuthor; private JTextField txtSearchDate; private JTextField txtSearchType; public Integer musicID; public static String titleType; /** * Launch the application. */ public static void main(String[] args) { EventQueue.invokeLater(new Runnable() { public void run() { try { EnglishMusicHandlePage frame = new EnglishMusicHandlePage(); frame.setVisible(true); } catch (Exception e) { e.printStackTrace(); } } }); } /** * Create the frame. */ // class titletype{ // private String titleType; // // public String getTitleType() { // return titleType; // } // // public void setTitleType(String titleType) { // this.titleType = titleType; // } // // } public EnglishMusicHandlePage() { //setTitle("ktvenglishmusic"); setBounds(100, 100, 1111, 676); getContentPane().setLayout(null); JPanel groundPanel = new JPanel(); groundPanel.setBackground(SystemColor.menu); groundPanel.setBounds(0, 0, 1100, 624); getContentPane().add(groundPanel); groundPanel.setLayout(null); // JPanel showTablePane = new JPanel(); showTablePane.setBounds(196, 15, 878, 398); groundPanel.add(showTablePane); showTablePane.setLayout(null); tableInfo = new JTable(); tableInfo.setFont(new Font("SimSun", Font.PLAIN, 18)); tableInfo.addMouseListener(new MouseAdapter() { @Override public void mouseClicked(MouseEvent e) { int r=tableInfo.getSelectedRow(); musicID = Integer.parseInt(tableInfo.getValueAt(r, 1).toString());//获取musicId txtSearchName.setText(tableInfo.getValueAt(r, 2).toString()); txtSearchAuthor.setText(tableInfo.getValueAt(r, 3).toString()); txtSearchDate.setText(tableInfo.getValueAt(r, 5).toString()); txtSearchType.setText(tableInfo.getValueAt(r, 4).toString()); txtDelName.setText(tableInfo.getValueAt(r, 2).toString()); txtDelAuthor.setText(tableInfo.getValueAt(r, 3).toString()); txtDelDate.setText(tableInfo.getValueAt(r, 5).toString()); txtDelType.setText(tableInfo.getValueAt(r, 4).toString()); txtChangeName.setText(tableInfo.getValueAt(r, 2).toString()); txtChangeAuthor.setText(tableInfo.getValueAt(r, 3).toString()); txtChangeDate.setText(tableInfo.getValueAt(r, 5).toString()); txtChangeType.setText(tableInfo.getValueAt(r, 4).toString()); } }); tableInfo.setBounds(543, 0, -541, 251); showTablePane.add(tableInfo); jsp = new JScrollPane(tableInfo); jsp.setBounds(0, 0, 878, 398); showTablePane.add(jsp); JPanel searchHandlePanel = new JPanel(); searchHandlePanel.setLayout(null); searchHandlePanel.setBounds(196, 421, 878, 188); groundPanel.add(searchHandlePanel); JLabel searchEnMusicNameLabel = new JLabel("\u6B4C\u66F2\u540D\u79F0:"); searchEnMusicNameLabel.setFont(new Font("宋体", Font.PLAIN, 18)); searchEnMusicNameLabel.setBounds(113, 38, 100, 21); searchHandlePanel.add(searchEnMusicNameLabel); txtSearchName = new JTextField(); txtSearchName.setFont(new Font("SimSun", Font.PLAIN, 18)); txtSearchName.setColumns(10); txtSearchName.setBounds(201, 35, 150, 27); searchHandlePanel.add(txtSearchName); JLabel searchEnMusicAuthorLabel = new JLabel("\u4F5C \u8005:"); searchEnMusicAuthorLabel.setFont(new Font("宋体", Font.PLAIN, 18)); searchEnMusicAuthorLabel.setBounds(570, 41, 90, 21); searchHandlePanel.add(searchEnMusicAuthorLabel); txtSearchAuthor = new JTextField(); txtSearchAuthor.setFont(new Font("SimSun", Font.PLAIN, 18)); txtSearchAuthor.setColumns(10); txtSearchAuthor.setBounds(656, 38, 150, 27); searchHandlePanel.add(txtSearchAuthor); JLabel searchEnMusicDateLabel = new JLabel("\u65E5 \u671F:"); searchEnMusicDateLabel.setFont(new Font("宋体", Font.PLAIN, 18)); searchEnMusicDateLabel.setBounds(113, 95, 81, 21); searchHandlePanel.add(searchEnMusicDateLabel); txtSearchDate = new JTextField(); txtSearchDate.setFont(new Font("SimSun", Font.PLAIN, 18)); txtSearchDate.setColumns(10); txtSearchDate.setBounds(201, 92, 150, 27); searchHandlePanel.add(txtSearchDate); JLabel searchEnMusicTypeLabel = new JLabel("\u6B4C\u66F2\u7C7B\u578B:"); searchEnMusicTypeLabel.setFont(new Font("宋体", Font.PLAIN, 18)); searchEnMusicTypeLabel.setBounds(570, 95, 81, 21); searchHandlePanel.add(searchEnMusicTypeLabel); txtSearchType = new JTextField(); txtSearchType.setFont(new Font("SimSun", Font.PLAIN, 18)); txtSearchType.setColumns(10); txtSearchType.setBounds(656, 92, 150, 27); searchHandlePanel.add(txtSearchType); JButton btnSearch = new JButton("\u67E5\u627E"); btnSearch.setFont(new Font("宋体", Font.PLAIN, 18)); btnSearch.setBounds(306, 144, 123, 29); searchHandlePanel.add(btnSearch); JButton btnSearchRetset = new JButton("\u91CD\u7F6E"); btnSearchRetset.setFont(new Font("SimSun", Font.PLAIN, 18)); btnSearchRetset.addActionListener(new ActionListener() { public void actionPerformed(ActionEvent e) { txtSearchName.setText(""); txtSearchAuthor.setText(""); txtSearchDate.setText(""); txtSearchType.setText(""); } }); btnSearchRetset.setBounds(504, 144, 123, 29); searchHandlePanel.add(btnSearchRetset); btnSearch.addActionListener(new ActionListener() { public void actionPerformed(ActionEvent e) { AdminHandleJDBC handle = new AdminHandleJDBC(); MusicVO enMusic = new MusicVO(); if(!txtSearchName.getText().equals("")) enMusic.setMname(txtSearchName.getText()); else enMusic.setMname(""); if(!txtSearchAuthor.getText().equals("")) enMusic.setMauthor(txtSearchAuthor.getText()); else enMusic.setMauthor(""); if(!txtSearchDate.getText().equals("")) enMusic.setMtime(txtSearchDate.getText()); else enMusic.setMtime(""); if(!txtSearchType.getText().equals("")) enMusic.setMtype(txtSearchType.getText()); else enMusic.setMtype(""); ArrayList<MusicVO> en = handle.selectedbyCon(enMusic,getTitle()); String[] title = {"序号","歌曲号","名称","作者","类型","日期"}; String[][] values = new String[en.size()][title.length]; for(int i=0;i<en.size();i++) { values[i][0]=i+1+""; values[i][1] = en.get(i).getMid()+""; values[i][2] = en.get(i).getMname()+""; values[i][3] = en.get(i).getMauthor()+""; values[i][4] = en.get(i).getMtype()+""; values[i][