package ms;
//���û�ע��
import java.awt.BorderLayout;
import java.awt.GridLayout;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;

import javax.swing.JButton;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JOptionPane;
import javax.swing.JPanel;
import javax.swing.JTextField;

public class New_User extends JFrame{
	JLabel tips1,tips2,tips3,tips4;
	JTextField wbk1,wbk2,wbk3,wbk4;
	JButton check_btn;
	JPanel mb1,mb2,mb3,mb4;
	
	String username;
	Connection conn=null;
	
	public New_User()
	{
		tips1=new JLabel("��ʾ���������û���");
		tips2=new JLabel("��ʾ�����루5λ��");
		tips3=new JLabel("��ʾ���������Ա�");
		tips4=new JLabel("��ʾ��������绰");
		
		wbk1=new JTextField(6);
		wbk2=new JTextField(6);
		wbk3=new JTextField(6);
		wbk4=new JTextField(9);
		check_btn=new JButton("�ύ");
		check_btn.addActionListener(new checkListen());
		mb1=new JPanel();
		mb2=new JPanel();
		

		mb1.add(wbk1);mb1.add(tips1);
		mb1.add(wbk2);mb1.add(tips2);
		mb1.add(wbk3);mb1.add(tips3);
		mb1.add(wbk4);mb1.add(tips4);
		mb2.add(check_btn,BorderLayout.NORTH);
		mb1.setLayout(new GridLayout(4,2));
		
		this.add(mb1,BorderLayout.CENTER);this.add(mb2,BorderLayout.SOUTH);
		
		this.setVisible(true);
		this.setSize(350,200);
		this.setLocationRelativeTo(null);//������ʾ
	}

	class checkListen implements ActionListener
	{
		@Override
		public void actionPerformed(ActionEvent e) {
			// TODO �Զ���ɵķ������
			IDB();
		
			pipei();
			
			if(wbk1.getText().equals("")||wbk2.getText().equals(""))//�ж��ı����Ƿ�Ϊ��һ��Ҫ��equals
			{JOptionPane.showMessageDialog(null, "�û�������벻��Ϊ�գ�");}
			
			else if(username!=null)
			{
				JOptionPane.showMessageDialog(null, "�û����ѱ�ע�ᣡ");	
			}
			
			else{
				
				charu();
				JOptionPane.showMessageDialog(null, "ע��ɹ���");
			}
		}
	}
//������ݿ�
	public void IDB()
	{
		
		try{
			
			Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
			String url="jdbc:sqlserver://localhost:1433;DatabaseName=��ѧ��У԰��ʳ����";
			String user="sa";
			String passWord="lch";
			conn=DriverManager.getConnection(url,user,passWord);
				
		}catch(Exception e){
			e.printStackTrace();
		}
	}
	//��ȡ��ݿ�����Ӧ��
	public void pipei()
	{
		try{
		String usname = wbk1.getText();
		Statement state = conn.createStatement();
		username=null;//�ǵó�ʼ��
		String sql = "select username  from login  where username = '"+usname+"'";
		ResultSet res = state.executeQuery(sql);
		while(res.next())
		{						
			 username = res.getString("username");
		}
		//conn.close();
	   }catch(Exception e){
			e.printStackTrace();
		}
	}
	//������
	public void charu()
	{
		String uname=wbk1.getText();
		String psword=wbk2.getText();
		String sex=wbk3.getText();
		String phone=wbk4.getText();
		try{
		Statement statement=conn.createStatement();
		statement.execute("insert into login values('"+uname+"','"+psword+"','"+sex+"','"+phone+"')");
		conn.close();
		}catch(Exception e){
			
		}
	}
	
}