Amoraboti - Program
Rashed - Uz - Zaman (Rasel)
  Home About Me Brainstorming Facebook Fan Page Contact    
  Author
I'm Rz Rasel
From Bangladesh

  Archives
April 2010
May 2010
January 2011
February 2011
January 2012
February 2012
March 2012

  Current

  Previous Posts
Multiple Checkbox Select/Deselect JavaScript And j...
Dynamically Add/Remove rows in HTML table using Ja...
Dynamically add button, textbox, input, radio elem...
Changing Form Input (Textbox) Style on Focus using...
Duration Calculator Between Two Dates
Get Cursore Position In JavaScript
Hide And Prevent Copy Of Web Content Using JavaSri...
Hide All Content Of Website Using JavaScript Html Css
Ajax Post Method
Ajax getting xmlhttprequest to loop continuously

  My Link
Islam And We
My Diary (Bangla)
My Diary (English)
My Lyrics (Bangla)
My Lyrics (English)
My Poem (Bangla)
My Poem (English)
My Story (Bangla)
My Story (English)
General Knowledge
Fun And Jokes
Lyrics (Bangla)
Lyrics (English)
Lyrics (Hindi)
Quotations
 
 
  How To Insert Unicode Values To MySQL Using Java  
  Monday, January 2, 2012  
 
How To Insert Unicode Values To MySQL Using Java

Create a database in MySQL
I used phpMyAdmin to create my database and sometimes i used MySQL GUI tools for check my values.
MySQL GUI tools support to view Unicode values from a database
See my SQL backup file below and you can restore this backup file using phpMyAdmin.

--
-- Database: `unicode`
--
CREATE DATABASE `unicode` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
USE `unicode`;

-- --------------------------------------------------------

-- --------------------------------------------------------

--
-- Table structure for table `unicode`
--

CREATE TABLE IF NOT EXISTS `unicode`
(
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(100) NOT NULL,
`job` varchar(50) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=20 ;

/*
* To change this template, choose Tools | Templates
* and open the template in the editor.
*/

package javaapplication1;

import java.sql.Connection;
import java.sql.DriverManager;
import javax.swing.JOptionPane;

/**
*
* @author Developer
*/
public class connection {

public Connection creatConnection () throws ClassNotFoundException
{
Connection conn=null;

try
{
Class.forName("com.mysql.jdbc.Driver").newInstance();//call jdbc driver
String url = "jdbc:mysql://localhost/unicode?useUnicode=true&characterEncoding=UTF-8";//getting url
conn = DriverManager.getConnection(url,"root","");//create connection
}

catch (Exception e)
{
// JOptionPane.showMessageDialog(null,"Error occured!.."+ e.getLocalizedMessage());
JOptionPane.showMessageDialog(null, e.getMessage(), "Ooops",JOptionPane.ERROR_MESSAGE, null);//exeption hanling
}

return conn;//return connection to all
}

}
  
  posted by Rz Rasel At 6:32 PM,

0 Comments:

Post a Comment

<< Home

 
     
 
  Problem In Font
Download then zip file unzip and install in your system. Or normal font file just install in your system font folder. Rz Rasel
Bangla Font
Bangla Font

  Find Me In Facebook
 
 

   aaaa
 

   aaaa
 
 
Copyright © 2010 - Amoraboti - Program. ® All right reaserved. Design and developed by:- Rz Rasl