Hi friends

   I want to do one program to read the chinese characters from mysql table
and display them using JSP.


<%...@page language="java"
import="java.io.*,java.text.*,java.sql.*,java.util.*"%>

<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>

<%

request.setCharacterEncoding("UTF-8");

String qryStr = request.getParameter("q");

qryStr = qryStr == null ? "" : qryStr;

%>

<html>

<head>

<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">



<HTML>

<HEAD>

<TITLE>ZAU Details</TITLE>

</HEAD>

</head>





<LINK REL=stylesheet HREF="ssl.css" TYPE="text/css">

<style type="text/css">

<!--

body {

margin-left: 20px;

margin-top: 20px;

}

-->

</style>

<LINK REL=stylesheet HREF="ssl.css" TYPE="text/css">

<style type="text/css">

<!--

body {

margin-left: 20px;

margin-top: 20px;

}

-->

</style>



<body bgcolor='#DFF8FF'>

<%

Connection con = null;

Connection con_1 = null;

String DbDriver = "org.gjt.mm.mysql.Driver";

String url = "jdbc:mysql://203.116.109.00/";

String DbName = "smhkweb";

String DbUser = "dbuser";

String DbPassword = "*****";

out.println("<table width=\"100%\" border=\"1\" cellpadding=\"4\"
cellspacing=\"1\">");

try

{

Class.forName(DbDriver).newInstance();

con_1 = DriverManager.getConnection(url + DbName + "?user=" + DbUser +
"&password=" + DbPassword);

Statement stmt_1 = con_1.createStatement();

ResultSet rs_1 = stmt_1.executeQuery("select * from callreport");

while (rs_1.next()){

out.println(rs_1.getString("customerName"));



out.println("<br>");

}

}

catch(Exception e)

{

out.println(e.toString());

}

con_1.close();





%>

 </BODY>

</HTML>

 but i am not getting chinese charater output.Pls help to solve



thanks

Priya

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Java 
EE (J2EE) Programming with Passion!" group.
To post to this group, send email to 
java-ee-j2ee-programming-with-passion@googlegroups.com
To unsubscribe from this group, send email to 
java-ee-j2ee-programming-with-passion+unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/java-ee-j2ee-programming-with-passion?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to