stu.java

通过数据库录入学生数据信息

package stu;
import java.awt.BorderLayout;
import java.awt.CardLayout;
import java.awt.Color;
import java.awt.Container;
import java.awt.FlowLayout;
import java.awt.GridLayout;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.awt.event.ItemEvent;
import java.awt.event.ItemListener;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

import javax.swing.ButtonGroup;
import javax.swing.JButton;
import javax.swing.JComboBox;
import javax.swing.JDialog;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JPanel;
import javax.swing.JRadioButton;
import javax.swing.JScrollPane;
import javax.swing.JSplitPane;
import javax.swing.JTable;
import javax.swing.JTextArea;
import javax.swing.JTextField;
import javax.swing.JTree;
import javax.swing.event.TreeSelectionEvent;
import javax.swing.event.TreeSelectionListener;
import javax.swing.tree.DefaultMutableTreeNode;

import fram_login.Login;
import pane_query.Pane1;
import pane_showmessage.Pane;
import pane_xiugai.Pane2;
import pane_delete.Pane3;

public class Stu extends JFrame implements TreeSelectionListener {
	/*
	 */	
	public static  int N1=9;
	public static  int N2=60;
	public static Stu st;	
	JTree tree=null;
	public static JPanel p=new JPanel();
	        Pane   sp0=new Pane();
			Pane1  sp1=new Pane1();
			Pane2  sp2=new Pane2();
			Pane3  sp3=new Pane3();
			public static CardLayout car=new CardLayout();
			public static Connection conn=null;
			public static PreparedStatement pstmt=null;
			static String driverName = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
            static String url = "jdbc:microsoft:sqlserver://localhost:1433; DatabaseName=学生管理系统";
			static String username = "sa";
			static String password = "";
			public Stu()
			{
				super("学生管理系统");
				try{
					Class.forName(driverName);
				}catch (ClassNotFoundException e) {
					// TODO 自动生成 catch 块
					
				} 
				
					try {
						conn = DriverManager.getConnection(Stu.url, "sa",
								"");
						
					} catch (SQLException e) {
						// TODO: handle exception
					}					
			Container con=getContentPane();
			setSize(700,500);
			setLocation(100,100);
			DefaultMutableTreeNode root =new DefaultMutableTreeNode("学生管理系统                     ");
			DefaultMutableTreeNode t11 =new DefaultMutableTreeNode("查询人员");
			DefaultMutableTreeNode t12 =new DefaultMutableTreeNode("添加信息");
			DefaultMutableTreeNode t13 =new DefaultMutableTreeNode("修改信息");
			DefaultMutableTreeNode t14 =new DefaultMutableTreeNode("删除信息");
			root.add(t11);
			root.add(t12);
			root.add(t13);
			root.add(t14);
			tree =new JTree(root);
			p.setLayout(car);
			p.add("0",sp0);			
			p.add("1",sp1);
			p.add("2",sp2);
			JSplitPane sp=new JSplitPane(JSplitPane.HORIZONTAL_SPLIT,true,tree,p);
			sp.setEnabled(false);
			tree.addTreeSelectionListener(this);
			con.add(sp);
			setVisible(true);
			setResizable(false);
		}
			public void valueChanged(TreeSelectionEvent e)
			{
				if(e.getSource()==tree)
				{
					DefaultMutableTreeNode node=(DefaultMutableTreeNode)tree.getLastSelectedPathComponent();
					String str=node.toString();
					if(str.equals("学生管理系统                     "))
							   car.show(p, "0");						
						else if(str.equals("查询人员")) car.show(p, "1");
						 else if(str.equals("添加信息")) car.show(p, "2");
						  else if(str.equals("修改信息")) car.show(p, "1");
						    else if(str.equals("删除信息")) car.show(p, "1");
						
			     }
				
			}
	
			public static void main(String args[])throws SQLException
			{			  			     	     
				   st=new Stu();			
			} 
			
}