?? frame1.java~84~
字號:
{
System.out.println("Message: " + ex.getMessage());
System.out.println("SQLState: " + ex.getSQLState());
System.out.println("ErrorCode: " + ex.getErrorCode());
ex = ex.getNextException();
}
}
catch(Exception ex )
{
ex.printStackTrace();
}
finally
{
try
{
if(statement != null)
{
statement.close(); // 關閉Statement接口實例
}
if(connection != null)
{
connection.close(); // 關閉Connection接口實例
}
}
catch (SQLException ex)
{
System.out.println("\nERROR:----- SQLException -----\n");
System.out.println("Message: " + ex.getMessage( ));
System.out.println("SQLState: " + ex.getSQLState());
System.out.println("ErrorCode: " + ex.getErrorCode());
}
}
}
void jButton2_actionPerformed(ActionEvent e) // 處理添加按鈕)的ActionEvent
{
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); // 實例化JDBC-ODBC橋的驅動
connection = DriverManager.getConnection("jdbc:odbc:local", "sa",
"hunterd"); // 連接數據庫
// 創建Statement接口對象
statement = connection.createStatement();
String sql1 = "insert into stu_info values ('" + jTextField1.getText() +
"','" + jTextField2.getText() + "','" + jTextField3.getText() + "','" +
jTextField4.getText() + "')";
statement.executeUpdate(sql1); // stu_info表中添加記錄
jTextPane1.setText("記錄添加成功!");
// 清空信息框
jTextField1.setText("");
jTextField2.setText("");
jTextField3.setText("");
jTextField4.setText("");
}
catch (SQLException ex) { // 捕捉異常
jTextPane1.setText(ex.getMessage());
System.out.println("\nERROR:----- SQLException -----\n");
while (ex != null) {
System.out.println("Message: " + ex.getMessage());
System.out.println("SQLState: " + ex.getSQLState());
System.out.println("ErrorCode: " + ex.getErrorCode());
ex = ex.getNextException();
}
}
catch (Exception ex) {
ex.printStackTrace();
}
finally {
try {
if (statement != null) {
statement.close(); // 關閉Statement接口實例
}
if (connection != null) {
connection.close(); // 關閉Connection接口實例
}
}
catch (SQLException ex) {
System.out.println("\nERROR:----- SQLException -----\n");
System.out.println("Message: " + ex.getMessage());
System.out.println("SQLState: " + ex.getSQLState());
System.out.println("ErrorCode: " + ex.getErrorCode());
}
}
}
void jButton3_actionPerformed(ActionEvent e) // 處理刪除按鈕的ActionEvent
{
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); // 實例化JDBC-ODBC橋的驅動
connection = DriverManager.getConnection("jdbc:odbc:local","sa","hunterd"); // 連接數據庫
// 創建Statement接口對象
statement = connection.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE);
rSet = statement.executeQuery("select 學號 from stu_info ");
if (rSet.next()==false) // 判斷數據庫中是否有要刪除的記錄，如沒有則顯示提示框
{
jTextField5.setText("");
jTextPane1.setText("數據庫中沒有您要刪除的學號!");
}
else
{
String sql2="delete from stu_info where 學號='"+jTextField5.getText()+"'";
statement.executeUpdate(sql2); // 刪除stu_info表中對應學號的數據記錄
// 清空信息框
jTextField1.setText("");
jTextField2.setText("");
jTextField3.setText("");
jTextField4.setText("");
jTextField5.setText("");
jTextPane1.setText("記錄已成功刪除!");
}
}
catch(SQLException ex) // 捕捉異常
{
System.out.println("\nERROR:----- SQLException -----\n");
while (ex != null)
{
System.out.println("Message: " + ex.getMessage());
System.out.println("SQLState: " + ex.getSQLState());
System.out.println("ErrorCode: " + ex.getErrorCode());
ex = ex.getNextException();
}
}
catch(Exception ex )
{
ex.printStackTrace();
}
finally
{
try
{
if(statement != null)
{
statement.close(); // 關閉Statement接口實例
}
if(connection != null)
{
connection.close(); // 關閉Connection接口實例
}
}
catch (SQLException ex)
{
System.out.println("\nERROR:----- SQLException -----\n");
System.out.println("Message: " + ex.getMessage( ));
System.out.println("SQLState: " + ex.getSQLState());
System.out.println("ErrorCode: " + ex.getErrorCode());
}
}
}
void jButton4_actionPerformed(ActionEvent e)
{
jTextField1.setText("");
jTextField2.setText("");
jTextField3.setText("");
jTextField4.setText("");
jTextField5.setText("");
jTextPane1.setText("");
}
void jButton5_actionPerformed(ActionEvent e) // 處理查詢按鈕的ActionEvent
{
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); // 實例化JDBC-ODBC橋的驅動
connection = DriverManager.getConnection("jdbc:odbc:local","sa","hunterd"); // 連接數據庫
// 創建Statement接口對象
Statement statement = connection.createStatement();
rSet = statement.executeQuery("select * from stu_info ");
查詢記錄 = 0;
String sno;
sno = rSet.getString("學號");
while (rSet.next()==true) {
if (sno.equals(jTextField5.getText())){
jTextField5.setText("");
jTextPane1.setText("查詢信息如下:"); //顯示數據
jTextField1.setText(rSet.getString("學號"));
jTextField2.setText(rSet.getString("姓名"));
jTextField3.setText(rSet.getString("所屬學院"));
jTextField4.setText(rSet.getString("所屬班級"));
break;
}
else{
jTextField5.setText("");
jTextPane1.setText("數據庫中沒有您查詢的學號!");
}
rSet.close();
}
}
catch(SQLException ex) // 捕捉異常
{
System.out.println("\nERROR:----- SQLException -----\n");
while (ex != null)
{
System.out.println("Message: " + ex.getMessage());
System.out.println("SQLState: " + ex.getSQLState());
System.out.println("ErrorCode: " + ex.getErrorCode());
ex = ex.getNextException();
}
}
catch(Exception ex )
{
ex.printStackTrace();
}
finally
{
try
{
if(statement != null)
{
statement.close(); // 關閉Statement接口實例
}
if(connection != null)
{
connection.close(); // 關閉Connection接口實例
}
}
catch (SQLException ex)
{
System.out.println("\nERROR:----- SQLException -----\n");
System.out.println("Message: " + ex.getMessage( ));
System.out.println("SQLState: " + ex.getSQLState());
System.out.println("ErrorCode: " + ex.getErrorCode());
}
}
}
}
class Frame1_jButton4_actionAdapter implements java.awt.event.ActionListener {
Frame1 adaptee;
Frame1_jButton4_actionAdapter(Frame1 adaptee) {
this.adaptee = adaptee;
}
public void actionPerformed(ActionEvent e) {
adaptee.jButton4_actionPerformed(e);
}
}
class Frame1_jButton2_actionAdapter implements java.awt.event.ActionListener {
Frame1 adaptee;
Frame1_jButton2_actionAdapter(Frame1 adaptee) {
this.adaptee = adaptee;
}
public void actionPerformed(ActionEvent e) {
adaptee.jButton2_actionPerformed(e);
}
}
class Frame1_jButton1_actionAdapter implements java.awt.event.ActionListener {
Frame1 adaptee;
Frame1_jButton1_actionAdapter(Frame1 adaptee) {
this.adaptee = adaptee;
}
public void actionPerformed(ActionEvent e) {
adaptee.jButton1_actionPerformed(e);
}
}
class Frame1_jButton3_actionAdapter implements java.awt.event.ActionListener {
Frame1 adaptee;
Frame1_jButton3_actionAdapter(Frame1 adaptee) {
this.adaptee = adaptee;
}
public void actionPerformed(ActionEvent e) {
adaptee.jButton3_actionPerformed(e);
}
}
class Frame1_jButton5_actionAdapter implements java.awt.event.ActionListener {
Frame1 adaptee;
Frame1_jButton5_actionAdapter(Frame1 adaptee) {
this.adaptee = adaptee;
}
public void actionPerformed(ActionEvent e) {
adaptee.jButton5_actionPerformed(e);
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -