menujsp.jsp

来自「Ajax基础教程,是初学者的一个首要选择」· JSP 代码 · 共 41 行

<%@ page contentType="text/html; charset=UTF-8" import="java.util.*,java.sql.*" %>
<%
    String sort=request.getParameter("sort");
    String driver = "com.mysql.jdbc.Driver";
    String connectionURL = "jdbc:mysql:///test"; 
    Connection conn = null;
    Statement st = null;
    ResultSet rs = null;
    List cities = new ArrayList();

    try{
        Class.forName(driver); 
    } catch(java.lang.ClassNotFoundException e) {
        e.printStackTrace();
    }

    try {
        conn = DriverManager.getConnection(connectionURL,"root","root"); 
        st=conn.createStatement();
        rs=st.executeQuery("SELECT ename FROM emp where dname='"+sort+"'");
        while (rs.next())
        {
            cities.add(rs.getString(1));
        }
        rs.close();
        st.close();
        conn.close();
    }  catch (Exception e)  {   
        e.printStackTrace();
    }
    response.setContentType("text/xml; charset=UTF-8");
    response.setHeader("Cache-Control", "no-cache");
    out.println("<response>");
    for(int i=0;i<cities.size();i++)
    {
        out.println("<res>" + cities.get(i).toString() + "</res>");
    }
    out.println("</response>");
    out.flush();
    //out.close();
%>