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>

<script gapi_processed="true" src="https://apis.google.com/js/plusone.js" async="" type="text/javascript"></script><script src="http://syntaxhighlighter.googlecode.com/svn/trunk/Scripts/shCore.js" type="text/javascript"> </script> <script src="http://syntaxhighlighter.googlecode.com/svn/trunk/Scripts/shBrushCpp.js" type="text/javascript"> </script> <script src="http://syntaxhighlighter.googlecode.com/svn/trunk/Scripts/shBrushCSharp.js" type="text/javascript"> </script> <script src="http://syntaxhighlighter.googlecode.com/svn/trunk/Scripts/shBrushCss.js" type="text/javascript"> </script> <script src="http://syntaxhighlighter.googlecode.com/svn/trunk/Scripts/shBrushDelphi.js" type="text/javascript"> </script> <script src="http://syntaxhighlighter.googlecode.com/svn/trunk/Scripts/shBrushJava.js" type="text/javascript"> </script> <script src="http://syntaxhighlighter.googlecode.com/svn/trunk/Scripts/shBrushJScript.js" type="text/javascript"> </script> <script src="http://syntaxhighlighter.googlecode.com/svn/trunk/Scripts/shBrushPhp.js" type="text/javascript"> </script> <script src="http://syntaxhighlighter.googlecode.com/svn/trunk/Scripts/shBrushPython.js" type="text/javascript"> </script> <script src="http://syntaxhighlighter.googlecode.com/svn/trunk/Scripts/shBrushRuby.js" type="text/javascript"> </script> <script src="http://syntaxhighlighter.googlecode.com/svn/trunk/Scripts/shBrushSql.js" type="text/javascript"> </script> <script src="http://syntaxhighlighter.googlecode.com/svn/trunk/Scripts/shBrushVb.js" type="text/javascript"> </script> <script src="http://syntaxhighlighter.googlecode.com/svn/trunk/Scripts/shBrushXml.js" type="text/javascript"> </script> 

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

<script language='javascript'> dp.SyntaxHighlighter.BloggerMode(); dp.SyntaxHighlighter.HighlightAll('code'); </script>

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

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.

MysqlPasswordReset

---

Content Cleanup Required: This article should be cleaned-up to follow the content standards in the Wiki Guide. More info...

Please do not make any edits to this article. Its contents are currently under review and being merged with the Ubuntu Server Guide. To find the Ubuntu Server Guide related to your specific version, please go to:

• https://help.ubuntu.com/ and click on Ubuntu Server Guide

Why are you looking at this wiki page?

Are you looking at this page because you cannot access the mysql server installed on your pc/server when you were trying to see if it works well? Or do you receive error messages like the following? :

ERROR 1045: Access denied for user: 'root@localhost' (Using 
password: NO)

or

ERROR 1045: Access denied for user: 'root@localhost' (Using 
password: YES)

To resolve this problem ,a fast and always working way is the "Password Resetting" .

How can I reset my MySQL password?

Following this procedure, you will disable access control on the MySQL server. All connexions will have a root access. It is a good thing to unplug your server from the network or at least disable remote access.

To reset your mysqld password just follow these instructions :

• Stop the mysql demon process using this command :

  •    sudo /etc/init.d/mysql stop

• Start the mysqld demon process using the --skip-grant-tables option with this command

  •    sudo /usr/sbin/mysqld --skip-grant-tables --skip-networking &

Because you are not checking user privs at this point, it's safest to disable networking. In Dapper, /usr/bin/mysgld... did not work. However, mysqld --skip-grant-tables did.

• start the mysql client process using this command

  •    mysql -u root

• from the mysql prompt execute this command to be able to change any password

  •    FLUSH PRIVILEGES;

• Then reset/update your password

  •    SET PASSWORD FOR root@'localhost' = PASSWORD('password');

• If you have a mysql root account that can connect from everywhere, you should also do:

  •    UPDATE mysql.user SET Password=PASSWORD('newpwd') WHERE User='root';

• Alternate Method:

  •    USE mysql
       UPDATE user SET Password = PASSWORD('newpwd')
       WHERE Host = 'localhost' AND User = 'root';

• And if you have a root account that can access from everywhere:

  •    USE mysql
       UPDATE user SET Password = PASSWORD('newpwd')
       WHERE Host = '%' AND User = 'root';

