Ubuntu Indo

Monday, November 26, 2012

Koneksi Java ke MySQL dengan JDBC

Berikut contoh class koneksi Java ke database MySQL menggunakan JDBC. Sebelumnya import library MySQL JDBC Driver ke project. Apabila menggunakan NetBean IDE, caranya adalah klik kanan pada Libraries > pilih Add Library… (gambar 1). Setelah itu baru buat java class dengan nama DatabaseConnection, berikut source codenya:

package controller; import com.mysql.jdbc.Connection; import java.sql.DriverManager; import java.sql.SQLException; /** * @about : class untuk koneksi ke database MySQL dengan JDBC */ public class DatabaseConnection { private Connection con = null; private static DatabaseConnection dbcon = null; static final String DB_URL = "jdbc:mysql://localhost:3306/latihan"; static final String DB_USER = "root"; static final String DB_PASS = ""; // constructor public DatabaseConnection() { if (con == null) { try { // loading driver Class.forName("com.mysql.jdbc.Driver").newInstance(); // connect ke database con = (Connection) DriverManager.getConnection(DB_URL, DB_USER, DB_PASS); System.out.println("Koneksi Berhasil"); } catch (Exception ex) { System.out.println("Koneksi Gagal"); } } } // mengecek apakah sudah ada koneksi public static DatabaseConnection getInstance() { DatabaseConnection con = null; if (dbcon == null) { dbcon = new DatabaseConnection(); con = dbcon; } else { con = dbcon; } return con; } public Connection getCon() throws SQLException { return this.con; } }

Sekarang kita bisa panggil class tersebut pada class lain, contohnya buat java class dengan nama TesConnection, berikut contoh source codenya:

package controller; import java.sql.Connection; import java.sql.SQLException; import java.util.logging.Level; import java.util.logging.Logger; /** * @about : coba koneksi */ public class TestConnection { public static void main(String[] args) { DatabaseConnection koneksi = DatabaseConnection.getInstance(); try { Connection con = koneksi.getCon(); } catch (SQLException ex) { Logger.getLogger(TestConnection.class.getName()).log(Level.SEVERE, null, ex); } } }

References : http://thesuhu.wordpress.com/2011/11/04/koneksi-java-ke-mysql-dengan-jdbc/
http://bisakomputer.com/koneksi-database-mysql-berbasis-gui-menggunakan-java/

Membuat Syntax Highlighter di Blog

Mudah Membuat Syntax Highlighter di Blog ~ Apakah anda merasa asing dengan istilah tersebut atau bahkan sebaliknya, istilah Syntax Highlighter sudah sering terdengar di telinga anda?. Jangan lupa baca juga Cara Mudah Membatasi Jumlah Tampilan Posting Label Blog.

Syntax Highlighter atau Penyorotan Sintaks adalah fitur dari beberapa editor teks yang menampilkan teks, terutama source code dalam berbagai warna serta font sesuai dengan kategori istilah.

Fitur ini memudahkan kita dalam menulis dalam bahasa terstruktur seperti bahasa pemrograman atau bahasa markup serta penulisan berupa syntax-syntax blog. Berikut ini cara membuat syntax highlighter di blog :

1. Login ke akun blogger anda

2. Klik Menu Rancangan, lalu pilih Edit HTML

3. Jangan lupa centang terlebih dahulu

4. Cari kode ]]></b:skin> dan letakkan kode di bawah ini sebelum kode ]]></b:skin>

.dp-highlighter
{
 font-family: "Consolas", "Monaco", "Courier New", Courier, monospace;
 font-size: 12px;
 background-color: #E7E5DC;
 width: 99%;
 overflow: auto;
 margin: 18px 0 18px 0 !important;
 padding-top: 1px; /* adds a little border on top when controls are hidden */
}

/* clear styles */
.dp-highlighter ol,
.dp-highlighter ol li,
.dp-highlighter ol li span
{
 margin: 0;
 padding: 0;
 border: none;
}

.dp-highlighter a,
.dp-highlighter a:hover
{
 background: none;
 border: none;
 padding: 0;
 margin: 0;
}

.dp-highlighter .bar
{
 padding-left: 45px;
}

.dp-highlighter.collapsed .bar,
.dp-highlighter.nogutter .bar
{
 padding-left: 0px;
}

.dp-highlighter ol
{
 list-style: decimal; /* for ie */
 background-color: #fff;
 margin: 0px 0px 1px 45px !important; /* 1px bottom margin seems to fix occasional Firefox scrolling */
 padding: 0px;
 color: #5C5C5C;
}

.dp-highlighter.nogutter ol,
.dp-highlighter.nogutter ol li
{
 list-style: none !important;
 margin-left: 0px !important;
}

.dp-highlighter ol li,
.dp-highlighter .columns div
{
 list-style: decimal-leading-zero;
 list-style-position: outside !important;
 border-left: 3px solid #6CE26C;
 background-color: #F8F8F8;
 color: #5C5C5C;
 padding: 0 3px 0 10px !important;
 margin: 0 !important;
 line-height: 14px;
}

