10.21日进度报告

今天实现了需求管理功能
<%@ page language="java" contentType="text/html; charset=utf-8"
    pageEncoding="utf-8" import="java.sql.*" import="java.util.List" import="java.util.ArrayList" import="net.sf.json.JSONArray"%>

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>需求管理</title>
</head>
<body>
    <div bgcolor="#E7E7E7">
    需求管理<br/>
    </div>
        <form name="form0" action="xqmanage_per.jsp" method="post">
            <table>
                <tr bgcolor="#E7E7E7">
                <td>需求名称
                    <input type="text" name="xqname">
                    <input type="submit" value="查询">
                </td>
                </tr>
            </table>
        </form>
    <form name="form1" id="form1" action="">
        <table border="1" width="900" name="table1" id="table1">
            <tr>
                <td>需求编号</td>
                <td>需求名称</td>        
                <td>归口管理</td>
                <td>所在地域</td>
                <td>法人代表</td>
                <td>联系人</td>
                <td>机构属性</td>
                <td>关键字</td>
                <td>拟投入资金总额</td>
                <td>技术需求解决方式</td>
                <td>科技活动类型</td>     
                <td>需求状态</td>
                <td>操&nbsp;&nbsp;作&nbsp;</td>
                <td>操&nbsp;&nbsp;作&nbsp;</td>
            </tr>
            <jsp:useBean id="db" class="DBBean.Bean" scope="page" />
            <%
                String Inamenum = "";
                String Iresult = "";
                String Ixqname = "";
                String Ixqbelong ="";
                String Ifrdb="";
                String Iszdy="";
                String Iclient="";
                String Igjz1="";
                String Izjze="";
                String Ihzms ="";
                String Itype="";
                String Ipeoprety="";
            
                
                
                String Iname = session.getAttribute("Iname").toString();
//                 String xsreason="";
//                 String sql2="";//用来查询未通过的原因，用于显示原因
                 System.out.println(" ");
                System.out.println("xqmanage.jsp 界面信息：");
                System.out.println("需求管理界面的Iname:" + Iname);
                String sql = "select Inamenum,Ixqname,Ixqbelong,Iszdy,Ifrdb,Iclient,Ipeoprety,Igjz1,Izjze,Ihzms,Itype,Iresult from xuqiu where Iname=" + "'" + Iname + "'and Itype not like '已删除'";
                //String sql2="select Iresult where"
                ResultSet rs = db.executeQuery(sql);
                while (rs.next()) {
                    //System.out.println(rs.getString(1)); //可以输出Inamenum的所有值  比如Iname为图书馆  那么输出图书馆1  图书馆2  图书馆3
                    Inamenum = rs.getString(1);                    
                    Ixqname = rs.getString(2);
                    Ixqbelong=rs.getString(3);
                    Iszdy=rs.getString(4);
                    Ifrdb=rs.getString(5);
                    Iclient=rs.getString(6);
                    Ipeoprety=rs.getString(7);
                    
                    Igjz1=rs.getString(8);
                    Izjze=rs.getString(9);
                    Ihzms=rs.getString(10);
                    Itype=rs.getString(11);                                                                                        
                    Iresult = rs.getString(12);
                    
                    List list=new ArrayList();
                    list.add(Inamenum);
                    list.add(Ixqname);
                    list.add(Ixqbelong);
                    list.add(Ifrdb);
                    list.add(Iszdy);
                    list.add(Iclient);
                    list.add(Igjz1);
                    list.add(Izjze);
                    list.add(Ihzms);
                    list.add(Itype);
                    list.add(Ipeoprety);
                    list.add(Iresult);
                    
                    
                    JSONArray jsonlist=JSONArray.fromObject(list);
                    System.out.println(jsonlist.toString());
                    out.println("<tr><td>" + Inamenum + "</td><td>" + Ixqname + "</td>"  + 
                            "<td>" + Ixqbelong +
                            "</td><td>" + Iszdy +
                            "</td><td>" + Ifrdb +
                            "</td><td>" + Iclient +
                            "</td><td>" + Ipeoprety +
                            "</td><td>" + Igjz1 +
                            "</td><td>" + Izjze +
                            "</td><td>" + Ihzms +
                            "</td><td>" + Itype +                    
                            "</td><td>" + Iresult+
//                            "</td><td>" + xsreason+
                            "</td><td><a href='del.jsp?Inamenum=" + Inamenum
                            + "'>删除</a>&nbsp;&nbsp;&nbsp;</td><td><a href='saveedit.jsp?Inamenum=" + Inamenum + "'>修改</a></td></tr>");
                }
                

                rs.close();
                db.close();
            %>
        </table>
    </form>
</body>
</html>
View Code
明天完成提交&审核