Search

Hi, I have a project in which I am trying to enter "Marathi" (Indian local language) data in JSP using JSTL and trying to search data from MYSQL . In mySQL Marathi data is stored. But when I enters data in JSP and tries to search then It shows no data from database. Then for seeing whether I entered marathi data is properly submitted to MySQL. I again displayed Marathi data in same JSP page using JSTL then some symbols came. I am pasting my JSP code : All is correct I can get data from MYSQL when I uses select * command or I enters search according to ID (because it is english ) it shows correct o/p table from MYSQL. I just wants to enter Marathi data and show corresponding table from mySQL . My JSP Code:

<%@page contentType="text/html;charset=UTF-8" pageEncoding="UTF-8" %> <%@taglib uri="http://java.sun.com/jsp/jstl/core" prefix="C" %> <%@taglib uri="http://java.sun.com/jsp/jstl/sql" prefix="SQL" %> <%@ taglib uri="http://java.sun.com/jsp/jstl/fmt" prefix="fmt" %>

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

<%request.setCharacterEncoding("UTF-8") ;%>

---

<C:set var="d" value="${param.IDone}"/> <C:set var="d1" value="${param.nameone}"/> <C:set var="d2" value="${param.sirnameone}"/> <C:if test="${d!=null}"> <SQL:setDataSource url="jdbc:mysql://localhost/election" driver="com.mysql.jdbc.Driver" user="root" password="root" var="T"/> <SQL:query var="T1" dataSource="${T}">select * from voterinfo where ID=? <SQL:param value="${d}"/> <C:if test="${d1!=null}"> <SQL:setDataSource url="jdbc:mysql://localhost/election" driver="com.mysql.jdbc.Driver" user="root" password="root" var="T"/> <SQL:query var="T1" dataSource="${T}">select * from voterinfo where first_name=? <SQL:param value="${d1}"/> Name ---<C:out value="${d1}"/>

<C:if test="${d2!=null}"> <SQL:setDataSource url="jdbc:mysql://localhost/election" driver="com.mysql.jdbc.Driver" user="root" password="root" var="T"/> <SQL:query var="T1" dataSource="${T}">select * from voterinfo where last_name=?<SQL:param value="${d2}"/> SirName ---<C:out value="${d2}"/>

Serial No	Voter ID	First Name	Middle Name	Last Name	Yaadi Bhaag	Voter's Area