Paket Dao;
impor java.sql.*;
kelas publik berdasarkan {
//peramal
// string final statis pribadi dirver = "oracle.jdbc.driver.oracledriver";
// private static final string url = "jdbc: oracle: tipis: @localhost: 1521: xe";
// name string final statis private = "admin";
// Private Static Final String Pass = "123";
// sqlserver
// string final statis private Dirver = "com.microsoft.sqlserver.jdbc.sqlServerDriver";
// private static final string url = "jdbc: sqlserver: // localhost: 1433; databaseName = tbldb";
// name string final statis private = "SA";
// Private Static Final String Pass = "SA";
// mysql
Private Static Final String Dirver = "com.mysql.jdbc.driver";
private static final string url = "jdbc: mysql: //127.0.0.1: 3306/sekolah";
name string final statis pribadi = "root";
Private Static Final String Pass = "123456";
Koneksi publik getCconnection ()
{
Koneksi conn = null;
mencoba {
Class.forname (Dirver);
conn = driverManager.getConnection (url, name, pass);
} catch (Exception e) {
e.printstacktrace ();
}
return conn;
}
public void Closall (Connection Conn, PreparedStatement PS, hasil RS)
{
mencoba {
if (null! = rs)
rs.close ();
if (null! = ps)
ps.close ();
if (null! = conn)
conn.close ();
} catch (Exception e) {
e.printstacktrace ();
}
}
Public Int ExecuteUpdate (String SQL, String PARMS [])
{
Koneksi conn = null;
Disiapkan ps = null;
Hasil int = -1;
mencoba {
Conn = getCconnection ();
ps = conn.preparestatement (SQL);
if (null! = parms) {
untuk (int i = 0; i <parms.length; i ++) {
ps.setstring (i+1, parms [i]);
}
}
hasil = ps.executeUpdate ();
menjalankan();
} catch (Exception e) {
System.out.println (e.getMessage ());
}Akhirnya{
Closall (Conn, PS, null);
}
hasil pengembalian;
}
public static void main (string [] args) melempar pengecualian
{
Berbasis b = new berbasisao ();
Koneksi con = b.getcconnection ();
System.out.println (con.isclosed ());
}
}