?? dingroomframe1.java
字號:
package cg;
import java.awt.BorderLayout;
import java.awt.Dimension;
import javax.swing.JFrame;
import javax.swing.JPanel;
import javax.swing.JLabel;
import java.awt.Rectangle;
import javax.swing.JTextField;
import javax.swing.JComboBox;
import javax.swing.BorderFactory;
import java.awt.Color;
import javax.swing.JTextArea;
import javax.swing.JButton;
import javax.swing.*;
import java.awt.*;
import java.sql.*;
import java.awt.event.*;
class dingRoomFrame1 extends JFrame implements ActionListener,ItemListener{
public Connection con;
public static String h2omane;
public odbc dbo=new odbc();
String [] str={"1","0"};
JPanel contentPane;
JLabel jLabel1 = new JLabel();
JComboBox jComboBox1 = new JComboBox(dbo.getAllTabelName1());
JLabel jLabel2 = new JLabel();
JLabel jLabel3 = new JLabel();
JLabel jLabel4 = new JLabel();
JLabel jLabel5 = new JLabel();
JLabel jLabel6 = new JLabel();
JLabel jLabel7 = new JLabel();
JLabel jLabel8 = new JLabel();
JLabel jLabel10 = new JLabel();
JLabel jLabel12 = new JLabel();
JLabel jLabel14 = new JLabel();
JLabel jLabel15 = new JLabel();
JComboBox jComboBox2 = new JComboBox(str);
JLabel jLabel16 = new JLabel();
JTextArea jTextArea1 = new JTextArea();
JButton jButton1 = new JButton();
JButton jButton2 = new JButton();
JLabel jLabel17 = new JLabel();
JTextField jTextField1 = new JTextField();
JTextField jTextField2 = new JTextField();
JTextField jTextField3 = new JTextField();
JLabel jLabel9 = new JLabel();
JTextField jTextField4 = new JTextField();
public dingRoomFrame1(){
contentPane = (JPanel) getContentPane();
contentPane.setLayout(null);
setSize(new Dimension(515, 252));
setTitle("Frame Title");
jLabel1.setText("客房編號");
jLabel1.setBounds(new Rectangle(17, 14, 53, 25));
jComboBox1.setBounds(new Rectangle(74, 20, 70, 22));
jLabel2.setText("客房種類");
jLabel2.setBounds(new Rectangle(166, 14, 53, 25));
jLabel3.setBorder(BorderFactory.createLoweredBevelBorder());
jLabel3.setBounds(new Rectangle(225, 20, 70, 22));
jLabel4.setText("客房位置");
jLabel4.setBounds(new Rectangle(329, 14, 53, 25));
jLabel5.setBorder(BorderFactory.createLoweredBevelBorder());
jLabel5.setBounds(new Rectangle(393, 20, 82, 22));
jLabel6.setText("客房單價");
jLabel6.setBounds(new Rectangle(16, 69, 53, 25));
jLabel7.setBorder(BorderFactory.createLoweredBevelBorder());
jLabel7.setBounds(new Rectangle(75, 69, 70, 22));
jLabel8.setText("顧客姓名");
jLabel8.setBounds(new Rectangle(165, 69, 53, 25));
jLabel10.setText("顧客身份證號碼");
jLabel10.setBounds(new Rectangle(307, 69, 94, 25));
jLabel12.setDisplayedMnemonic('0');
jLabel12.setHorizontalAlignment(SwingConstants.LEFT);
jLabel12.setText("入住日期");
jLabel12.setBounds(new Rectangle(15, 122, 53, 25));
jLabel14.setBorder(null);
jLabel14.setText("折扣");
jLabel14.setBounds(new Rectangle(151, 122, 34, 22));
jLabel15.setBorder(BorderFactory.createLoweredBevelBorder());
jLabel15.setBounds(new Rectangle(191, 122, 51, 21));
jComboBox2.setBounds(new Rectangle(447, 122, 53, 22));
jLabel16.setText("備注信息");
jLabel16.setBounds(new Rectangle(251, 122, 55, 25));
jTextArea1.setBounds(new Rectangle(303, 123, 65, 59));
jButton1.setBounds(new Rectangle(15, 181, 60, 23));
jButton1.setText("登記");
jButton2.setBounds(new Rectangle(91, 181, 60, 23));
jButton2.setText("取消");
jLabel17.setText("是否入住");
jLabel17.setBounds(new Rectangle(387, 122, 53, 25));
jTextField1.setBounds(new Rectangle(221, 69, 70, 22));
jTextField2.setBounds(new Rectangle(404, 69, 94, 22));
jTextField3.setBounds(new Rectangle(75, 124, 70, 22));
//jTextField3.addActionListener(new Frame_jTextField3_actionAdapter(this));
jLabel9.setText("賬單號");
jLabel9.setBounds(new Rectangle(380, 156, 41, 25));
jTextField4.setBounds(new Rectangle(429, 158, 70, 22));
contentPane.add(jLabel7);
contentPane.add(jLabel3);
contentPane.add(jLabel8);
contentPane.add(jLabel10);
contentPane.add(jLabel14);
contentPane.add(jLabel15);
contentPane.add(jLabel16);
contentPane.add(jLabel5);
contentPane.add(jLabel4);
contentPane.add(jLabel1);
contentPane.add(jComboBox1);
contentPane.add(jLabel2);
contentPane.add(jLabel6);
contentPane.add(jLabel12);
contentPane.add(jTextField1);
contentPane.add(jTextField3);
contentPane.add(jTextField2);
contentPane.add(jComboBox2);
contentPane.add(jLabel17);
contentPane.add(jTextField4);
contentPane.add(jButton1);
contentPane.add(jButton2);
contentPane.add(jTextArea1);
contentPane.add(jLabel9);
jButton1.addActionListener(this);
jButton2.addActionListener(this);
jComboBox1.addItemListener(this);
jButton1.setActionCommand("true");
jButton2.setActionCommand("false");
this.setTitle("訂房窗口");
this.setSize(520,245);
this.setResizable(false);
//this.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
this.setLocationRelativeTo(this);
this.setVisible(true);
}
public void itemStateChanged(ItemEvent i){
int in=i.getStateChange();
if(in==ItemEvent.SELECTED){
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con = DriverManager.getConnection("jdbc:odbc:myOdbc", "sa", "");
int a=jComboBox1.getSelectedIndex()+1; //得到選擇的行
String strno=(String)jComboBox1.getSelectedItem(); //得到下拉元素
System.out.println (a);
System.out.println (strno);
//if(a==1){
String strSql = "select * from footinfo where 客房編號=";
PreparedStatement ps=con.prepareStatement(strSql+strno);
System.out.println (strSql+strno);
ResultSet rs=ps.executeQuery();
while(rs.next()){
jLabel3.setText(rs.getString(2));
jLabel5.setText(rs.getString(3));
jLabel7.setText(rs.getString(4));
jLabel15.setText(String.valueOf(rs.getFloat(5)));
//jTextArea1.setText(rs.getString(5));
}
}catch (Exception sqle){
sqle.printStackTrace();
JOptionPane.showMessageDialog(this, "寫入數據失敗！", "失敗", JOptionPane.ERROR_MESSAGE);
System.out.println ("媽呀出錯了！");
}
}
}
public void actionPerformed(ActionEvent e){
String str=e.getActionCommand();
if(str.equals("true")){
String box1=(String)jComboBox1.getSelectedItem();
int in=Integer.parseInt(box1); //1
System.out.println (box1);
String box2=(String)jLabel3.getText(); //2
System.out.println (box2);
String box3=(String)jLabel5.getText(); //3
System.out.println (box3);
String box4=(String)jLabel7.getText();
float flo=Float.parseFloat(box4); //4
System.out.println (flo);
String txt1=jTextField1.getText(); //5
System.out.println (txt1);
String txt2=jTextField2.getText(); //6
System.out.println (txt2);
String txt3=jTextField3.getText(); //7
System.out.println (txt3);
String box5=(String)jLabel15.getText();
float fl=Float.parseFloat(box5); //8
System.out.println (fl);
String tax1=jTextArea1.getText(); //9
System.out.println (tax1);
String box6=(String)jComboBox2.getSelectedItem(); //10
int f=Integer.parseInt(box6);
String txt4=jTextField4.getText();
int o=Integer.parseInt(txt4); //流水號
String h2omane=jTextField4.getText(); //得到流水號String
System.out.println ("h2omane第一次號"+h2omane);
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con = DriverManager.getConnection("jdbc:odbc:myOdbc", "sa", "");
Statement sta = con.createStatement();
String strSql = "insert into dingfangxinxi(客房編號,客房種類,客房位置,客房單價,顧客姓名,顧客身份證號碼,入住日期,折扣,備注信息,賬單流水號) values (?,?,?,?,?,?,?,?,?,?)";
PreparedStatement ps=con.prepareStatement(strSql);
ps.setInt(1,in);
ps.setString(2,box2);
ps.setString(3,box3);
ps.setFloat(4,flo);
ps.setString(5,txt1);
ps.setString(6,txt2);
ps.setString(7,txt3);
ps.setFloat(8,fl);
ps.setString(9,tax1);
// ps.setFloat(10,f); //是否入住
ps.setInt(10,o); //插入流水號
ps.executeUpdate();
String strno=(String)jComboBox1.getSelectedItem(); //得到客編
String strSql1 ="update footinfo set 是否入住=?";
String strno1=" where 客房編號=";
System.out.println ("是否入住"+f);
System.out.println (strSql1+strno1+strno);
PreparedStatement pss =con.prepareStatement(strSql1+strno1+strno);
pss.setInt(1,f);
pss.executeUpdate();
System.out.println ("1或0插入成");
JOptionPane.showMessageDialog(this, "登記成功！", "成功", JOptionPane.INFORMATION_MESSAGE);
// sta.close();
}catch (Exception sqle){
sqle.printStackTrace();
JOptionPane.showMessageDialog(this, "寫入數據失敗！", "失敗", JOptionPane.ERROR_MESSAGE);
System.out.println ("出錯aaa");
}
}
if(str.equals("false")){
this.setVisible(false);;
}
}
} ?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -