Struts 1.2 - To Store Unicode data into database

[vrushali chaskar]

Hi,
I m using Struts 1.2 ,mysql and JBOSS.
How i able to insert Unicode (Marathi) into database through Action Class?

[Alaa Nassef]

I believe that this would be more appropriate in the struts forum, don't you think?

[Arpit Purohit]

Do Inserting Unicode Data into Database has anything to do with Struts Action class???
Any way....here is the sample code to insert unicode data into mysql using JDBC:

    
// Set up Properties
Properties pr = new Properties();
pr.put("user", "xxxxx");
pr.put("password", "xxxxx");
pr.put("characterEncoding", "utf-8");
pr.put("useUnicode", "true");

// Establish connection to database
Class.forName("com.mysql.jdbc.Driver").newInstance();
Connection connection = DriverManager.getConnection("jdbc:mysql://localhost/mydatabase", pr);
Statement statement = connection.createStatement();

// Insert data into database
statement.executeUpdate("insert into mytable (username) values (\"" + request.getParameter("username") + "\")");

// Close open connections
statement.close();
connection.close();

This can be used any where for the desired functionality.

[Jaikiran Pai]

Doesn't look like either EJB related or Struts related. Moving to Java in General.