JDBC.rar_Table

      
import java.awt.Color;
import java.awt.FlowLayout;

import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.awt.event.WindowAdapter;
import java.awt.event.WindowEvent;
import java.sql.*;

import javax.swing.*;
import javax.swing.event.ListSelectionEvent;
import javax.swing.event.ListSelectionListener;
public class database extends JFrame{
	static DefaultListModel m1=new DefaultListModel(); 
    DefaultListModel m2=new DefaultListModel();
    DefaultListModel m3=new DefaultListModel(); 
    DefaultListModel m4=new DefaultListModel();
    JList list1=new JList(m1);
    JList list2=new JList(m2);
    JList list3=new JList(m3);
    JList list4=new JList(m4);
    JLabel warn=new JLabel("请选择一个项目！");
    static int i=0;
    JLabel tip=new JLabel("提交失败");
	String url="jdbc:mysql://localhost:3306/test?user=root&password=root";
    Connection conn=DriverManager.getConnection(url);
    Statement stmt = conn.createStatement( );
public database() throws ClassNotFoundException, SQLException
{
	super("数据库");
	JLabel name=new JLabel("name");
	JLabel birthday=new JLabel("birthday");
	JLabel homeAddress=new JLabel("homeAddress");
	JLabel classNumber=new JLabel("classNumber");
	Class.forName("com.mysql.jdbc.Driver"); 
	conn.setAutoCommit(false);
    ResultSet rs = stmt.executeQuery("SELECT * FROM `test`.`student`");
    for(i=0;rs.next();i++)
    {
    	m1.add(i, rs.getString("name"));
    	m2.add(i,rs.getString("birthday"));
    	m3.add(i, rs.getString("homeAddress"));
    	m4.add(i,rs.getString("classNumber"));
    }
    
    list1.addListSelectionListener(new list());
    list2.addListSelectionListener(new list());
    list3.addListSelectionListener(new list());
    list4.addListSelectionListener(new list());
    
    setLayout(null);
    setBounds(500, 300, 550, 500);
    name.setBounds(40,20,80,30);
    add(name);
    list1.setBounds(40,50,110,200);
    add(list1);
   
    birthday.setBounds(150,20,80,30);
    add(birthday);
    list2.setBounds(150,50,110,200);
    add(list2);
    homeAddress.setBounds(260,20,80,30);
    add(homeAddress);
    list3.setBounds(260,50,110,200);
    add(list3);
 
    classNumber.setBounds(370,20,80,30);
    add(classNumber);
    list4.setBounds(370,50,110,200);
    add(list4);
   
    JButton change=new JButton("修改");
    change.setBounds(70,270,80,30);
    change.addActionListener(new Change());
    add(change);
    JButton delete=new JButton("删除");
    delete.setBounds(180,270,80,30);
    delete.addActionListener(new DELETE());
    add(delete);
   
    warn.setBounds(270,270,150,30);
    warn.setVisible(false);
    add(warn);
    JButton addnew=new JButton("添加");
    addnew.setBounds(100,340,80,30);
    addnew.addActionListener(new ADD());
    add(addnew);
    tip.setBounds(220, 340, 120, 30);
    tip.setVisible(false);
    add(tip);
    JButton submit=new JButton("提交");
    submit.setBounds(300,340,80,30);
    submit.addActionListener(new SUBMIT());
    add(submit);
    JButton help=new JButton("帮助");
    help.setBounds(400,340,80,30);
    help.addActionListener(new HELP());
    add(help);
    addWindowListener(new WindowAdapter() 
    {public void windowClosing(WindowEvent e) {System.exit(0);}});
	setVisible(true);
	
}
public class list implements ListSelectionListener
{
public void valueChanged(ListSelectionEvent arg0) {
Object source1=arg0.getSource();
tip.setVisible(false);
if(source1==list1)
{
	warn.setVisible(false);
	list1.setSelectionBackground(Color.GREEN);
	list2.setSelectionBackground(null);
	list3.setSelectionBackground(null);
	list4.setSelectionBackground(null);
}
if(source1==list2)
{
	warn.setVisible(false);
	list2.setSelectionBackground(Color.orange);
	list1.setSelectionBackground(null);
	list3.setSelectionBackground(null);
	list4.setSelectionBackground(null);
}
if(source1==list3)
{
	warn.setVisible(false);
	list3.setSelectionBackground(Color.cyan);
	list2.setSelectionBackground(null);
	list1.setSelectionBackground(null);
	list4.setSelectionBackground(null);
}
if(source1==list4)
{
	warn.setVisible(false);
	list4.setSelectionBackground(Color.pink);
	list2.setSelectionBackground(null);
	list3.setSelectionBackground(null);
	list1.setSelectionBackground(null);
}
}
}
public class Change implements  ActionListener{
	JTextField cha=new JTextField(15);
	JLabel empty=new JLabel("内容不能为空");
	 public void actionPerformed(ActionEvent arg1) {
		 tip.setVisible(false);
		if(list1.getSelectedIndex()==-1&&list2.getSelectedIndex()==-1
				&&list3.getSelectedIndex()==-1&&list4.getSelectedIndex()==-1)
		{
			warn.setVisible(true);
		}
		else
		{
			
			final JFrame frame1=new JFrame("修改");
			JButton sure=new JButton("确定");
			
			empty.setVisible(false);
			if(list1.getSelectionBackground()==Color.GREEN)
			{
				cha.setText((String)list1.getSelectedValue());
				sure.addActionListener(new ActionListener(){
					public void actionPerformed(ActionEvent arg2) {
						if(cha.getText().equals(""))
						{
							empty.setVisible(true);
						}
						else
						{empty.setVisible(false);
						int select=list1.getSelectedIndex();
						m1.remove(select);
						m1.add(select, cha.getText());
						frame1.dispose();}
					}}
					);
			}
			if(list2.getSelectionBackground()==Color.orange)
			{
				cha.setText((String)list2.getSelectedValue());
				sure.addActionListener(new ActionListener(){
					public void actionPerformed(ActionEvent arg2) {
						if(cha.getText().equals(""))
						{
							empty.setVisible(true);
						}
						else
						{empty.setVisible(false);
						int select=list2.getSelectedIndex();
						m2.remove(select);
						m2.add(select, cha.getText());
						frame1.dispose();}
					}}
					);
			}
			if(list3.getSelectionBackground()==Color.cyan)
			{
				cha.setText((String)list3.getSelectedValue());
				sure.addActionListener(new ActionListener(){
					public void actionPerformed(ActionEvent arg2) {
						if(cha.getText().equals(""))
						{
							empty.setVisible(true);
						}
						else
						{empty.setVisible(false);
						int select=list3.getSelectedIndex();
						m3.remove(select);
						m3.add(select, cha.getText());
						frame1.dispose();}
					}}
					);
			}
			if(list4.getSelectionBackground()==Color.pink)
			{
				cha.setText((String)list4.getSelectedValue());
				sure.addActionListener(new ActionListener(){
					public void actionPerformed(ActionEvent arg2) {
						if(cha.getText().equals(""))
						{
							empty.setVisible(true);
						}
						else
						{empty.setVisible(false);
						int select=list4.getSelectedIndex();
						m4.remove(select);
						m4.add(select, cha.getText());
						frame1.dispose();}
					}}
					);
			}
			JPanel jp1=new JPanel();
			jp1.setLayout(new FlowLayout());
			jp1.add(cha);
			jp1.add(sure);
			jp1.add(empty);
			frame1.getContentPane( ).add(jp1);
			frame1.setSize(300,100);
			frame1.setVisible(true);
			
		}
	 }
	 }
public class DELETE implements  ActionListener{
	public void actionPerformed(ActionEvent arg1) {
		tip.setVisible(false);
		if(list1.getSelectedIndex()==-1&&list2.getSelectedIndex()==-1
				&&list3.getSelectedIndex()==-1&&list4.getSelectedIndex()==-1)
		{
			warn.setVisible(true);
			return;
		}
		if(list1.getSelectionBackground()==Color.GREEN)
		{
			int dele=list1.getSelectedIndex();
			m1.remove(dele);m2.remove(dele);
			m3.remove(dele);m4.remove(dele);
			i--;
		}
		if(list2.getSelectionBackground()==Color.orange)
		{
			int dele=list2.getSelectedIndex();
			m1.remove(dele);m2.remove(dele);
			m3.remove(dele);m4.remove(dele);
			i--;
		}
		if(list3.getSelectionBackground()==Color.cyan)
		{
			int dele=list3.getSelectedIndex();
			m1.remove(dele);m2.remove(dele);
			m3.remove(dele);m4.remove(dele);
			i--;
		}
		if(list4.get