?? usemanagerframe.java
字號:
Tablepanel.setPreferredSize(new Dimension(450, 100));
Tablepanel.setBorder(BorderFactory.createEtchedBorder());
Tablepanel.add( scroller ,BorderLayout.CENTER);
return Tablepanel;
} // createButtonPanel()
private void UseInfoInput()
{
if( UseNameField.getText().equals( "" ))
{
JOptionPane.showMessageDialog( this,"請輸入用戶名" );
//setTitle( "無記錄顯示" );
return;
}
try
{
Databaseconnection();
String UseQuery = "select * from UESR_MANAGER where 用戶名 = '"+UseNameField.getText()+"'";
String UseInput = "INSERT INTO UESR_MANAGER VALUES('"
+ UseNameField.getText()+"','"+PasswordField.getText()+"')";
UseManagerstatement = UseManagerconnection.createStatement();
UseManagerresultSet = UseManagerstatement.executeQuery( UseQuery );
boolean moreRecords = UseManagerresultSet.next();
if ( moreRecords )
{
JOptionPane.showMessageDialog( this,"對不起，此帳號已被使用，請重新選擇帳號" );
//setTitle( "無記錄顯示" );
UseManagerconnection.close();
return;
}
//InsertInputstatement = Insertconnection.createStatement();
int insert = UseManagerstatement.executeUpdate( UseInput );//executeUpdate返回一個整型值
if (insert == 1)
{
JOptionPane.showMessageDialog( this,"帳號注冊成功！" );
getTable();
UseNameField.setText("");
PasswordField.setText("");
}
}
catch ( SQLException sqlex )
{
sqlex.printStackTrace();
}
}
private void UseInfoDelete()
{
if( UseNameField.getText().equals( "" ))
{
JOptionPane.showMessageDialog( this,"請輸入用戶名" );
//setTitle( "無記錄顯示" );
return;
}
try
{
Databaseconnection();
String UseDelete = "DELETE * FROM UESR_MANAGER WHERE 用戶名 = '"+UseNameField.getText()+"'";
UseManagerstatement = UseManagerconnection.createStatement();
int DELETE = UseManagerstatement.executeUpdate( UseDelete );//executeUpdate返回一個整型值
if (DELETE == 1)
{
JOptionPane.showMessageDialog( this,"帳號刪除成功！" );
getTable();
UseNameField.setText("");
PasswordField.setText("");
}
}
catch ( SQLException sqlex )
{
sqlex.printStackTrace();
}
}
private void UseInfoChange()
{
if( UseNameField.getText().equals( "" ))
{
JOptionPane.showMessageDialog( this,"請輸入用戶名" );
//setTitle( "無記錄顯示" );
return;
}
try
{
Databaseconnection();
String UseQuery = "select * FROM UESR_MANAGER WHERE 用戶名 = '"+UseNameField.getText()+"'";
String UseDelete = "DELETE * FROM UESR_MANAGER WHERE 用戶名 = '"+UseNameField.getText()+"'";
String UseInsert = "INSERT INTO UESR_MANAGER VALUES('"
+ UseNameField.getText()+"','"+PasswordField.getText()+"')";
UseManagerstatement = UseManagerconnection.createStatement();
UseManagerresultSet = UseManagerstatement.executeQuery( UseQuery );
boolean moreRecords = UseManagerresultSet.next();
if ( !moreRecords )
{
JOptionPane.showMessageDialog( this,"對不起，你輸入的帳號不存在，請重新輸入" );
//setTitle( "無記錄顯示" );
UseManagerconnection.close();
return;
}
int DELETE = UseManagerstatement.executeUpdate( UseDelete );//executeUpdate返回一個整型值
int INSERT = UseManagerstatement.executeUpdate( UseInsert );//executeUpdate返回一個整型值
if (DELETE == 1)
{
JOptionPane.showMessageDialog( this,"帳號口令更改成功,請記住新密碼！" );
getTable();
UseNameField.setText("");
PasswordField.setText("");
}
}
catch ( SQLException sqlex )
{
sqlex.printStackTrace();
}
}
private void Databaseconnection()
{
String url = "jdbc:odbc:VipQuery";
String username = "";
String password = "";
//加載驅動程序以連接數據庫
try
{
Class.forName( "sun.jdbc.odbc.JdbcOdbcDriver" );
UseManagerconnection = DriverManager.getConnection( url, username, password );
}
//捕獲加載驅動程序異常
catch ( ClassNotFoundException cnfex )
{
System.err.println("裝載 JDBC/ODBC 驅動程序失敗。" );
cnfex.printStackTrace();
System.exit( 1 ); // terminate program
}
//捕獲連接數據庫異常
catch ( SQLException sqlex )
{
System.err.println( "無法連接數據庫" );
sqlex.printStackTrace();
System.exit( 1 ); // terminate program
}
}
private void getTable()
{
try
{
//執行SQL語句
String query;
query = "SELECT * FROM UESR_MANAGER";
UseManagerstatement = UseManagerconnection.createStatement();
UseManagerresultSet = UseManagerstatement.executeQuery( query );
//在表格中顯示查詢結果
displayResultSet( UseManagerresultSet);
}
catch ( SQLException sqlex ) {
sqlex.printStackTrace();
}
}
private void displayResultSet( ResultSet rs )
throws SQLException
{
//定位到達第一條記錄
boolean moreRecords = rs.next();
//如果沒有記錄，則提示一條消息
if ( ! moreRecords ) {
JOptionPane.showMessageDialog( this,"結果集中無記錄" );
setTitle( "無記錄顯示" );
return;
}
Vector columnHeads = new Vector();
Vector rows = new Vector();
try {
//獲取字段的名稱
ResultSetMetaData rsmd = rs.getMetaData();
for ( int i = 1; i <= rsmd.getColumnCount(); ++i )
columnHeads.addElement( rsmd.getColumnName( i ) );
//獲取記錄集
do {
rows.addElement( getNextRow( rs, rsmd ) );
} while ( rs.next() );
//在表格中顯示查詢結果
//table = new JTable( rows, columnHeads );
//JScrollPane scroller = new JScrollPane( table );
JPanel Tablepanel = new JPanel();
Tablepanel.setLayout(new BorderLayout());
UseTable = new JTable(rows, columnHeads);
JScrollPane scroller = new JScrollPane(UseTable);
scroller.setPreferredSize(new Dimension(440, 95));
//Tablepanel.setLayout( new BorderLayout() );
Tablepanel.setPreferredSize(new Dimension(450, 100));
Tablepanel.setBorder(BorderFactory.createEtchedBorder());
Tablepanel.add( scroller ,BorderLayout.CENTER);
Container c = getContentPane();
c.remove(1);
c.add( Tablepanel, BorderLayout.CENTER );
//刷新Table
c.validate();
}
catch ( SQLException sqlex ) {
sqlex.printStackTrace();
}
}
private Vector getNextRow( ResultSet rs,
ResultSetMetaData rsmd )
throws SQLException
{
Vector currentRow = new Vector();
for ( int i = 1; i <= rsmd.getColumnCount(); ++i )
currentRow.addElement( rs.getString( i ) );
//返回一條記錄
return currentRow;
}
}?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -