add.java

完成课程设计

package 客房管理;

import javax.swing.*;
import java.awt.event.*;
import java.sql.*;

public class Add extends JFrame implements ActionListener
{
	/**
	 * 
	 */
	private static final long serialVersionUID = 1L;
	JLabel lNo,lName,lSex,lAge,lIdentication,lAddress,lWorkPlace,lFrom,lRoomNo,lWillIn,lIn,lLeave,lCash;
	JTextField tNo,tName,tSex,tAge,tIdentication,tAddress,tWorkPlace,tFrom,tRoomNo,tWillIn,tIn,tLeave,tCash;
	JButton bAdd,bBack;
	JPanel panelMain,panel1,panel2,panel3,panel4,panel5,panel6,panel7,panel8,panel9,panel10;
	
	public Add()
	{
		super("客户登记");
		panelMain=new JPanel();
		this.setContentPane(panelMain);
		//panelMain.setLayout(new GridLayout(5,2));
		
		lNo=new JLabel("编号");
		lName=new JLabel("姓名");
		tNo=new JTextField(10);
		tName=new JTextField(10);
		panel1=new JPanel();
		panel1.add(lNo);panel1.add(tNo);panel1.add(lName);panel1.add(tName);
		
		lSex=new JLabel("性别");
		lAge=new JLabel("年龄");
		tSex=new JTextField(10);
		tAge=new JTextField(10);
		panel2=new JPanel();
		panel2.add(lSex);panel2.add(tSex);panel2.add(lAge);panel2.add(tAge);
		
		
		lAddress=new JLabel("家庭地址");
		tAddress=new JTextField(21);
		panel3=new JPanel();
		panel3.add(lAddress);panel3.add(tAddress);
		
		lIdentication=new JLabel("身份证号码");
		tIdentication=new JTextField(20);
		panel6=new JPanel();
		panel6.add(lIdentication);panel6.add(tIdentication);
		
		
		lFrom=new JLabel("来自");
		tFrom=new JTextField(13);
		panel4=new JPanel();
		panel4.add(lFrom);panel4.add(tFrom);
		
		lWorkPlace=new JLabel("工作单位");
		tWorkPlace=new JTextField(21);
		panel7=new JPanel();
		panel7.add(lWorkPlace);panel7.add(tWorkPlace);
		
		lRoomNo=new JLabel("客房名");
		tRoomNo=new JTextField(5);
		panel5=new JPanel();
		panel5.add(lRoomNo);panel5.add(tRoomNo);
		
		lWillIn=new JLabel("预定入住时间");
		lIn=new JLabel("入住时间");
		tWillIn=new JTextField(8);
		tIn=new JTextField(8);
		panel9=new JPanel();
		panel9.add(lWillIn);panel9.add(tWillIn);panel9.add(lIn);panel9.add(tIn);
		
		lLeave=new JLabel("离开时间");
		lCash=new JLabel("押金");
		tLeave=new JTextField(11);
		tCash=new JTextField(11);
		panel10=new JPanel();
		panel10.add(lLeave);panel10.add(tLeave);panel10.add(lCash);panel10.add(tCash);
		
		bAdd=new JButton("添加");
		bAdd.addActionListener(this);
		bBack=new JButton("返回");
		bBack.addActionListener(this);
		panel8=new JPanel();
		panel8.add(bAdd);panel8.add(bBack);
		
		panelMain.add(panel1);panelMain.add(panel2);panelMain.add(panel3);panelMain.add(panel4);panelMain.add(panel5);panelMain.add(panel6);panelMain.add(panel7);
		panelMain.add(panel9);panelMain.add(panel10);panelMain.add(panel8);
		setBounds(400,200,500,500);
		setVisible(true);
	}
	
	public void actionPerformed(ActionEvent ae)
	{
		if(ae.getSource()==bBack)
		{
			dispose();
		}
		else if(ae.getSource()==bAdd)
		{
			if(tNo.getText().equals("") || tName.getText().equals("") || tSex.getText().equals("")||tAge.getText().equals("")||tAddress.getText().equals("")||tIdentication.getText().equals("")||tWorkPlace.getText().equals("")||tFrom.getText().equals("")||tRoomNo.getText().equals("")||tWillIn.getText().equals("")||tIn.getText().equals("")||tCash.getText().equals(""))
			{
				JOptionPane.showMessageDialog(null,"添加信息不能为空!","提示",JOptionPane.ERROR_MESSAGE);
			}
			else
			{
				String a1,a2,a3,a4,a5,a6,a7,a8,a9,a10,a11;
				
				int r;
				a1="'"+tName.getText().trim()+"'";
				a2="'"+tSex.getText().trim()+"'";
				a3="'"+tAge.getText().trim()+"'";
				a4="'"+tIdentication.getText().trim()+"'";
				a5="'"+tAddress.getText().trim()+"'";
				a6="'"+tWorkPlace.getText().trim()+"'";
				a7="'"+tFrom.getText().trim()+"'";
				a8="'"+tRoomNo.getText().trim()+"'";
				a9="'"+tWillIn.getText().trim()+"'";
				a10="'"+tIn.getText().trim()+"'";
				a11="'"+tLeave.getText().trim()+"'";
				int i = Integer.valueOf(tCash.getText()).intValue();
				String b="insert into 客人信息 (客房编号,姓名,性别,年龄,身份证号码,家庭住址,工作单位,来自地的地名,预定入住时间,入住时间,离店时间,押金) VALUES ("+a8+","+a1+","+a2+","+a3+","+a4+","+a5+","+a6+","+a7+","+a9+","+a10+","+a11+","+i+")";
				Connection conn;
				PreparedStatement stat;
				try
				{
					Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
					conn=DriverManager.getConnection("jdbc:odbc:客房管理","sa","");					
					stat=conn.prepareStatement(b);
					r=stat.executeUpdate();
					if(r<1)
					{
						JOptionPane.showMessageDialog(null,"添加失败!","提示",JOptionPane.ERROR_MESSAGE);
					}
					else
					{
						JOptionPane.showMessageDialog(null,"添加成功!","提示",JOptionPane.INFORMATION_MESSAGE);
					}
					conn.close();
					
				}
				catch(Exception e)
				{
					e.printStackTrace();
				}
			}
		}
	}
	
	/*public static void main(String[] args) 
	{
			new Add();
	}*/

}