Forum:

Searching data using NON English Language Words Doesn't Work!

Pranit Sonawane

Ranch Hand

Posts: 172

I like...

posted 9 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Hi all!
Below is my code

<%-- 
    Document   : closeAc
    Created on : 28 Oct, 2014, 5:08:17 PM
    Author     : Simtech
--%>

<%@page import="javax.swing.JOptionPane"%>
<%@page contentType="text/html; charset=UTF-8" pageEncoding="UTF-8" import="java.sql.*, java.util.Date;"%>
<%
    try {
        request.setCharacterEncoding("UTF-8");
        response.setCharacterEncoding("UTF-8");
        response.setContentType("text/html; charset=UTF-8");
        HttpServletResponse httpResponse = (HttpServletResponse) response;
        httpResponse.setHeader("Cache-Control", "no-cache, no-store, must-revalidate"); // HTTP 1.1.
        httpResponse.setHeader("Pragma", "no-cache"); // HTTP 1.0.
        httpResponse.setDateHeader("Last-Modified", (new Date()).getTime()); // Proxies.        
        HttpSession hs = request.getSession(false);
        hs.getAttribute("suname");
        String u = hs.getAttribute("suname").toString();
        if (hs == null || u.equals("null")) {
            response.sendRedirect("login.jsp");
        } else {
            if (request.getParameter("sid") == null) {

%>
<!DOCTYPE html>
<html>
    <head>
        <title>मालेगांव महानगरपालिका, लेखा विभाग,मालेगांव महानगरपालिका,मालेगांव</title>
        <meta charset="UTF-8">
        <meta name="viewport" content="width=device-width, initial-scale=1.0">        
        <script type="text/javascript" src="js/jquery-1.10.1.min.js"></script>
        <link rel="stylesheet" href="main.css" type="text/css">
        <link rel="icon" href="media/favicon (4).ico">
        <script type="text/javascript" src="js/jquery.min.js"></script>
        <SCRIPT TYPE="text/javascript">
             
        </SCRIPT> 
        <SCRIPT TYPE="text/javascript">
            
        </SCRIPT>
        <script type="text/javascript">
            var rev = "fwd";
            function titlebar(val)
            {
                var msg = "मालेगांव महानगरपालिका, लेखा विभाग,मालेगांव महानगरपालिका,मालेगांव";
                var res = " ";
                var speed = 100;
                var pos = val;
                msg = "   |--- " + msg + " ---|";
                var le = msg.length;
                if (rev == "fwd") {
                    if (pos < le) {
                        pos = pos + 1;
                        scroll = msg.substr(0, pos);
                        document.title = scroll;
                        timer = window.setTimeout("titlebar(" + pos + ")", speed);
                    }
                    else {
                        rev = "bwd";
                        timer = window.setTimeout("titlebar(" + pos + ")", speed);
                    }
                }
                else {
                    if (pos > 0) {
                        pos = pos - 1;
                        var ale = le - pos;
                        scrol = msg.substr(ale, le);
                        document.title = scrol;
                        timer = window.setTimeout("titlebar(" + pos + ")", speed);
                    }
                    else {
                        rev = "fwd";
                        timer = window.setTimeout("titlebar(" + pos + ")", speed);
                    }
                }
            }

titlebar(0);
        </script> 
    </head>
    <body onload="titlebar(val)">
    <center>

});
        </script>

<div class="wrapper">
            <img src="media/admin_26123934_malegaon.jpg" alt="" id="limg">
            <img src="media/admin_26123934_malegaon.jpg" alt="" id="rimg">
            <h1>मालेगांव महानगर पालिका<br>Malegaon Municipal Corporation</h1>                            
            <div class="cont">
                <br><br>
                <div class="somdiv">
                    <div class="search">
                        <form action="" method="post">
                            <table>                                
                                <tr>
                                    <th>विभागः<br><input type="text" name="vibhag" id="vibhag" placeholder="विभाग"></th>                                
                                    <th>खाते क्र.<br><input type="text" name="acno" id="acno" placeholder="खाते क्र."></th>
                                </tr>                                       
                            </table>    
                            <button type="submit" name="search1">शोधा</button>
                        </form>
                        <%                            boolean isset = (request.getParameter("search1") != null);
                            if (isset) {
                                String v = request.getParameter("vibhag");
                                out.println(request.getParameter("acno"));
                                out.println(v);
                                out.println("<br>");
                                Class.forName("com.mysql.jdbc.Driver");
                                Connection cn = DriverManager.getConnection("jdbc:mysql://localhost:3306/mnpac?useUnicode=true&charset=utf8", "root", "pranit");
                                PreparedStatement ps = cn.prepareStatement("select * from opbal where acno = '" + request.getParameter("acno") + "' and vibhag = '" + request.getParameter("vibhag  ") + "'");
                                ResultSet rs = ps.executeQuery();
                                rs.beforeFirst();
                                if (rs.next()) {
                                    rs.beforeFirst();
                                    while (rs.next()) {
                        %>
                        <div class="sresult1">
                            <table>
                                <tr>
                                    <th>नांवः</th>
                                    <td><% out.println(rs.getString("name")); %></td>
                                </tr>
                                <tr>
                                    <th>खाते क्र.</th>
                                    <td><% out.println(rs.getString("acno")); %></td>
                                </tr>
                                <tr>
                                    <th>हुद्दा</th>
                                    <td><% out.println(rs.getString("desi")); %></td>
                                </tr>
                                <tr>
                                    <th>विभागः</th>
                                    <td><% out.println(rs.getString("vibhag")); %></td>
                                </tr>
                                <tr>
                            </table>
                            <form action="closeAc.jsp?sid=<% out.println(rs.getString("id")); %>" method="post"><button type="submit" name="showbut">तपशील दर्शवा</button></form>
                            <hr>
                        </div>
                        <%
                            }
                        } else {
                        %>
                        <b>माहिती उपलब्ध नाहि.</b>
                        <%
                                }
                            }
                        %>
                    </div>
                </div>
                <hr>                
            </div>
        </div>
    </center>
</body>
</html>
<%
} else {

%>
<!DOCTYPE html>
<html>
    <head>
        <title>मालेगांव महानगरपालिका, लेखा विभाग,मालेगांव महानगरपालिका,मालेगांव</title>
        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
        <meta name="viewport" content="width=device-width, initial-scale=1.0">        
        <script type="text/javascript" src="js/jquery-1.10.1.min.js"></script>
        <link rel="stylesheet" href="main.css" type="text/css">
        <link rel="icon" href="media/favicon (4).ico">
        <script type="text/javascript" src="js/jquery.min.js"></script>
        <SCRIPT TYPE="text/javascript">
             
        </SCRIPT> 
        <SCRIPT TYPE="text/javascript">
            
        </SCRIPT>
        <script type="text/javascript">
            var rev = "fwd";
            function titlebar(val)
            {
                var msg = "मालेगांव महानगरपालिका, लेखा विभाग,मालेगांव महानगरपालिका,मालेगांव";
                var res = " ";
                var speed = 100;
                var pos = val;
                msg = "   |--- " + msg + " ---|";
                var le = msg.length;
                if (rev == "fwd") {
                    if (pos < le) {
                        pos = pos + 1;
                        scroll = msg.substr(0, pos);
                        document.title = scroll;
                        timer = window.setTimeout("titlebar(" + pos + ")", speed);
                    }
                    else {
                        rev = "bwd";
                        timer = window.setTimeout("titlebar(" + pos + ")", speed);
                    }
                }
                else {
                    if (pos > 0) {
                        pos = pos - 1;
                        var ale = le - pos;
                        scrol = msg.substr(ale, le);
                        document.title = scrol;
                        timer = window.setTimeout("titlebar(" + pos + ")", speed);
                    }
                    else {
                        rev = "fwd";
                        timer = window.setTimeout("titlebar(" + pos + ")", speed);
                    }
                }
            }

titlebar(0);
        </script> 
    </head>
    <body onload="titlebar(val)">
    <center>

});
        </script>