.dp-highlighter.nogutter ol li,
.dp-highlighter.nogutter .columns div
{
 border: 0;
}

.dp-highlighter .columns
{
 background-color: #F8F8F8;
 color: gray;
 overflow: hidden;
 width: 100%;
}

.dp-highlighter .columns div
{
 padding-bottom: 5px;
}

.dp-highlighter ol li.alt
{
 background-color: #FFF;
 color: inherit;
}

.dp-highlighter ol li span
{
 color: black;
 background-color: inherit;
}

/* Adjust some properties when collapsed */
.dp-highlighter.collapsed ol
{
 margin: 0px;
}

.dp-highlighter.collapsed ol li
{
 display: none;
}

/* Additional modifications when in print-view */
.dp-highlighter.printing
{
 border: none;
}

.dp-highlighter.printing .tools
{
 display: none !important;
}

.dp-highlighter.printing li
{
 display: list-item !important;
}

/* Styles for the tools */
.dp-highlighter .tools
{
 padding: 3px 8px 3px 10px;
 font: 9px Verdana, Geneva, Arial, Helvetica, sans-serif;
 color: silver;
 background-color: #f8f8f8;
 padding-bottom: 10px;
 border-left: 3px solid #6CE26C;
}

.dp-highlighter.nogutter .tools
{
 border-left: 0;
}

.dp-highlighter.collapsed .tools
{
 border-bottom: 0;
}

.dp-highlighter .tools a
{
 font-size: 9px;
 color: #a0a0a0;
 background-color: inherit;
 text-decoration: none;
 margin-right: 10px;
}

.dp-highlighter .tools a:hover
{
 color: red;
 background-color: inherit;
 text-decoration: underline;
}

/* About dialog styles */
.dp-about { background-color: #fff; color: #333; margin: 0px; padding: 0px; }
.dp-about table { width: 100%; height: 100%; font-size: 11px; font-family: Tahoma, Verdana, Arial, sans-serif !important; }
.dp-about td { padding: 10px; vertical-align: top; }
.dp-about .copy { border-bottom: 1px solid #ACA899; height: 95%; }
.dp-about .title { color: red; background-color: inherit; font-weight: bold; }
.dp-about .para { margin: 0 0 4px 0; }
.dp-about .footer { background-color: #ECEADB; color: #333; border-top: 1px solid #fff; text-align: right; }
.dp-about .close { font-size: 11px; font-family: Tahoma, Verdana, Arial, sans-serif !important; background-color: #ECEADB; color: #333; width: 60px; height: 22px; }

/* Language specific styles */
.dp-highlighter .comment, .dp-highlighter .comments { color: #008200; background-color: inherit; }
.dp-highlighter .string { color: blue; background-color: inherit; }
.dp-highlighter .keyword { color: #069; font-weight: bold; background-color: inherit; }
.dp-highlighter .preprocessor { color: gray; background-color: inherit; }

5. Cari kode </head> dan letakkan kode di bawah ini sebelum kode </head>

6. Cari kode </body> dan letakkan kode di bawah ini sebelum kode </body>

Info :

Setiap mempublikasikan post yang terdapat kode-kode di dalamnya, sobat blogger harus memasukkan kode tersebut seperti contoh d bawah ini!

<textarea name="code" class="c#" cols="60" rows="10">

Kode Yang Akan Ditampilkan Diletakkan Disini

</textarea>

References : http://bangvandawablog.blogspot.com/2012/10/cara-mudah-membuat-syntax-highlighter-diblog.html

Wednesday, November 14, 2012

Disk drive for /boot is not ready yet or not present?

fter a long gap,I am back to Ubuntu from Fedora and I am really impressed by the pleasing interface ‘Lucid Lynx’ comes up with.

After installing Windows XP ,I installed Ubuntu 10.04.The installation process was smooth.But the problem I faced when I restarted the system is, at the splash startup screen.It said ,
The disk drive for /boot is not ready yet or not present.
Continue to wait, press S to skip or M for manual recovery.
I waited for a long time and it is of no use.so I skipped the process and edited some file to mount it automatically.
here is what I did,

1.Open your terminal by ctrl+alt+t or Applications –> Accessories –> Terminal

2.use the below command in terminal,

gksudo gedit /etc/fstab

3.A file will open,find /boot line.It will look something like this ,

/dev/sda2 /boot ext4 defaults 0 0

4.Now open another terminal and use the below command ,

ls -l /dev/disk/by-uuid

5.Now find the UUID for /dev/sda2 and replace the below line in fstab ,

/dev/sda2 /boot ext4 defaults 0 0

as

UUID=a647ea33-74ee-4123-84bf-7edc32e2e39b /boot ext4 defaults 0 0

[Replace the UUID number with your number]

6.save the file and restart the system.It will work fine.The same solution can be addressed for /dev/sda mounting problem.