📄 distill[anank].java
字号:
JOptionPane.showMessageDialog(null, "密码不正确,请重新输入!") ;
break ;
}
}
}//while循环结束!
}//try数据库操作块结束!
catch(SQLException esa)
{
JOptionPane.showMessageDialog(null, "数据库操作异常!") ;
}
//smt.colse() ;
// con.close() ;
}//try数据库连接块结束!
catch(SQLException sw)
{
JOptionPane.showMessageDialog(null, "数据库连接失败！") ;
}
}//actionPerformed函数结束！
}) ;//监听处理时间结束！
gbc2.gridx = gbc2.gridx ;
gbc2.gridy++ ;
gbc2.gridwidth = 1 ;
gbc2.gridheight = 1 ;
gbc2.insets = new Insets(40, 0, 0, 0) ;
gbc2.ipadx = 50 ;
gbc2.ipady = 20 ;
gbl2.setConstraints(btnConfirm, gbc2) ;
panRight.add(btnConfirm) ;
gbc2.insets = new Insets(0, 0, 0, 0) ;
//
JButton btnCancel = new JButton("取消") ;
btnCancel.addActionListener(new ActionListener()
{
public void actionPerformed(ActionEvent e)
{
frame.setVisible(false) ;
frame.dispose() ;//释放系统资
}
}) ;
gbc2.gridx = gbc2.gridx ;
gbc2.gridy++ ;
gbc2.gridwidth = 1 ;
gbc2.gridheight = 1 ;
gbl2.setConstraints(btnCancel, gbc2) ;
panRight.add(btnCancel) ;
//
final JButton btnReflash = new JButton("刷新") ;
gbc2.gridx = gbc2.gridx ;
gbc2.gridy++ ;
gbc2.insets = new Insets(30, 0, 0, 0) ;
gbc2.gridwidth = 1 ;
gbc2.gridheight = 1 ;
gbl2.setConstraints(btnReflash, gbc2) ;
panRight.add(btnReflash) ;
gbc2.insets = new Insets(0, 0, 0, 0) ;
//
final JButton btnShowAll = new JButton("显示所有") ;
btnShowAll.addActionListener(new ActionListener()
{
public void actionPerformed(ActionEvent e)
{
//////////////////////////////////////////////////
//连接数据库，载入初始信息！
/////////////////////////////////////////////////
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver") ;
}
catch(Exception ea)
{
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_Consign") ;
int rowOfNumber = 0 ;//行号！row
rst.beforeFirst() ;
while(rst.next())//在读取ResultSet对象里面的记录的时候，把记录显示到JTable中！
{
String strGetNumber = rst.getString(1) ;
String strGetName = rst.getString(2) ;
String strGetObject = rst.getString(5) ;
int intGetNumbers = rst.getInt(6) ;
String strGetTime = rst.getString(8) ;
String strGetState = rst.getString(12) ;
Boolean boolState = new Boolean(false) ;
if(strGetState.equals("未提取"))
boolState = new Boolean(false) ;
else
boolState = new Boolean(true) ;
//从数据库中获取结束，现在导入到表中！
//if(strGetState.equals("提取")||strGetState.equals("未提取"))
//{
table.getModel().setValueAt(strGetNumber, rowOfNumber, 0) ;
table.getModel().setValueAt(strGetName, rowOfNumber, 1) ;
table.getModel().setValueAt(strGetObject, rowOfNumber, 2) ;
table.getModel().setValueAt(new Integer(intGetNumbers), rowOfNumber, 3) ;
table.getModel().setValueAt(strGetTime, rowOfNumber, 4) ;
table.getModel().setValueAt(boolState, rowOfNumber, 5) ;
//}
rowOfNumber++ ;
}//while循环结束！
}
catch(SQLException eeee)
{
JOptionPane.showMessageDialog(null, "从数据库中导入数据失败！") ;
}
}
catch(SQLException ha)
{
JOptionPane.showMessageDialog(null, "数据库连接时发生异常！") ;
}
}//处理函数结束!
}) ;//监听类结束!
gbc2.gridx = gbc2.gridx ;
gbc2.gridy++ ;
gbc2.ipadx = 24 ;
gbc2.ipady = 20 ;
gbc2.gridwidth = 1 ;
gbc2.gridheight = 1 ;
gbl2.setConstraints(btnShowAll, gbc2) ;
panRight.add(btnShowAll) ;
gbc2.ipadx = 0 ;
gbc2.ipady = 0 ;
//
btnReflash.addActionListener(new ActionListener()
{
public void actionPerformed(ActionEvent e)
{
for( int i = 0 ;i < 100 ; i++)
for(int j = 0 ;j < 5; j++)
myData[i][j] = new String() ;
for(int i = 0 ; i< 100 ;i++)
myData[i][5] = new Boolean(false) ;
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver") ;
}
catch(Exception ea)
{
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_Consign WHERE 状态='未提取'") ;
int rowOfNumber = 0 ;//行号！row
rst.beforeFirst() ;
while(rst.next())//在读取ResultSet对象里面的记录的时候，把记录显示到JTable中！
{
String strGetNumber = rst.getString(1) ;
String strGetName = rst.getString(2) ;
String strGetObject = rst.getString(5) ;
int intGetNumbers = rst.getInt(6) ;
String strGetTime = rst.getString(8) ;
String strGetState = rst.getString(12) ;
Boolean boolState = new Boolean(false) ;
if(strGetState.equals("未提取"))
boolState = new Boolean(false) ;
else
boolState = new Boolean(true) ;
//从数据库中获取结束，现在导入到表中！
if(strGetState.equals("未提取"))
{
table.getModel().setValueAt(strGetNumber, rowOfNumber, 0) ;
table.getModel().setValueAt(strGetName, rowOfNumber, 1) ;
table.getModel().setValueAt(strGetObject, rowOfNumber, 2) ;
table.getModel().setValueAt(new Integer(intGetNumbers), rowOfNumber, 3) ;
table.getModel().setValueAt(strGetTime, rowOfNumber, 4) ;
table.getModel().setValueAt(boolState, rowOfNumber, 5) ;
}
rowOfNumber++ ;
}//while循环结束！
}
catch(SQLException eeee)
{
JOptionPane.showMessageDialog(null, "从数据库中导入数据失败！") ;
}
}
catch(SQLException ha)
{
JOptionPane.showMessageDialog(null, "数据库连接时发生异常！") ;
}
JOptionPane.showMessageDialog(null, "数据重新载入成功!") ;
}//处理函数结束!
}) ;//监听类结束!
//
//
JPanel panRight2 = new JPanel() ;
panRight2.add(new JPanel(), "Center") ;
panRight2.add(panRight, "South") ;
panUnder.add(panRight2, "East") ;
Container content = frame.getContentPane() ;
content.setLayout(new BorderLayout()) ;
content.add(panUp, "North") ;
content.add(panUnder,"South") ;
frame.pack() ;
frame.setResizable(false) ;
//////////////////////////////////////////////////
//连接数据库，载入初始信息！
/////////////////////////////////////////////////
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver") ;
}
catch(Exception e)
{
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_Consign WHERE 状态='未提取'") ;
int rowOfNumber = 0 ;//行号！row
rst.beforeFirst() ;
while(rst.next())//在读取ResultSet对象里面的记录的时候，把记录显示到JTable中！
{
String strGetNumber = rst.getString(1) ;
String strGetName = rst.getString(2) ;
String strGetObject = rst.getString(5) ;
int intGetNumbers = rst.getInt(6) ;
String strGetTime = rst.getString(8) ;
String strGetState = rst.getString(12) ;
Boolean boolState = new Boolean(false) ;
if(strGetState.equals("未提取"))
boolState = new Boolean(false) ;
else
boolState = new Boolean(true) ;
//从数据库中获取结束，现在导入到表中！
if(strGetState.equals("未提取"))
{
table.getModel().setValueAt(strGetNumber, rowOfNumber, 0) ;
table.getModel().setValueAt(strGetName, rowOfNumber, 1) ;
table.getModel().setValueAt(strGetObject, rowOfNumber, 2) ;
table.getModel().setValueAt(new Integer(intGetNumbers), rowOfNumber, 3) ;
table.getModel().setValueAt(strGetTime, rowOfNumber, 4) ;
table.getModel().setValueAt(boolState, rowOfNumber, 5) ;
}
rowOfNumber++ ;
}//while循环结束！
}
catch(SQLException eeee)
{
JOptionPane.showMessageDialog(null, "从数据库中导入数据失败！") ;
}
}
catch(SQLException ha)
{
JOptionPane.showMessageDialog(null, "数据库连接时发生异常！") ;
}
frame.setVisible(true) ;//frame显示的时候一定要在数据加载完成之后
//这样才可以看到数据！！
}
public static class ModelTable extends AbstractTableModel//是extends不是implements
{
String[] columnNames = {"寄存号码", "寄存人姓名", "寄存物品", "寄存件数", "寄存时间","是否提取"} ;
Object[][] data = myData ;
public int getRowCount(){return data.length ;}
public int getColumnCount(){return data[0].length ;}
public Object getValueAt(int row, int column){return data[row][column] ;}
public Class getColumnClass(int column){return data[0][column].getClass() ;}
public String getColumnName(int column){return columnNames[column] ;}
public void setValueAt(Object ob, int row, int column)
{
data[row][column] = ob ;
fireTableCellUpdated(row, column);
}
}
public static void main(String args[])
{
new Distill() ;
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -