<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
    pageEncoding="ISO-8859-1"%>
<%
            response.setContentType("text/xml");
            String un=request.getParameter("username");
            String pw=request.getParameter("password");

            Class.forName("com.mysql.jdbc.Driver");
            Connection con = DriverManager.getConnection("jdbc:mysql://localhost/feedback?"+"user=root&password=root");
            Statement st=con.createStatement();
            ResultSet rs = st.executeQuery("select distinct state from city where country='"+sn+"'");

                    out.println("<emp>");
                    while(rs.next())
                    {
                        out.println("<empname>"+rs.getString(1)+"</empname>");
                    }
                    out.println("</emp>");

rs.close();
st.close();
con.close();

%>