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){
			
		}
	}
	
}