?? database.java
字號:
package Db;
import java.sql.*;
public class DataBase{
//String sDBDriver = "oracle.jdbc.driver.OracleDriver";
String sDBDriver = "sun.jdbc.odbc.JdbcOdbcDriver";
String url = "jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=D:/bjhsoft/Tomcat 5.0/webapps/new/db/db.mdb;";
//String url="jdbc:oracle:thin:@127.0.0.1:1521:orcl";
String username="cmstar";
String password="cmstar";
Connection conn= null;
ResultSet rs = null;
public DataBase(){
try
{
Class.forName(sDBDriver);
}
catch(java.lang.ClassNotFoundException e)
{
System.err.println("DataBase();"+e.getMessage());
}
}
//執行查詢語句
public ResultSet executeQuery(String sql)
{
rs = null;
try
{
conn = DriverManager.getConnection(url, username, password);
Statement stmt = conn.createStatement();
rs=stmt.executeQuery(sql);
}
catch(SQLException ex)
{
System.err.println("DataBase.executeQuery:"+ex.getMessage());
}
return rs;
}
//執行插入及更新語句
public void executeInsert(String sql)
{
try
{
conn = DriverManager.getConnection(url, username, password);
Statement stmt = conn.createStatement();
stmt.executeUpdate(sql);
}
catch(SQLException ex)
{
System.err.println("DataBase.executeUpdate"+ex.getMessage());
}
}
//執行刪除操作
public void executeDelete(String sql)
{
try
{
conn = DriverManager.getConnection(url, username, password);
Statement stmt=conn.createStatement();
stmt.executeUpdate(sql);
}
catch(SQLException ex)
{
System.err.println("DataBese.executeDelete:"+ex.getMessage());
}
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -