<%@page contentType="text/html" pageEncoding="UTF-8"%>
<%@page import="java.sql.* "%>
<%@page import="java.util.* "%>
<%@page import="java.io.* "%>
<%@page import="java.lang.* "%>
<%
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc:odbc:Ybz");
Statement stat=con.createStatement();
ResultSet rs=stat.executeQuery("select * from [case] ");
//或者
// PreparedStatement pstat=con.prepareStatement("select * from 数据库表的名称 where ID=?");
// pstat.setString(1,值);
// ResultSet rs=pstat.executeQuery();
StringBuilder jsonStr = new StringBuilder();
jsonStr.append("{data:[");
while(rs.next())
{
jsonStr.append("{");
jsonStr.append("'id':'" + rs.getString(1) + "',");
jsonStr.append("'name':'" + rs.getString(2) + "',");
jsonStr.append("'sex':'" + rs.getString(3) + "',");
jsonStr.append("'age':'" + rs.getString(4) + "',");
jsonStr.append("'birthplace':'" + rs.getString(5) + "',");
jsonStr.append("'casetype':'" + rs.getString(6) + "',");
jsonStr.append("'casename':'" + rs.getString(7) + "',");
jsonStr.append("'diagnosis':'" + rs.getString(8) + "',");
jsonStr.append("'chcom':'" + rs.getString(9) + "',");
jsonStr.append("'pex':'" + rs.getString(10) + "',");
jsonStr.append("'addiagnosis':'" + rs.getString(11) + "',");
jsonStr.append("'pathcon':'" + rs.getString(12) + "',");
jsonStr.append("'disdiagnosis':'" + rs.getString(13) + "'");
jsonStr.append("},");
}
jsonStr.delete(jsonStr.length()-1,jsonStr.length());
//jsonStr=jsonStr.substring(0,jsonStr.length()-1);
jsonStr.append("],totalProperty:100}");
response.getWriter().write(jsonStr.toString() );
%>