Untuk bisa menggunakan database contohnya mysql di java kita harus punya jembatan "istilahnya sebagai alat untuk menyebrangi antara database dan java" yang biasa dibilang connector. Jika menggunakan mysql namanya MySQL JDBC Drive, biasanya jika kita menginstall netbean 7 sudah ada di modul ext nya. jika belum bisa didownload manual. perlu diingat saat buat program ditambahkan library konektor tsb kedalam program javanya (pada folder libraries).
untuk interface databasenya sendiri bisa menggunakan xampp, mysql frontpage dll.
contoh coding untuk koneksi java mysqlnya:
/*
* To change this template, choose Tools | Templates
* and open the template in the editor.
*/
/**
*
* @author Wenda
*/
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class Koneksi {
private Connection con;
private Statement stmt;
private ResultSet resultSet;
private PreparedStatement preparedStatement;
private String dsn;
private String login;
private String pwd;
//
// public Koneksi(String dsn, String login, String pwd) {
// this.dsn = dsn;
// this.login = login;
// this.pwd = pwd;
// }
public Connection connect() throws ClassNotFoundException, SQLException {
Class.forName("com.mysql.jdbc.Driver");
con = DriverManager.getConnection("jdbc:mysql://localhost:3306/" + "Namadatabase", "userlogin", "password");
stmt = con.createStatement();
return con;
}
public int executeUpdate(String str) throws SQLException {
return stmt.executeUpdate(str);
}
public ResultSet executeQuery(String str) throws SQLException {
resultSet = stmt.executeQuery(str);
return resultSet;
}
public void disconnect() throws SQLException {
if (resultSet != null) {
resultSet.close();
}
if (stmt != null) {
stmt.close();
}
if (con != null) {
con.close();
}
}
public ResultSet getResultSet() {
return resultSet;
}
public Statement getStatement() {
return stmt;
}
public PreparedStatement getPreparedStatement(String str) throws SQLException {
preparedStatement = con.prepareStatement(str);
return preparedStatement;
}
public Connection getConn() {
return con;
}
}
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment