ajax_index.jsp

jsp+ajax实例

<%@ page contentType="text/html; charset=gb2312"%>
<%@ page import="java.io.*"%>
<%@ page import="java.io.File"%>
<%@ page import="java.text.*" %>
<%@ page import="java.sql.*"%>
<%@ page import="java.util.Date"%>
<%@ page import="java.util.*" %>
<%
response.setContentType("text/xml;charset=gb2312"); 
out.println("<?xml version='1.0'   encoding='gb2312' ?>");
out.println("<music_list>");
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String db=getServletContext().getRealPath("\\")+"music.mdb";
File dbpath=new File(db);
String path = new java.io.File(db).getAbsolutePath();
Connection conn= DriverManager.getConnection("jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};" +"DBQ="+path);
         Statement stmt=conn.createStatement();
		 String str=request.getParameter("q");
		 
String sql="select id,pic,music,name,type from mp3";
if(str==null||str.equals("")||str.equals("all")){}
else
{
str=new String(str.getBytes("iso-8859-1"),"UTF-8");
sql=sql+" where music like '%"+str+"%' or name like '%"+str+"%'";
}
sql=sql+" order by id desc";
ResultSet rs=stmt.executeQuery(sql);
while(rs.next())
{
  out.println("<music>");
  out.println("<id>"+rs.getString("id")+"</id>");
  out.println("<pic>"+rs.getString("pic")+"</pic>");
  out.println("<geming>"+rs.getString("music")+"</geming>");
  out.println("<name>"+rs.getString("name")+"</name>");
  out.println("<type>"+rs.getString("type")+"</type>");
  out.println("</music>");
}
out.println("</music_list>");
%>