a.java

一个我做的课程设计

import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import java.sql.*;
class Longin implements ActionListener
{
	JButton bt1=new JButton("登陆");
  JButton bt2=new JButton("取消");
  JFrame f=new JFrame("The Student Land System");
  JTextField tf1=new JTextField(12);
  JPasswordField tf2=new JPasswordField(12);
 public Longin()
 { 
  
  Container cp=f.getContentPane();
  f.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
  JPanel p1=new JPanel();
  JPanel p2=new JPanel();
  JPanel p3=new JPanel();
  JPanel p4=new JPanel();
  JLabel l1=new JLabel("登陆系统");
  JLabel l2=new JLabel("用户名");
  JLabel l3=new JLabel("密码");
  bt1.addActionListener(this);
  bt2.addActionListener(this);
  
  
  

  
  p2.add(l2);
  p2.add(tf1);
  p2.add(l3);
  p2.add(tf2);
  p3.add(bt1);
  p3.add(bt2);
 
  
 
  p1.add("North",l1);
  p1.add("Center",p2);
  p1.add("South",p3);
  cp.add(p1);
  f.setSize(350,150);
  f.setVisible(true);
 }
	public void actionPerformed(ActionEvent ev)
	{
		if(ev.getSource()==this.bt1){
			String ss1=this.tf1.getText();
			String ss2=this.tf2.getText();
			try{
				Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
				Connection conn=DriverManager.getConnection("jdbc:odbc:AAA");	
				Statement stmt=conn.createStatement();
				ResultSet rs=stmt.executeQuery("select * from UserMessage");
				while(rs.next())
				{
					if(ss1.equals(rs.getString("nnname"))&&ss2.equals(rs.getString("aaadmin")))
					{
						
						new Manage();
						JOptionPane.showMessageDialog(null,"登陆成功");
					}
				}
			}catch(Exception ee){
				System.out.println(ee);
			}
		}	
		else if(ev.getSource()==this.bt2)
		{
			JOptionPane.showMessageDialog(null,"登陆失败");
			this.f.dispose();
		}	
	}

	class WinLis extends WindowAdapter
	{
		public void windowsClosing(WindowEvent e)
		{ System.exit(0);}
	}
	
 }
 class Manage implements ActionListener
 {
 	
 		JPasswordField tf1=new JPasswordField(15);
		
		JPasswordField tf2=new JPasswordField(15);
		JPasswordField tf3=new JPasswordField(15);
		JPasswordField tf4=new JPasswordField(15);
		JPasswordField tf5=new JPasswordField(15);
		JButton bt1=new JButton("添加");
		JButton bt2=new JButton("修改");
		JButton bt3=new JButton("删除");
		JButton bt4=new JButton("查找");
		JButton bt5=new JButton("取消");
		JFrame nf=new JFrame("The Student of manager system");
 	public Manage()
 	{
 		
		Container cp=nf.getContentPane();
		nf.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
		JPanel p1=new JPanel();
		JPanel p2=new JPanel();
		JPanel p3=new JPanel();
		JLabel l1=new JLabel("管理系统");
		JLabel l2=new JLabel("用户名");
		JLabel l3=new JLabel("密码");
		JLabel l4=new JLabel("重复密码");
		JLabel l5=new JLabel("学号");
		JLabel l6=new JLabel("住址");
		bt1.addActionListener(this);
		bt2.addActionListener(this);
		bt3.addActionListener(this);
		bt4.addActionListener(this);
		bt5.addActionListener(this);

		
		

		p2.setLayout(new GridLayout(5,2));
		p1.setBackground(Color.yellow);
  		p2.setBackground(Color.yellow);
  		p3.setBackground(Color.yellow);
  		l1.setForeground(Color.red);
  
		p2.add(l2);
		p2.add(tf1);
		p2.add(l3);
		p2.add(tf2);
		p2.add(l4);
		p2.add(tf3);
		p2.add(l5);
		p2.add(tf4);
		p2.add(l6);
		p2.add(tf5);
		p3.add(bt1);
		p3.add(bt2);
		p3.add(bt3);
		p3.add(bt4);
		p3.add(bt5);
		
	
		p1.add("North",l1);
		p1.add("Center",p2);
		p1.add("South",p3);
		
		cp.add(p1);
		nf.setSize(350, 250);
		
		nf.setVisible(true);
		nf.addWindowListener(new WinLis());
 	}
 		class WinLis extends WindowAdapter
	{
		public void windowsClosing(WindowEvent e)
		{ System.exit(0);}
	}
	public void actionPerformed(ActionEvent ae)
	{
		String s1=this.tf1.getText();
		String s2=this.tf2.getText();
		String s3=this.tf3.getText();
		String s4=this.tf4.getText();
		String s5=this.tf5.getText();
		if(ae.getSource()==this.bt1)
		{
			try{
				Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
				Connection conn=DriverManager.getConnection("jdbc:odbc:AAA");	
				Statement stmt=conn.createStatement();
				
				if(s2.equals(s3))
				{
						
					stmt.executeUpdate("insert into UserMessage values('"+s1+"','"+s2+"','"+s4+"','"+s5+"')");
					JOptionPane.showMessageDialog(null,"登陆成功");
				}
			
			}catch(Exception ee){
				System.out.println(ee);
			}
		}
		if(ae.getSource()==this.bt2)
		{
			try{
				Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
				Connection conn=DriverManager.getConnection("jdbc:odbc:AAA");	
				Statement stmt=conn.createStatement();
				
				if(s2.equals(s3))
				{
						
					stmt.executeUpdate("update UserMessage set aaadmin='"+s2+"' where nnname='"+s1+"'");
					stmt.executeUpdate("update UserMessage set sid='"+s4+"' where nnname='"+s1+"'");
					stmt.executeUpdate("update UserMessage set address='"+s5+"' where nnname='"+s1+"'");
					JOptionPane.showMessageDialog(null,"登陆成功");
				}
			
			}catch(Exception ee){
				System.out.println(ee);
			}
		}
		if(ae.getSource()==this.bt3)
		{
			try{
				Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
				Connection conn=DriverManager.getConnection("jdbc:odbc:AAA");	
				Statement stmt=conn.createStatement();
				stmt.executeUpdate("delete from UserMessage where nnname='"+s1+"'");
				
			
			}catch(Exception ee){
				System.out.println(ee);
			}
		}	
		if(ae.getSource()==this.bt4)
		{
			try{
				Frame fds=new Frame();
				Panel cp=new Panel();
				TextArea ta=new TextArea();
				Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
				Connection conn=DriverManager.getConnection("jdbc:odbc:AAA");	
				Statement stmt=conn.createStatement();
				ResultSet rs=stmt.executeQuery("select * from UserMessage");
				while(rs.next())
				{
					ta.append(rs.getString("nnname"));
					ta.append("   ");
					ta.append(rs.getString("aaadmin"));
					ta.append("   ");
					ta.append(rs.getString("sid"));
					ta.append("   ");
					ta.append(rs.getString("address"));
					ta.append("\n");

				}
				cp.add(ta);
				fds.add(cp);
				fds.setSize(500,200);
				fds.setVisible(true);
			
			}catch(Exception ee){
				System.out.println(ee);
			}
		}
		if(ae.getSource()==this.bt5)
		{
			this.nf.dispose();
		}
		
	}
	public static void main(String args[])
	{
		new Longin();
	}
 }