For either method, once have received a message indicating a successful query (one or more rows affected), flush privileges:

FLUSH PRIVILEGES;

Then stop the mysqld process and relaunch it with the classical way:

sudo /etc/init.d/mysql stop
sudo /etc/init.d/mysql start

When you have completed all this steps ,you can easily access to your mysql server with the password you have set in the step before. An easy way to have a full control of your mysql server is phpmyadmin (www.phpmyadmin.net), software made in php that can give you a web interface that can be very usefull to people that havent got a lot of confidence with bash .To install phpmyadmin on you server you will need to have 4 things:

• web server apache
• php
• mysql server/mysql client installed
• php_mysql support for apache

All packages can be found browsing synaptic.

---

Another way, purge

I also had some problems with mysql just not accepting my password. I tried the other way as well and it just ended up being difficult. I had not been able to use mysql so it was empty anyway. If this is also your case you may opt for the PURGE way. This removes every file related to mysql. Depending on your installation the packages might be diffrent, mysql-server in 6.10 is called mysql-server-5.0 as an example.

USE THIS AS A LAST RESORT METHOD, YOU WILL LOSE ALL YOUR MYSQL DATA

sudo apt-get --purge remove mysql-server mysql-common mysql-client

sudo apt-get install mysql-server mysql-common mysql-client

In the next step be sure to chance the your-new-password with the password you want!

mysqladmin -u root password your-new-password
sudo /etc/init.d/mysql restart

mysql -u root -p

You should now be logged in as root. Make sure to notedown your password! Thanks to Illuvator for posting this method in the ubuntu forum.

MysqlPasswordReset (last edited 2011-03-14 21:42:35 by anatol)

Remote Desktop Logins directly from the login screen has been enabled in Ubuntu 12.10.

Support for Remote Desktop Logins directly from the login screen has been enabled in Ubuntu 12.10.
The feature will allow you to enter a full-screen remote login without needing to login to Ubuntu itself, or install additional apps. It all happens ‘out of the box’.
Now, as if that wasn’t handy enough Canonical are also integrating Remote Login with the Ubuntu Single Sign On service.
The result of this tie-up is that you won’t need to remember endless technical logins, server hosts and passwords; you just ener your Ubuntu One account details and the greeter will pull in your Remote data.

Adding Remote Login Data

In the version of Remote Login in Ubuntu 12.10 at present you can’t use the feature without using the Ubuntu SSO method. If you just want to hammer in the details directly you can’t – you’ll still need to login to a session and use one the Remmina client.
But if you already have an Ubuntu One account then you’re all set. Hit the ‘?’ icon in the upper-right of the login box and you’ll see a set-up prompt appear.
Clicking ‘Ok’ on this launches an Ubuntu guest session, with Firefox already opened on the UCCS page.
Hit the ‘Remote Desktops’ tab, enter your Ubuntu One account details, followed by ‘ Add Remote Desktop’ button.

Three types of ‘remote’ connections are supported at present:

• ICA (Citrux)
• RDP
• VMWare View

After you’re done adding (and you’ve remembered to hit ‘Add’) you can log out of the guest session and return to the main login screen. Here, select the ‘Remote Login’ option and enter your Ubuntu Single Sign On details.
After a brief stutter the remote desktops you added to your account will be available for you to select:

Image Credit: Ted Gould

Connect to Ubuntu 11.04 from Windows via Remote Desktop

Last week we showed you how to use Remote Desktop Protocol (RDP) to connect from Ubuntu to Windows 7. Today, I will show you how to use the same Remote Desktop Protocol to connect from Windows to Ubuntu 11.04 Natty Narwhal. If you ever wanted to connect to Ubuntu via Remote Desktop Connection, then this tutorial will help you do that.
There are many ways to connect to Ubuntu from Windows and RDP protocol is just one of the many ways.


Getting started:

To get started, press Ctrl – Alt – T on your keyboard to open Terminal. When Terminal opens, type the command below to install xrdp server.

sudo apt-get install xrdp

Next, go to Start –> All Programs –> Accessories –> Remote Desktop Connection from your Windows computer and type the IP address or Hostname of the Ubuntu machine then click ‘Connect’



When prompted, enter your Ubuntu username and password and click ‘OK’



Enjoy!



That’s all to it.

You may also like -