package koneksi;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import javax.swing.JOptionPane;
public class Database {
private static Connection koneksi;
private ResultSet rs;
private Statement st;
public static Connection dbconnect(){
if(koneksi == null) {
try {
DriverManager.registerDriver(new com.mysql.jdbc.Driver());
koneksi = DriverManager.getConnection("jdbc:mysql://localhost/bjta2","root","");
} catch(java.sql.SQLException ex) {
JOptionPane.showMessageDialog(null, "SQLException: "+ex.getMessage()+
"\nSQLState: "+ex.getSQLState()+"\nVendorError: "+ex.getErrorCode());
}
}
return koneksi;
}
//Lihat semua data
public ResultSet lihatData(String a){
try {
st = koneksi.createStatement();
rs = st.executeQuery(a);
} catch(java.sql.SQLException e){
JOptionPane.showMessageDialog(null, "Gagal Lihat Data");
}
return rs;
}
//Nambah Data
public void insertData(String data){
try {
st = koneksi.createStatement();
st.executeUpdate(data);
} catch(java.sql.SQLException e){
JOptionPane.showMessageDialog(null, "SQLException: "+e.getMessage()+
"\nSQLState: "+e.getSQLState()+"\nVendorError: "+e.getErrorCode());
}
}
//Cek Data
public ResultSet CekData(String a){
try {
long lrow;
st = koneksi.createStatement();
rs = st.executeQuery(a);
st.getResultSet();
rs.last();
lrow = rs.getRow();
} catch(java.sql.SQLException e){
JOptionPane.showMessageDialog(null, e);
}
return rs;
}
}
No comments:
Post a Comment