?? sql_data.java
字號:
// Java Document
package sql;
import java.sql.*;
public class sql_data{
private String sDBDriver="sun.jdbc.odbc.JdbcOdbcDriver";
private String url="jdbc:odbc:meeting";//Notice:DatabaseName
private String user="sa";
private String password="";//Notice: user and password.
Connection conn;
Statement stmt;
ResultSet rs;
public sql_data()
{
try{
Class.forName(sDBDriver);
}
catch(java.lang.ClassNotFoundException e){
System.err.println("sql_data():"+e.getMessage());
}
}
public void executeInsert(String sql){
try{
conn=DriverManager.getConnection(url,user,password);
stmt=conn.createStatement();
stmt.executeUpdate(sql);
stmt.close();
conn.close();
}catch(SQLException ex){
System.err.println("sql_data.executeUpdate:"+ex.getMessage());
}
}
public ResultSet executeQuery(String sql)
{
try
{
conn = DriverManager.getConnection(url,user,password);
stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
rs = stmt.executeQuery(sql);
}
catch(SQLException ex)
{
System.err.println("sql_data.executeQuery:"+ex.getMessage());
}
return rs;
}
/* public ResultSet executeQuery(String sql)
{
try{
conn=DriverManager.getConnection (url,user,password);
stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
rs=stmt.executeQuery(sql);
stmt.close();////////////////////////////I changed;
conn.close();////////////////////////////..........
}catch(SQLException ex){
System.err.println("sql_data.executeQuery:"+ex.getMessage());
}
return rs;
}
*/ public void executeUpdate(String sql){
try{
conn=DriverManager.getConnection(url,user,password);
stmt=conn.createStatement();
stmt.executeUpdate(sql);
stmt.close();
conn.close();
}catch(SQLException ex){
System.err.println("sql_data.executeQuery:"+ex.getMessage());
}
}
public void executeDelete(String sql){
try{
conn=DriverManager.getConnection(url,user,password);
stmt=conn.createStatement();
stmt.executeUpdate(sql);
stmt.close();
conn.close();
}catch(SQLException ex){
System.err.println("sql_data.executeDelete:"+ex.getMessage());
}
}
public void closeStmt(){
try{
stmt.close();
}
catch(SQLException e){
e.printStackTrace();
}
}
public void closeConn(){
try{
conn.close();
}catch(SQLException e){
e.printStackTrace();
}
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -