userinfo.java

这个一个用j2se实现的汽车销售管理系统

package gax.eclipse.bajie;
import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import javax.swing.event.*;
import java.util.*;
import java.sql.*;
public class UserInfo extends JPanel implements ActionListener {
    /*
     * 用户登记：
        车牌编号
       车主姓名
       车主性别
       身份证号
       联系方式
       车主住址
       购车时间
    */
	private JLabel lbNum=new JLabel("车牌编号：");
	private JLabel lbName=new JLabel("车主姓名：");
	private JLabel lbSex=new JLabel("车主性别：");
	private JLabel lbID=new JLabel("身份证号：");
	private JLabel lbTel=new JLabel("联系方式：");
	private JLabel lbAddr=new JLabel("车主住址：");
	private JLabel lbTime=new JLabel("购车时间：");

	
	private JTextField tfNum=new JTextField(" ",10);
	private JTextField tfName=new JTextField(" ",10);
	private JRadioButton rbtmen=new JRadioButton("男");
	private JRadioButton rbtwomen=new JRadioButton("女");
	private ButtonGroup groupone=new ButtonGroup();
	private JTextField tfID=new JTextField(" ",10);
	private JTextField tfTel=new JTextField(" ",10);
	private JTextField tfAddr=new JTextField(" ",10);
	private JTextField tfTime=new JTextField(" ",10);
	
	
	private JLabel lbTitle=new JLabel("欢迎进入用户信息注册界面",JLabel.CENTER);
	private JButton btnLogin=new JButton("注册");
	private JButton btnCancle=new JButton("取消");
	
	
	public UserInfo()
	{
		
		
		this.init();
		this.setBackground(Color.green);
		this.setVisible(true);
		
	}
	public void init()
	{
		//设置标签左面板
		JPanel pleft=new JPanel();
		pleft.setLayout(new GridLayout(7,1,3,3));
		pleft.add(lbNum);
		pleft.add(lbName);
		pleft.add(lbSex);
		pleft.add(lbID);
		pleft.add(lbTel);
		pleft.add(lbAddr);
		pleft.add(lbTime);
	    lbNum.setForeground(Color.red);
	    lbName.setForeground(Color.red);
	    lbSex.setForeground(Color.red);
	    lbID.setForeground(Color.red);
	    lbTel.setForeground(Color.red);
	    lbAddr.setForeground(Color.red);
	    lbTime.setForeground(Color.red);
	    rbtmen.setForeground(Color.BLUE);
	    rbtwomen.setForeground(Color.blue);
	    pleft.setBackground(Color.green);
		
		//设置文本框面板
		JPanel pright=new JPanel();
		pright.setLayout(new GridLayout(7,1,3,3));
		pright.add(tfNum);
		pright.add(tfName);
		
		//处理性别单选框
		JPanel psex=new JPanel();
		psex.add(rbtmen);
		psex.add(rbtwomen);
		groupone.add(rbtmen);
		groupone.add(rbtwomen);
		rbtmen.setSelected(true);
		pright.add(psex);
		pright.add(tfID);
		pright.add(tfTel);
		pright.add(tfAddr);
		pright.setBackground(Color.green);
		
		//添加年份  月份 日期
		
		pright.add(tfTime);
		
		JPanel pbuttom=new JPanel();
		pbuttom.add(btnLogin);
		pbuttom.add(btnCancle);
		Color color=new Color(13,220,154);
		btnLogin.setForeground(color);
		btnCancle.setForeground(color);
		btnLogin.addActionListener(this);
		btnCancle.addActionListener(this);
		pbuttom.setBackground(Color.green);
		
		JPanel pMid=new JPanel();
		pMid.setLayout(new BorderLayout());
		pMid.add(pleft,"West");
		pMid.add(pright,"East");
		pMid.setBackground(Color.green);
		
		JPanel panelTop=new JPanel();
		Font font=new Font("楷体",Font.HANGING_BASELINE,20);
		panelTop.setBackground(Color.green);
		lbTitle.setForeground(Color.DARK_GRAY);
		lbTitle.setFont(font);
		panelTop.add(lbTitle);
		
		JPanel pAll=new JPanel();
		pAll.setLayout(new BorderLayout());
		pAll.add(panelTop,"North");
		pAll.add(pMid,"Center");
		pAll.add(pbuttom,"South");
		this.add(pAll);
		
	}
	public void actionPerformed(ActionEvent e)
	{
		if(e.getSource()==btnLogin)
		{
			dealBtnLogin();
		}
		else if(e.getSource()==btnCancle)
		{
			dealBtnCanle();
		}
	}
	public void dealBtnLogin()
	{
		try
		{
			String sql="insert into UserInfo  values(?,?,?,?,?,?,?)";
		    String 	Num=tfNum.getText();
		    String	Name=tfName.getText();
		    //处理单选按钮组中的数值
		    String Sex=getSex(groupone);
			String  ID=tfID.getText();
			String Tel=tfTel.getText();
			String Addr=tfAddr.getText();
			String Time=tfTime.getText();
		     if(Num.equals(" "))
		     {
		    	 JOptionPane.showMessageDialog(this, "编号不能空");
		     }
		     else if(Name.equals(" "))
		     {
		    	 JOptionPane.showMessageDialog(this, "姓名不能为空！");
		     }
		     else if(ID.equals(" "))
		     {
		    	 JOptionPane.showMessageDialog(this, "身份证号码不能为空！");
		     }
		     else if(Tel.equals(" "))
		    {
		    	JOptionPane.showMessageDialog(this, "电话号码不能为空！"); 
		     }
		     else if(Addr.equals(" "))
		     {
		    	 JOptionPane.showMessageDialog(this, "家庭住址不能为空！");
		     }
		     else if(Time.equals(" "))
		     {
		    	 JOptionPane.showMessageDialog(this, "家庭住址不能为空！");
		     }
		     else
		     {
			    ConToDB DB=new ConToDB();
			  DB.LinkDB();
			   PreparedStatement st=DB.con.prepareStatement(sql);
			
			  st.setString(1, Num);
			  st.setString(2, Name);
			  st.setString(3, Sex);
			  st.setString(4, ID);
			  st.setString(5, Tel);
		   	  st.setString(6, Addr);
			  st.setString(7, Time);
			
	          int i=st.executeUpdate();
			  if(i>=0)
			      JOptionPane.showMessageDialog(this, "用户信息注册成功！");
			  else 
				JOptionPane.showMessageDialog(this, "用户信息注册失败，请核实信息的完整性！");
		     }
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
	}
	public String getSex(ButtonGroup g)
	{
		if(g.getSelection()==rbtmen.getModel())
			return "男";
		else 
			return "女";
	}
	public void dealBtnCanle()
	{
		try
		{
			
             tfNum.setText("");
             tfName.setText("");
             tfID.setText("");
             tfTel.setText("");
             tfTime.setText("");
             tfAddr.setText("");
             rbtmen.setSelected(true);
			
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
	}
	public static void main(String [] args)
	{
		new UserInfo();
	}
}