1.flvmediaplay组件的contentPath只支持绝对路径
2.在下面的示例中,这样写是没有问题,但一旦我改成select * from compony where id='"+id+"'";就会出错了,奇怪,我用*都选出来也不行,
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
conn=DriverManager.getConnection("jdbc:odbc:webim","sa","");
Statement stmt=conn.createStatement();
String sqlstr="select name,info,lianxiren,email,tel,web from compony where id='"+id+"'";
ResultSet rs=stmt.executeQuery(sqlstr);
out.println("<?xml version=/"1.0/" encoding=/"UTF-8/"?>");
out.println("<infolist>");
while(rs.next()){
out.println("<node>");
out.newLine();
out.println("<name>"+rs.getString("name")+"</name>");
out.newLine();
out.println("<info>"+rs.getString("info")+"</info>");
out.newLine();
out.println("<lianxiren>"+rs.getString("lianxiren")+"</lianxiren>");
out.newLine();
out.println("<email>"+rs.getString("email")+"</email>");
out.newLine();
out.println("<tel>"+rs.getString("tel")+"</tel>");
out.newLine();
out.println("<web>"+rs.getString("web")+"</web>");
out.newLine();
out.println("</node>");
out.newLine();
}
out.println("</infolist>");
response.setContentType("text/xml;Charset=utf-8");
conn.close();
stmt.close();