?? 客房管理.java
字號:
pack();
}// </editor-fold>
private void jButton5ActionPerformed(java.awt.event.ActionEvent evt) {
this.刪除();
}
private void jButton4ActionPerformed(java.awt.event.ActionEvent evt) {
try{添加2();}
catch(java.sql.SQLException e){
System.out.println(e);
}
}
private void jButton3ActionPerformed(java.awt.event.ActionEvent evt) {
try{更新();}
catch(java.sql.SQLException e){
System.out.println(e);
}
}
private void jButton2ActionPerformed(java.awt.event.ActionEvent evt) {
this.dispose();
主操作 ma =new 主操作();
ma.setVisible(true);
}
private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {
try{添加1();}
catch(java.sql.SQLException e){
System.out.println(e);
}
}
public void 刪除() {
try {
con = java.sql.DriverManager.getConnection("jdbc:odbc:keith","","");
stm = con.createStatement(java.sql.ResultSet.TYPE_SCROLL_SENSITIVE, java.sql.ResultSet.CONCUR_UPDATABLE);
int row=jTable1.getSelectedRow();//.getSelectedRow();
stm.executeUpdate("DELETE FROM 客房 Where m_id='"+a[row][0]+"'");
JOptionPane.showMessageDialog(null,"數(shù)據(jù)已成功刪除");
defaultModel.removeRow(row);
jTable1.updateUI();
//this.顯示();
}
catch (SQLException ex) {
JOptionPane.showMessageDialog(null,ex);
}
}
public void 顯示(){
try {
int i = 0;
con = java.sql.DriverManager.getConnection("jdbc:odbc:keith","","");
stm = con.createStatement(java.sql.ResultSet.TYPE_SCROLL_SENSITIVE, java.sql.ResultSet.CONCUR_UPDATABLE);
rs = stm.executeQuery("SELECT * FROM 客房");
while(rs.next()){
m_id = rs.getInt(1);
m_name = rs.getString(2);
m_p = rs.getInt(3);
a[i][0] = String.valueOf(m_id);
a[i][1] = m_name;
a[i][2] = String.valueOf(m_p);
i++;
}
pack();
defaultModel.setDataVector(a,colname);
stm.close();
con.close();
jTable1.updateUI();
}
catch (SQLException ex) {
JOptionPane.showMessageDialog(null,ex);
}
}
public void 添加1() throws java.sql.SQLException{
con = java.sql.DriverManager.getConnection("jdbc:odbc:keith","","");
stm = con.createStatement(java.sql.ResultSet.TYPE_SCROLL_SENSITIVE, java.sql.ResultSet.CONCUR_UPDATABLE);
//rs = stm.executeQuery("SELECT * FROM department");
//int n = jTable1.getRowCount();
//jTextField1.setText(String.valueOf(+2));
String s1 = "'" + jTextField1.getText().trim() + "'",
s2 = "'" + jTextField2.getText().trim() + "'",
s3 = "'" + jTextField3.getText().trim() + "'";
String temp = "insert into 客房(m_id,m_name,m_price) values("+s3+","+s2+","+s1+")";
//System.out.println("Connection Successful!");
stm.executeUpdate(temp);
stm.close();
con.close();
JOptionPane.showMessageDialog(this,"輸入成功！");
jTextField3.setText("");
jTextField2.setText("");
jTextField1.setText("");
jTable1.removeAll();
this.顯示();
jTable1.updateUI();
}
public void 添加2() throws java.sql.SQLException{
int row = jTable1.getSelectedRow();
int column = jTable1.getSelectedColumn();
String s1 = null,s2 = null,s3 = null;
con = java.sql.DriverManager.getConnection("jdbc:odbc:keith","","");
stm = con.createStatement(java.sql.ResultSet.TYPE_SCROLL_SENSITIVE, java.sql.ResultSet.CONCUR_UPDATABLE);
if(column == 0){
s1 = "'" + defaultModel.getValueAt(row, column) + "'";
s2 = "'" + defaultModel.getValueAt(row, column+1) + "'";
s3 = "'" + defaultModel.getValueAt(row, column+2) + "'";
}
if(column == 1){
s1 = "'" + defaultModel.getValueAt(row, column-1) + "'";
s2 = "'" + defaultModel.getValueAt(row, column) + "'";
s3 = "'" + defaultModel.getValueAt(row, column+1) + "'";
}
if(column == 2){
s1 = "'" + defaultModel.getValueAt(row, column-2) + "'";
s2 = "'" + defaultModel.getValueAt(row, column-1) + "'";
s3 = "'" + defaultModel.getValueAt(row, column) + "'";
}
String temp = "insert into 客房(m_id,m_name,m_price) values("+s3+","+s2+","+s1+")";
//System.out.println("Connection Successful!");
stm.executeUpdate(temp);
stm.close();
con.close();
JOptionPane.showMessageDialog(this,"輸入成功！");
jTable1.removeAll();
this.顯示();
jTable1.updateUI();
}
public void 更新() throws java.sql.SQLException{
int row = jTable1.getSelectedRow();
int column = jTable1.getSelectedColumn();
String s2 = null,s3 = null,s1 = null;
con = java.sql.DriverManager.getConnection("jdbc:odbc:keith","","");
stm = con.createStatement(java.sql.ResultSet.TYPE_SCROLL_SENSITIVE, java.sql.ResultSet.CONCUR_UPDATABLE);
if(column == 0){
s1 = "'" + defaultModel.getValueAt(row, column) + "'";
s2 = "'" + defaultModel.getValueAt(row, column+1) + "'";
s3 = "'" + defaultModel.getValueAt(row, column+2) + "'";
}
if(column == 1){
s1 = "'" + defaultModel.getValueAt(row, column-1) + "'";
s2 = "'" + defaultModel.getValueAt(row, column) + "'";
s3 = "'" + defaultModel.getValueAt(row, column+1) + "'";
}
if(column == 2){
s1 = "'" + defaultModel.getValueAt(row, column-2) + "'";
s2 = "'" + defaultModel.getValueAt(row, column-1) + "'";
s3 = "'" + defaultModel.getValueAt(row, column) + "'";
}
String temp = "insert into 客房(m_id,m_name,m_price) values("+s3+","+s2+","+s1+")";
//System.out.println("Connection Successful!");
stm.executeUpdate(temp);
stm.close();
con.close();
JOptionPane.showMessageDialog(this,"編輯成功！");
jTable1.removeAll();
this.顯示();
jTable1.updateUI();
}
/**
* @param args the command line arguments
*/
public static void main(String args[]) {
java.awt.EventQueue.invokeLater(new Runnable() {
public void run() {
new 客房管理().setVisible(true);
}
});
}
// 變量聲明 - 不進(jìn)行修改
private javax.swing.JButton jButton1;
private javax.swing.JButton jButton2;
private javax.swing.JButton jButton3;
private javax.swing.JButton jButton4;
private javax.swing.JButton jButton5;
private javax.swing.JLabel jLabel1;
private javax.swing.JLabel jLabel2;
private javax.swing.JLabel jLabel3;
private javax.swing.JPanel jPanel1;
private javax.swing.JPanel jPanel2;
private javax.swing.JScrollPane jScrollPane1;
private javax.swing.JTable jTable1;
private javax.swing.JTextField jTextField1;
private javax.swing.JTextField jTextField2;
private javax.swing.JTextField jTextField3;
private javax.swing.table.DefaultTableModel defaultModel;
private java.sql.Connection con;
private java.sql.Statement stm;
private java.sql.ResultSet rs;
Object colname[]= { "房間號", "房間類型", "價格"};
int m_id,m_p;
String m_name;
Object a[][]= new Object[24][3];
// 變量聲明結(jié)束
}?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -