?? restaurantjdbcbean.java
字號:
package bean;
import java.sql.*;
public class restaurantJdbcBean{
String jdbcOdbcDriver = "sun.jdbc.odbc.JdbcOdbcDriver";
String gConnection = "jdbc:odbc:restaurant";
Connection connect = null;
ResultSet rs = null;
public restaurantJdbcBean(){
try{
Class.forName(jdbcOdbcDriver);
}
catch(java.lang.ClassNotFoundException e){
System.err.println(e.getMessage());
}
}
public ResultSet executeQuery(String sql){
try{
connect = DriverManager.getConnection(gConnection);
Statement stmt = connect.createStatement();
rs = stmt.executeQuery(sql);
}
catch(SQLException ex){
System.err.println(ex.getMessage());
}
return rs;
}
public int executeUpdate(String sql){
int result=0;
try{
connect=DriverManager.getConnection(gConnection);
Statement stmt=connect.createStatement();
result=stmt.executeUpdate(sql);
}
catch(SQLException ex){
System.err.println(ex.getMessage());
}
return result;
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -