Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <%@ 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();
- %>
Add Comment
Please, Sign In to add comment