<div class="wrapper">
            <img src="media/admin_26123934_malegaon.jpg" alt="" id="limg">
            <img src="media/admin_26123934_malegaon.jpg" alt="" id="rimg">
            <h1>मालेगांव महानगर पालिका<br>Malegaon Municipal Corporation</h1>                            
            <div class="cont">
                <br><br>
                <div class="somdiv">
                    <div class="search">                                                
                        <%                            Class.forName("com.mysql.jdbc.Driver");
                            Connection cn = DriverManager.getConnection("jdbc:mysql://localhost:3306/mnpac?useUnicode=true&charset=utf-8", "root", "pranit");
                            PreparedStatement ps = cn.prepareStatement("select * from opbal where id = " + request.getParameter("sid") + "");
                            ResultSet rs = ps.executeQuery();
                            rs.beforeFirst();
                            String n, v, a, h = "";
                            while (rs.next()) {
                                n = rs.getString("name");
                                v = rs.getString("vibhag");
                                a = rs.getString("acno");
                                h = rs.getString("desi");
                                out.println(n + "|" + a);
                                PreparedStatement ps1 = cn.prepareStatement("select * from salaries where acno = '" + a + "' and desi='" + h + "'");
                                ResultSet rs1 = ps1.executeQuery();
                                rs1.beforeFirst();
                                while (rs1.next()) {
                        %>
                        <div class="sresult1">
                            <table>
                                <tr>
                                    <th>नांवः </th>
                                    <td><% out.println(rs1.getString("name")); %></td>
                                    <th>खाते क्रः </th>
                                    <td><% out.println(rs1.getString("acno")); %></td>
                                    <th>विभागः </th>
                                    <td><% out.println(v); %></td>
                                    <th>हुद्दाः </th>
                                    <td><% out.println(rs1.getString("desi")); %></td>
                                </tr>
                            </table>
                        </div>
                        <%
                                }
                            }
                        %>
                    </div>
                </div>
                <hr>                
            </div>
        </div>
    </center>
</body>
</html>                
<%
            }
        }
    } catch (Exception exx) {
        out.println(exx.getMessage());
    }
%>

All I'm trying to do is to search the data from the database and is doesn't show up!

Ulf Dittmer

Rancher

Posts: 43081

posted 9 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

At which point does the execution of the code start to deviate from what you expected to happen? What are the inputs you're using, and what the relevant intermediate values? What path does the execution follow through (not what you think it should take, but what it actually takes)? Seeing no debugging output being generated anywhere in the code, how have you tried to debug this issue? In short: TellTheDetails

(As an aside on code quality: a) the use of interpolated SQL instead of properly setting parameters makes using PreparedStatement pointless, b) using scriptlets (a.k.a. Java code in JSP) is an outdated technique to be avoided, and c) comments about obsolete browsers like "(IE4+, NS6+)" do not inspire confidence about the JavaScript part.

Come have lunch with me Arthur. Adventure will follow. This tiny ad:

We need your help - Coderanch server fundraiser

https://coderanch.com/wiki/782867/Coderanch-server-fundraiser