📄 indivopen[anank].java
字号:
if(result == JOptionPane.YES_OPTION)
{
//下面进行往数据库里面转载数据！
String driver = "sun.jdbc.odbc.JdbcOdbcDriver" ;
String url = "jdbc:odbc:Hotel" ;
//注册驱动程序！
try
{
Class.forName(driver) ;
}
catch(Exception eee)
{
JOptionPane.showMessageDialog(null, "数据库驱动程序注册失败！") ;
return ;
}
//数据库连接！
try
{
Connection con = DriverManager.getConnection(url) ;
Statement smt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_UPDATABLE);
//往数据库里面装载客户信息!?
try
{
smt.executeUpdate("INSERT "+
"INTO table_Client(姓名,房间号码,性别,国籍,证件类型,证件号码,住址,工作单位,押金,标准价格,开房价格,预定天数,开房时间,退房时间)"+
"VALUES("+ "'"+strName+"',"+"'"+roomNumber+"',"+"'"+sexSelected+"',"+
"'"+countrySelected+"',"+"'"+idTypesSelected+"',"+
"'"+strIdNumber+"',"+"'"+strAddress+"',"+
"'"+strWorkPlace+"',"+deposit+","+
+stdPrice+","+spinnerPrice+","+spinnerPreDays+","+
"'"+strBeginDate+"',"+"'"
+strEndDate+"'"+")") ;
}
catch(SQLException ees)
{
System.out.println(ees.toString()) ;
}
}
catch(SQLException sqle)
{
JOptionPane.showMessageDialog(null, "数据库连接失败！") ;
return ;
}
//下面进行修改房间信息！
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver") ;
}
catch(Exception se)
{
JOptionPane.showMessageDialog(null, "数据库驱动程序注册失败！") ;
}
//连接数据库，并修改开房时选中房间的值
try
{
Connection con = DriverManager.getConnection("jdbc:odbc:Hotel") ;
Statement smt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_UPDATABLE);
//进行修改！
try
{
ResultSet rst = smt.executeQuery("select * from table_Room") ;
while(rst.next())
{
String getString = rst.getString(1) ;
String strRowSelected = (String)tableShowAll.getModel().getValueAt(rowSelectd, 0) ;
if(getString.equals(strRowSelected))
{
smt.executeUpdate("update table_Room set 房间状态='不可用' where 房间号码='"+strRowSelected+"'") ;
//JOptionPane.showMessageDialog(null, "修改房间数据库成功！") ;
break ;
}
}//while循环结束！
}//数据操作快结束！
catch(SQLException see)
{
JOptionPane.showMessageDialog(null, "数据修改操作发生异常！") ;
}
}
catch(SQLException j)
{
JOptionPane.showMessageDialog(null, "数据库连接失败！") ;
}
JOptionPane.showMessageDialog(null, "开房成功！") ;
txtName.setText("") ;
txtNumber.setText("") ;
txtAddress.setText("") ;
txtWorkPlace.setText("") ;
}
else
return ;
}//处理函数结束！
} );
gbc2.gridx = 0 ;
gbc2.gridy = GridBagConstraints.RELATIVE ;
gbc2.ipadx = 40 ;
gbc2.ipady = 20 ;
gbc2.insets = new Insets(40, 0, 0, 0) ;
gbc2.gridwidth = 1 ;
gbc2.gridheight = 1 ;
gbl2.setConstraints(btnMoveInto, gbc2) ;
panMiddle.add(btnMoveInto) ;
gbc2.insets = new Insets(0, 0, 0, 0) ;
gbc2.ipadx = 0 ;
gbc2.ipady = 0 ;
//添加‘取消’按钮！
JButton btnMoveOut = new JButton("取消") ;
btnMoveOut.addActionListener(new ActionListener()
{
public void actionPerformed(ActionEvent e)
{
frame.setVisible(false) ;
frame.dispose() ;
}
}) ;//处理类结束！
gbc2.gridx = 0 ;
gbc2.gridy = GridBagConstraints.RELATIVE ;
gbc2.gridwidth = 1 ;
gbc2.gridheight = 1 ;
gbc2.ipadx = 40 ;
gbc2.ipady = 20 ;
gbl2.setConstraints(btnMoveOut, gbc2) ;
panMiddle.add(btnMoveOut) ;
gbc2.ipadx = 0 ;
gbc2.ipady = 0 ;
final JButton btnReflash = new JButton("刷新") ;
btnReflash.addActionListener(new ActionListener()
{
public void actionPerformed(ActionEvent e)
{
for(int i = 0 ; i < 200 ; i++)
for( int j = 0 ; j < 3 ; j++)
staticData[i][j] = new String() ;
for( int i = 0 ; i < 200 ; i++)
staticData[i][3] = new Boolean(false) ;
String driver1 = "sun.jdbc.odbc.JdbcOdbcDriver";
String url1 = "jdbc:odbc:Hotel";
//注册数据库驱动程序！
try
{
Class.forName(driver1);
}
catch(Exception E)
{
JOptionPane.showMessageDialog(null, "数据库驱动程序注册失败！") ;
E.printStackTrace();
}
//连接数据库，并进行相关操作！
try
{
Connection con1 = DriverManager.getConnection(url1);
Statement smt1 = con1.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_UPDATABLE);
//连接成功后，对数据库进行相关的操作！
try
{
ResultSet rst1 = smt1.executeQuery("SELECT * from table_Room WHERE 房间状态='可用'") ;
int tableRoomNumber1 = 0 ;//行号！row
while(rst1.next())//在读取ResultSet对象里面的记录的时候，把记录显示到JTable中！
{
String numberOfRoom1 = rst1.getString(1) ;
String styleOfRoom1 = rst1.getString(2) ;
String priceOfRoom1 = rst1.getString(3) ;
String stateOfRoom1 = rst1.getString(4) ;
//Integer integer = new Integer(priceOfRoom1) ;
Boolean bool1 = new Boolean(true) ;
if(stateOfRoom1.equals("可用"))
bool1 = new Boolean(true) ;
else
bool1 = new Boolean(false) ;
staticData[tableRoomNumber1][0] = numberOfRoom1 ;
staticData[tableRoomNumber1][1] = styleOfRoom1 ;
staticData[tableRoomNumber1][2] = priceOfRoom1 ;
staticData[tableRoomNumber1][3] = bool1 ;
tableRoomNumber1++ ;
}//while循环结束！
//JOptionPane.showMessageDialog(null, "从数据库中导入数据成功！") ;
}
catch(SQLException eeee)
{
JOptionPane.showMessageDialog(null, "从数据库中导入数据失败！") ;
}
}
catch(SQLException ee)
{
JOptionPane.showMessageDialog(null, "数据库连接失败！") ;
}
JOptionPane.showMessageDialog(null, "数据重新载入成功!") ;
}
}) ;
gbc2.gridx = 0 ;
gbc2.gridy = GridBagConstraints.RELATIVE;
gbc2.gridwidth = 1 ;
gbc2.gridheight = 1 ;
gbc2.ipadx = 40;
gbc2.ipady = 20 ;
gbc2.insets = new Insets(10, 0, 0, 0) ;
gbl2.setConstraints(btnReflash, gbc2) ;
panMiddle.add(btnReflash) ;
gbc2.insets = new Insets(0, 0, 0, 0) ;
gbc2.ipadx = 0 ;
gbc2.ipady = 0 ;
//
final JButton btnClear = new JButton("清空") ;
btnClear.addActionListener(new ActionListener()
{
public void actionPerformed(ActionEvent e)
{
txtName.setText(new String()) ;
txtNumber.setText(new String()) ;
txtAddress.setText(new String()) ;
txtWorkPlace.setText(new String()) ;
txtName.requestDefaultFocus() ;
}
}) ;
gbc2.gridx = 0 ;
gbc2.gridy = GridBagConstraints.RELATIVE;
gbc2.gridwidth = 1 ;
gbc2.gridheight = 1 ;
gbc2.ipadx = 40 ;
gbc2.ipady = 20 ;
gbl2.setConstraints(btnClear, gbc2) ;
panMiddle.add(btnClear) ;
gbc2.ipadx = 0 ;
gbc2.ipady = 0 ;
panMiddle.setBorder(BorderFactory.createTitledBorder("选项")) ;
//把JTable放在一个面板上（panLeft）
JPanel panLeft = new JPanel() ;
panLeft.add(new JScrollPane(tableShowAll)) ;
JPanel panUnder = new JPanel(new BorderLayout()) ;
panUnder.add(panLeft, "West") ;
panUnder.add(panMiddle, "East") ;
//添加上面的整个面板！
gbcContent.gridx = 0 ;
gbcContent.gridy = 0 ;
gbcContent.gridwidth = 1 ;
gbcContent.gridheight = 1 ;
gblContent.setConstraints(panLeft, gbcContent) ;
content.add(panUp, "North") ;
//添加下面的整个面板！
gbcContent.gridx = GridBagConstraints.RELATIVE;
gbcContent.gridwidth = 1 ;
gbcContent.gridheight = 1 ;
gblContent.setConstraints(panLeft, gbcContent) ;
content.add(panUnder, "South") ;
frame.setVisible(true) ;
/*
*下面进行房间信息的载入，连接数据库表table_Room
*说明：在刚绘制界面后，就对没有入住的房间信息进行加载！
*/
String driver = "sun.jdbc.odbc.JdbcOdbcDriver";
String url = "jdbc:odbc:Hotel";
//注册数据库驱动程序！
try
{
Class.forName(driver);
}
catch(Exception E)
{
JOptionPane.showMessageDialog(null, "数据库驱动程序注册失败！") ;
E.printStackTrace();
}
//连接数据库，并进行相关操作！
try
{
Connection con = DriverManager.getConnection(url);
Statement smt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_UPDATABLE);
//连接成功后，对数据库进行相关的操作！
try
{
ResultSet rst = smt.executeQuery("SELECT * from table_Room WHERE 房间状态='可用'") ;
int tableRoomNumber = 0 ;//行号！row
rst.beforeFirst() ;
while(rst.next())//在读取ResultSet对象里面的记录的时候，把记录显示到JTable中！
{
String numberOfRoom = rst.getString(1) ;
String styleOfRoom = rst.getString(2) ;
String priceOfRoom = rst.getString(3) ;
String stateOfRoom = rst.getString(4) ;
//Integer integer = new Integer(priceOfRoom) ;
Boolean bool = new Boolean(true) ;
if(stateOfRoom.equals("可用"))
bool = new Boolean(true) ;
else
bool = new Boolean(false) ;
staticData[tableRoomNumber][0] = numberOfRoom ;
staticData[tableRoomNumber][1] = styleOfRoom ;
staticData[tableRoomNumber][2] = priceOfRoom ;
staticData[tableRoomNumber][3] = bool ;
tableRoomNumber++ ;
}
JOptionPane.showMessageDialog(null, "从数据库中导入数据成功！") ;
}
catch(SQLException eeee)
{
JOptionPane.showMessageDialog(null, "从数据库中导入数据失败！") ;
}
}
catch(SQLException SE)
{
JOptionPane.showMessageDialog(null, "数据库连接失败！") ;
}
}
public static void main(String args[])
{
new IndivOpen() ;
}
/*
*所给的函数好像没有什么用处！
*/
}⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -