今天的一些问题小结

来源：互联网发布：电话数据采集器编辑：程序博客网时间：2024/05/18 13:44

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();