JDBC：预订房间

UI

package com.Test.view; /* 在Motel168客房管理系统中增加客房预订表(RoomOrder) 字段包括客户姓名(customerName)、客户ID(customerID)、国家(customerCountry)、电话(customerTel) 邮政编码(customerZip)、入住时间(customerInTime)、入住天数(customerInDays)、房间号(RoomNo)和房间类型(RoomType) “预订客房”界面(RoomOrderFrame)如下，使用JDBC实现客房预订功能，将客房预订信息插入RoomOrder表中。 */ import javax.swing.*; import com.Test.dao.UsernameDAO; import com.Test.dto.UsernameDTO; import java.awt.*; import java.awt.event.*; public class UsernameDisplay extends JFrame{ private JFrame jf; private JPanel jp; private JLabel name,id,country,tel,code,time,room,type; private JTextField tf1,tf2,tf3,tf4,tf5,tf6; private JComboBox roomlist,typelist; private JButton searchbtn,okbtn,cancelbtn; public UsernameDisplay(){ super("RoomOrder-预订客房"); Container c = this.getContentPane(); jp = new JPanel(); jp.setLayout(new GridLayout(1, 3)); this.setLayout(null); name = new JLabel(); name.setBounds(new Rectangle(140, 50, 60, 35)); name.setText("客户姓名"); this.add(name); tf1 = new JTextField(8); tf1.setBounds(new Rectangle(220, 55, 250, 25)); this.add(tf1); id = new JLabel("客户ID"); id.setBounds(new Rectangle(140,90, 60, 35)); this.add(id); tf2 = new JTextField(8); tf2.setBounds(new Rectangle(220, 95, 250, 25)); this.add(tf2); country = new JLabel("国家"); country.setBounds(new Rectangle(140,130, 200, 30)); this.add(country); tf3 = new JTextField(8); tf3.setBounds(new Rectangle(220, 135, 250, 25)); this.add(tf3); tel = new JLabel("电话"); tel.setBounds(new Rectangle(140, 170, 60, 35)); this.add(tel); tf4 = new JTextField(8); tf4.setBounds(new Rectangle(220, 175, 250, 25)); this.add(tf4); code = new JLabel(); code.setText("邮政编码"); code.setBounds(new Rectangle(140, 215, 220, 25)); this.add(code); tf5 = new JTextField(8); tf5.setBounds(new Rectangle(220, 215, 250, 25)); this.add(tf5); time = new JLabel("入住时间"); time.setBounds(new Rectangle(140, 255, 220, 25)); this.add(time); tf6 = new JTextField(8); tf6.setBounds(new Rectangle(220, 255, 250, 25)); this.add(tf6); JLabel times = new JLabel("入住天数"); times.setBounds(new Rectangle(140, 297, 220, 25)); this.add(times); JTextField tf61 = new JTextField(8); tf61.setBounds(new Rectangle(220, 295, 250, 25)); this.add(tf61); room = new JLabel("房间号"); room.setBounds(new Rectangle(140, 335, 220, 25)); this.add(room); roomlist = new JComboBox(); roomlist.addItem("101"); roomlist.addItem("102"); roomlist.addItem("103"); roomlist.addItem("104"); roomlist.addItem("105"); roomlist.setBounds(new Rectangle(220,335, 250, 25)); this.add(roomlist); type = new JLabel("房间类型"); type.setBounds(new Rectangle(140, 375, 220, 25)); this.add(type); typelist = new JComboBox(); typelist.addItem("普通单人间"); typelist.addItem("普通双人间"); typelist.addItem("普通三人间"); typelist.addItem("总统套房"); typelist.setBounds(new Rectangle(220, 375, 250, 25)); this.add(typelist); searchbtn = new JButton("查询房间"); searchbtn.setBounds(new Rectangle(140, 435, 90, 30)); this.add(searchbtn); okbtn = new JButton("预订客房"); okbtn.setBounds(new Rectangle(260, 435, 90, 30)); this.add(okbtn); cancelbtn = new JButton("重新输入"); cancelbtn.setBounds(new Rectangle(380, 435, 90, 30)); this.add(cancelbtn); //action // MyEventClass handler = new MyEventClass(); // okbtn.addActionListener(handler); this.setSize(590,570); this.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE); this.setLocationRelativeTo(null); this.setVisible(true); cancelbtn.addActionListener(new ActionListener(){ @Override public void actionPerformed(ActionEvent e) { // TODO Auto-generated method stub tf1.setText(""); tf2.setText(""); tf3.setText(""); tf4.setText(""); tf5.setText(""); tf6.setText(""); tf61.setText(""); //roomlist.setSelectedItem("101"); //typelist.setSelectedItem("普通单人间"); roomlist.setSelectedIndex(0); typelist.setSelectedIndex(0); } }); okbtn.addActionListener(new ActionListener() { public void actionPerformed(ActionEvent e) { JButton tempButton=(JButton)e.getSource(); if(tempButton==okbtn) { if(tf1.getText().length()==0) { JOptionPane.showMessageDialog(null,"姓名不能为空！","错误提示",JOptionPane.ERROR_MESSAGE); } else if(tf2.getText().length()==0) { JOptionPane.showMessageDialog(null,"ID不能为空！","错误提示",JOptionPane.ERROR_MESSAGE); } else if(tf3.getText().length()==0) { JOptionPane.showMessageDialog(null,"国家不能为空！","错误提示",JOptionPane.ERROR_MESSAGE); } else if(tf4.getText().length()==0) { JOptionPane.showMessageDialog(null,"电话不能为空！","错误提示",JOptionPane.ERROR_MESSAGE); } else if(tf5.getText().length()==0) { JOptionPane.showMessageDialog(null,"邮政编码不能为空！","错误提示",JOptionPane.ERROR_MESSAGE); } else if(tf6.getText().length()==0) { JOptionPane.showMessageDialog(null,"入住时间不能为空！","错误提示",JOptionPane.ERROR_MESSAGE); } else if(tf61.getText().length()==0) { JOptionPane.showMessageDialog(null,"入住天数不能为空！","错误提示",JOptionPane.ERROR_MESSAGE); } else { String u1 = tf1.getText().trim(); String u2 = tf2.getText().trim(); String u3 = tf3.getText().trim(); String u4 = tf4.getText().trim(); String u5 = tf5.getText().trim(); String u6 = tf6.getText().trim(); String u7 = tf61.getText().trim(); String u8 = roomlist.getSelectedItem().toString(); String u9 = typelist.getSelectedItem().toString(); UsernameDAO userdao = new UsernameDAO(); UsernameDTO userdto = new UsernameDTO(); userdto.setCustomerName(u1); userdto.setCustomerID(u2); userdto.setCustomerCountry(u3); userdto.setCustomerTel(u4); userdto.setCustomerZip(u5); userdto.setCustomerInTime(u6); userdto.setCustomerInDays(u7); userdto.setInDaysRoomNo(u8); userdto.setRoomType(u9); boolean result = userdao.addUser(userdto); if(result) { JOptionPane.showMessageDialog(null, "预订成功！"); } else { JOptionPane.showMessageDialog(null, "预订失败！"); } } } } }); } public static void main(String[] args) { new UsernameDisplay(); } }

DAO

/** * 千枝竞秀有天皆丽日，万木争荣无地不春风 * Author: RoniZeng * Time：17/12/25 */ package com.Test.dao; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.Statement; import java.util.ArrayList; import java.util.List; import com.Test.Util.DBUtil; import com.Test.dto.UsernameDTO; public class UsernameDAO { public boolean addUser(UsernameDTO user) { Connection conn = null; PreparedStatement statement = null; try { conn = DBUtil.getConnection(); String sql = "insert into RoomOrder values(?,?,?,?,?,?,?,?,?)"; statement = conn.prepareStatement(sql); statement.setString(1, user.getCustomerName()); statement.setString(2, user.getCustomerID()); statement.setString(3, user.getCustomerCountry()); statement.setString(4, user.getCustomerTel()); statement.setString(5, user.getCustomerZip()); statement.setString(6, user.getCustomerInTime()); statement.setString(7, user.getCustomerInDays()); statement.setString(8, user.getInDaysRoomNo()); statement.setString(9, user.getRoomType()); int result = statement.executeUpdate(); if(result>0) { return true; } else { return false; } } catch(Exception e) { e.printStackTrace(); return false; } finally { try { statement.close(); conn.close(); } catch(Exception e1) { e1.printStackTrace(); } } } }

DTO

package com.Test.dto; public class UsernameDTO { private String customerName, customerID, customerCountry; private String customerTel, customerZip, customerInTime; private String customerInDays, InDaysRoomNo, RoomType; public String getCustomerName() { return customerName; } public void setCustomerName(String customerName) { this.customerName = customerName; } public String getCustomerID() { return customerID; } public void setCustomerID(String customerID) { this.customerID = customerID; } public String getCustomerCountry() { return customerCountry; } public void setCustomerCountry(String customerCountry) { this.customerCountry = customerCountry; } public String getCustomerTel() { return customerTel; } public void setCustomerTel(String customerTel) { this.customerTel = customerTel; } public String getCustomerZip() { return customerZip; } public void setCustomerZip(String customerZip) { this.customerZip = customerZip; } public String getCustomerInTime() { return customerInTime; } public void setCustomerInTime(String customerInTime) { this.customerInTime = customerInTime; } public String getCustomerInDays() { return customerInDays; } public void setCustomerInDays(String customerInDays) { this.customerInDays = customerInDays; } public String getInDaysRoomNo() { return InDaysRoomNo; } public void setInDaysRoomNo(String inDaysRoomNo) { InDaysRoomNo = inDaysRoomNo; } public String getRoomType() { return RoomType; } public void setRoomType(String roomType) { RoomType = roomType; } }

DBUtil

package com.Test.Util; import java.sql.Connection; import java.sql.DriverManager; public class DBUtil { public static Connection getConnection(){ try{ Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver"); Connection conn = DriverManager.getConnection("jdbc:sqlserver://localhost:1433;databaseName=HappyDB;user=sa;password=123456"); return conn; } catch (Exception e) { } return null; } }