server1.java

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

package fram_login;

import java.awt.BorderLayout;
import java.awt.Color;
import java.awt.Container;
import java.awt.Dimension;
import java.awt.Font;
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.Icon;
import javax.swing.ImageIcon;
import javax.swing.JButton;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JOptionPane;
import javax.swing.JPanel;
import javax.swing.JPasswordField;
import javax.swing.JProgressBar;
import javax.swing.JRadioButton;
import javax.swing.JTextField;
import javax.swing.Timer;
import javax.swing.UIManager;

@SuppressWarnings("serial")
public class Server1 extends JFrame implements ActionListener{
	private JLabel username,password;
	private JTextField username2;
	private JPasswordField  password2;
	private JButton cancle,log_button;
	private JRadioButton teacher,student;
	private ButtonGroup buttongroup;
	private JPanel buttonpanel;
	boolean tea=false,stu=false;
	boolean flag1=false;
	
	  
	public Server1()
	{
		super("网络考试后台管理登录窗口");
		setSize(360,250);
		try{
			UIManager.setLookAndFeel(UIManager.getSystemLookAndFeelClassName());			
		}catch(Exception e){  
			
		}
		Container container=getContentPane();	
		buttonpanel=new JPanel();
		buttonpanel.setBackground(Color.CYAN);
		buttonpanel.setLayout(null);
		username=new JLabel("用户名:",JLabel.RIGHT);
		password=new JLabel("密  码:",JLabel.RIGHT);
		username2=new JTextField(20);
		password2=new JPasswordField(15);		
		log_button=new JButton("登录");
		log_button.addActionListener(this);	
		cancle=new JButton("取消");	
		cancle.addActionListener(this);		
		username.setBounds(60,50,50,25);
		username2.setBounds(120,50,120,25);
		password.setBounds(57,85,50,25);
		password2.setBounds(120,85,120,25);
		log_button.setBounds(130,145,60,25);
		cancle.setBounds(220,145,60,25);
		buttonpanel.add(username);
		buttonpanel.add(username2);
		buttonpanel.add(password);
		buttonpanel.add(password2);
		buttonpanel.add(log_button);
		buttonpanel.add(cancle);
		container.add(buttonpanel,BorderLayout.CENTER);   
		setVisible(true);	
		setDefaultCloseOperation(EXIT_ON_CLOSE);	
	}

	public void actionPerformed(ActionEvent e) {
		// TODO 自动生成方法存根
		String pw=new String(password2.getPassword());
		Connection con = null;
		PreparedStatement pst = null;
		ResultSet rs = null;		
		String driverName = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
		String url = "jdbc:microsoft:sqlserver://localhost:1433; DatabaseName=test_with_net";
		String username = "sa";
		String password = "";	
		try {
			Class.forName(driverName);
		} catch (ClassNotFoundException e1) {
			// TODO 自动生成 catch 块
			e1.printStackTrace();
		} 
		try {
			con = DriverManager.getConnection(url, username, password);
			if(e.getSource()==log_button )
			{    	
								//按管理员登录
				
				    pst = con.prepareStatement("select * from test_with_net.dbo.administrator");		    
				    rs=pst.executeQuery();		    				  
					while(rs.next() && flag1==false)
					{				
							if(rs.getString("adname").equals(username2.getText()) && rs.getString("adpass").equals(pw))
							{							  
								flag1=true;
							}		
							else
							{
								flag1=false;
							}							
					}
						if(flag1==true)
						{
							JFrame.setDefaultLookAndFeelDecorated(true);
							//new ServerGui();
							JOptionPane.showMessageDialog(null, "登录成功！");		
						
				    		this.dispose();
						}
						else
						{
							JOptionPane.showMessageDialog(null, "后台管理登录失败,可能是用户名和密码输入错误，请重新输入");		
							username2.setText("");
							password2.setText("");
						}			
					}				
			
					//选择登录按钮的时间完毕！
			
		} catch (SQLException e1) {
			// TODO 自动生成 catch 块
			e1.printStackTrace();
		}
						    				      		   
		if(e.getSource()==cancle)
		{
			System.exit(0);
		}		
	}	
	public static void main(String args[])
	{
		new Server1();
	}	
}