Java实现酒店客房管理系统

package loginManage;import java.awt.Color;import java.awt.EventQueue;import java.awt.event.ActionEvent;import java.awt.event.ActionListener;import javax.swing.JButton;import javax.swing.JFrame;import javax.swing.JLabel;import javax.swing.JOptionPane;import javax.swing.JPasswordField;import javax.swing.JTextField;import com.mysql.jdbc.Connection;import com.mysql.jdbc.PreparedStatement;import com.mysql.jdbc.ResultSet;import com.swtdesigner.SwingResourceManager;import db.JDBC;public class LoginFrame { private JLabel label; private JButton button; private JButton btnregister; private JButton btnreset; private JButton btnlogin; private JLabel labpwd; private JLabel labUserName; private JPasswordField textpwd; private JTextField textUsername; public JFrame frame;  public static void main(String args[]) { EventQueue.invokeLater(new Runnable() {  public void run() {  try {   LoginFrame window = new LoginFrame();      window.frame.setVisible(true);  } catch (Exception e) {   e.printStackTrace();  }  } }); }  public LoginFrame() { createContents(); }  private void createContents() { frame = new JFrame(); frame.setTitle("登录"); frame.getContentPane().setFocusCycleRoot(true); frame.getContentPane().setBackground(Color.LIGHT_GRAY); frame.getContentPane().setLayout(null); frame.setBounds(400, 150, 490, 375); frame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE); btnlogin = new JButton(); btnlogin.addActionListener(new ActionListener() {  public void actionPerformed(final ActionEvent arg0) {  String name = textUsername.getText().trim();  String password = textpwd.getText().trim();  Connection conn = null;  PreparedStatement pstmt=null;  ResultSet rs=null;  int flag=0;  if(name.equals("")||password.equals("")){   flag=2;  }  int right=0;  try {   String sql = "select * from login where userName=?";    conn = (Connection)JDBC.getConnection();    pstmt= (PreparedStatement)conn.prepareStatement(sql);    pstmt.setString(1, name);    rs=(ResultSet) pstmt.executeQuery();    while(rs.next()){     String userName=rs.getString("userName");     String passWord=rs.getString("passWord");     right=rs.getInt("admin");     if(userName.equals(name)&&passWord.equals(password)){     flag = 1;     }    }    switch(flag){     case 1:     if((right==1)){       BackRun admin = new BackRun();       admin.frame.setVisible(true);       frame.setVisible(false);       break;      }else{       FrontRun admin= new FrontRun();       admin.frame.setVisible(true);       frame.setVisible(false);       break;     }     case 2:    JOptionPane.showMessageDialog(btnlogin ,"用户名或密码不能为空,请您重新输入！");       break;     default:        JOptionPane.showMessageDialog(btnlogin ,"用户名或密码 不正确,请您重新输入！");       break;     }                   } catch (Exception e) {   e.printStackTrace();   }              } });      btnlogin.setText(" 登陆"); btnlogin.setBounds(75, 215, 83, 28); frame.getContentPane().add(btnlogin); btnreset = new JButton(); btnreset.addActionListener(new ActionListener() {  public void actionPerformed(final ActionEvent arg0) {  textUsername.setText("");  textpwd.setText("");    } }); btnreset.setText("重置"); btnreset.setBounds(195, 215, 83, 28); frame.getContentPane().add(btnreset); labUserName = new JLabel(); labUserName.setText("用户名："); labUserName.setBounds(75, 130, 52, 18); frame.getContentPane().add(labUserName); labpwd = new JLabel(); labpwd.setText("密  码："); labpwd.setBounds(75, 175, 66, 18); frame.getContentPane().add(labpwd); textUsername = new JTextField(); textUsername.setBounds(145, 130, 188, 22); frame.getContentPane().add(textUsername); textpwd = new JPasswordField(); textpwd.setBounds(145, 170, 188, 22); frame.getContentPane().add(textpwd); btnregister = new JButton(); btnregister.addActionListener(new ActionListener() {  public void actionPerformed(final ActionEvent arg0) {  Register rs = new Register();  rs.frame.setVisible(true);  } }); btnregister.setText("注册"); btnregister.setBounds(270, 270, 81, 28); frame.getContentPane().add(btnregister); button = new JButton(); button.addActionListener(new ActionListener() {  public void actionPerformed(final ActionEvent arg0) {  System.exit(0);  } }); button.setText("退出"); button.setBounds(310, 215, 83, 28); frame.getContentPane().add(button); label = new JLabel(); label.setText("还没有账号？赶快点击注册吧!"); label.setBounds(85, 275, 181, 33); frame.getContentPane().add(label);} }

