Checkthis out!!!
serviceDB.java
package Servis;
import java.sql.*;
import java.util.logging.Level;
import java.util.logging.Logger;
public class ServiceDB {
private Connection con;//mendeklarasikan variabel koneksi
private Statement stm;//mendeklarasikan variabel statement
public ServiceDB(String tipe) {
if(tipe == "access"){//untuk database ms. access
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");//class untuk connect ms. acces
} catch (ClassNotFoundException ex) {
ex.printStackTrace();
}
}
}
public void koneksiAccess(String dbName){
try {
con = DriverManager.getConnection("jdbc:odbc:dbwarnet","","");//driver ms acces dan tempat untuk menaruh nama database ,jika ada username dan password harap diisi
} catch (SQLException ex) {
ex.printStackTrace();
}
}
public ResultSet getResultSet(String perintah)throws SQLException{//untuk menampung hasil
stm = con.createStatement();
ResultSet set = null;
boolean hasilcek = stm.execute(perintah);
if(hasilcek){
set = stm.getResultSet();
}
return set;
}
public void closeit(){
try {
con.close();//menutup koneksi
} catch (SQLException ex) {
Logger.getLogger(ServiceDB.class.getName()).log(Level.SEVERE, null, ex);
}
}
}
sekian terima kasih....

Tidak ada komentar:
Posting Komentar