package loginManage;import java.awt.Color;import java.awt.Component;import java.awt.EventQueue;import java.awt.event.ActionEvent;import java.awt.event.ActionListener;import java.sql.Connection;import java.sql.DriverManager;import java.sql.SQLException;import javax.swing.JButton;import javax.swing.JFrame;import javax.swing.JLabel;import javax.swing.JOptionPane;import javax.swing.JPasswordField;import javax.swing.JTextField;import com.mysql.jdbc.PreparedStatement;import com.swtdesigner.SwingResourceManager;public class Register { private JButton button; private JButton btnregister; private JLabel labpwd; private JLabel labUserName; private JPasswordField textpwd; private JTextField textUsername; public JFrame frame;  public boolean flag=false;   public static void main(String args[]) { EventQueue.invokeLater(new Runnable() {  public void run() {  try {   Register window = new Register();      window.frame.setVisible(true);  } catch (Exception e) {   e.printStackTrace();  }  } }); }  public Register() { createContents(); }  private void createContents() {   frame = new JFrame(); frame.getContentPane().setFocusCycleRoot(true); frame.getContentPane().setBackground(Color.LIGHT_GRAY); frame.getContentPane().setLayout(null); frame.setBounds(350, 150, 500, 375); frame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE); labUserName = new JLabel(); labUserName.setText("用户名："); labUserName.setBounds(109, 182, 52, 18); frame.getContentPane().add(labUserName); labpwd = new JLabel(); labpwd.setText("密  码："); labpwd.setBounds(109, 224, 66, 18); frame.getContentPane().add(labpwd); textUsername = new JTextField(); textUsername.setBounds(190, 180, 188, 22); frame.getContentPane().add(textUsername); textpwd = new JPasswordField(); textpwd.setBounds(190, 222, 188, 22); frame.getContentPane().add(textpwd); btnregister = new JButton(); btnregister.addActionListener(new ActionListener() {  @SuppressWarnings("deprecation")  public void actionPerformed(final ActionEvent arg0) {  PreparedStatement st=null;  Connection con =null;  String sqlStr="insert into login(userName,passWord) values(?,?)";  try {   Class.forName("com.mysql.jdbc.Driver");  } catch (ClassNotFoundException e1) {   e1.printStackTrace();  }  try {   con = DriverManager.getConnection("jdbc:mysql://localhost:3306/hotel","root","125800");   st = (PreparedStatement) con.prepareStatement(sqlStr);  } catch (SQLException e1) {   e1.printStackTrace();  }    String name = textUsername.getText().trim();  String password = textpwd.getText().trim();   if(name.equals("")||password.equals("")){   JOptionPane.showMessageDialog(btnregister ,"用户名或密码不能为空,请您重新输入！");  }else{  try {   st.setString(1,name);   st.setString(2,password);   st.execute();   flag=true;   if(flag){   JOptionPane.showMessageDialog(btnregister, "注册成功/n点确定返回登录界面");   LoginFrame backMain=new LoginFrame();   backMain.frame.setVisible(true);   frame.setVisible(false);   }else{   JOptionPane.showMessageDialog(btnregister, "注册失败/n点确定返回登录界面");   }  } catch (SQLException e) {   e.printStackTrace();  }  }//   JOptionPane.showMessageDialog(btnregister, "注册成功/n点确定返回登录界面");//   loginFrame backMain=new loginFrame();//   backMain.frame.setVisible(true);//   frame.setVisible(false);    try {   st.close();   con.close();  } catch (SQLException e1) {   e1.printStackTrace();  }       } }); btnregister.setText("提交"); btnregister.setBounds(162, 268, 95, 28); frame.getContentPane().add(btnregister); button = new JButton(); button.addActionListener(new ActionListener() {  public void actionPerformed(final ActionEvent arg0) {    frame.setVisible(false);  } }); button.setText("返回"); button.setBounds(283, 268, 95, 28); frame.getContentPane().add(button); final JLabel label = new JLabel(); label.setIcon(SwingResourceManager.getIcon(Register.class, "/648.gif")); label.setBounds(0, 0, 492, 341); frame.getContentPane().add(label);// frame.getContentPane().setFocusTraversalPolicy(new FocusTraversalOnArray(new Component[] {labUserName, labpwd, btnregister, textUsername, textpwd, button})); }}