还是昨天的那段代码 iplinger(罗宾汉)<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<!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=gb2312">
<jsp:useBean id="mdb" class="com.db.DatabaseConn" scope="page"/>
<title></title>
</head>
<body>
<%
String sql="";
String sqlstr="";
String sql2="";
sql=(String)session.getAttribute("sql");
ResultSet rs=mdb.Query(sql);
//学生类型
//sqlstr="select * from xueshengleixing";
//ResultSet rsstr=mdb.Query(sqlstr);
//课程类型
//sql2="select * from kechengleixing";
//ResultSet rs2=mdb.Query(sql2);
//System.out.println(rs2.getString(1));
%>
<form action="" method="post">
<table width="1450" border="1" align="center">
<tr>
<td width="80">课程代码</td>
<td width="80">教师代码</td>
<td width="80">课程名称</td>
<td width="80">课程种类</td>
<td width="100">开课日期</td>
<td width="80">学生类型</td>
<td width="90">学生数目</td>
<td width="90">班级数目</td>
<td width="90">授课学时</td>
<td width="90">试验学时</td>
<td width="90">开 新 课</td>
<td width="90">新 开 课</td>
<td>外语授课</td>
<td width="90">有无助教</td>
<td width="90">工 作 量</td>
</tr>
<%
while(rs.next())
{
%>
<tr>
<td><%=rs.getString(1)%></td>
<td><%=rs.getString(2)%></td>
<td><%=rs.getString(3)%></td>
<td>
<select>
<%//课程种类
sql2="select * from kechengleixing";
ResultSet rs2=mdb.Query(sql2);
while(rs2.next())
{
%>
<option value="<%=rs2.getString(1)%>"
<%
if((rs2.getString(1)!=null && rs2.getString(1).equals(rs.getString(4)))){out.print("selected");}
//System.out.println(rs2.getString(1));
//System.out.println(rs.getString(4));
%>
><%=rs2.getString(1)%></option>
<%
}
%>
</select>
</td>
<td><%=rs.getString(5)%></td>
<td>
<select>
<%//学生类型
sqlstr="select * from xueshengleixing";
ResultSet rsstr=mdb.Query(sqlstr);
while(rsstr.next())
{
%>
<option value="<%rsstr.getString(1)%>"
<%
if((rsstr.getString(1)!=null && rsstr.getString(1).equals(rs.getString(6)))){out.print("selected");}
System.out.println(rsstr.getString(1));
System.out.println(rs.getString(6));
%>
><%=rsstr.getString(1)%></option>
<%
}
%>
</select>
</td>
<td><%=rs.getString(7)%></td>
<td>
<select>
<%//班级数目
for(int i=1;i<=8;i++)
{
%>
<option value="<%=i%>"<%if(i==rs.getInt(8))out.print("selected");%>><%=i%></option>
<%
}
%>
</select>
</td>
<td><%=rs.getString(9)%></td>
<td><%=rs.getString(10)%></td>
<td>
<select>
<option value="1" <%if(rs.getInt(11)==1)out.print("selected");%>>是</option>
<option value="0" <%if(rs.getInt(11)==0)out.print("selected");%>>否</option>
</select>
</td>
<td>
<select>
<option value="1" <%if(rs.getInt(12)==1)out.print("selected");%>>是</option>
<option value="0" <%if(rs.getInt(12)==0)out.print("selected");%>>否</option>
</select>
</td>
<td>
<select>
<option value="1" <%if(rs.getInt(13)==1)out.print("selected");%>>是</option>
<option value="0" <%if(rs.getInt(13)==0)out.print("selected");%>>否</option>
</select>
</td>
<td width="57">
<select>
<option value="1" <%if(rs.getInt(14)==1)out.print("selected");%>>是</option>
<option value="0" <%if(rs.getInt(14)==0)out.print("selected");%>>否</option>
</select>
</td>
<td><%=rs.getLong(15)%></td>
</tr>
<%
}
%>
</table>
</form>
</body>
</html>
<!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=gb2312">
<jsp:useBean id="mdb" class="com.db.DatabaseConn" scope="page"/>
<title></title>
</head>
<body>
<%
String sql="";
String sqlstr="";
String sql2="";
sql=(String)session.getAttribute("sql");
ResultSet rs=mdb.Query(sql);
//学生类型
//sqlstr="select * from xueshengleixing";
//ResultSet rsstr=mdb.Query(sqlstr);
//课程类型
//sql2="select * from kechengleixing";
//ResultSet rs2=mdb.Query(sql2);
//System.out.println(rs2.getString(1));
%>
<form action="" method="post">
<table width="1450" border="1" align="center">
<tr>
<td width="80">课程代码</td>
<td width="80">教师代码</td>
<td width="80">课程名称</td>
<td width="80">课程种类</td>
<td width="100">开课日期</td>
<td width="80">学生类型</td>
<td width="90">学生数目</td>
<td width="90">班级数目</td>
<td width="90">授课学时</td>
<td width="90">试验学时</td>
<td width="90">开 新 课</td>
<td width="90">新 开 课</td>
<td>外语授课</td>
<td width="90">有无助教</td>
<td width="90">工 作 量</td>
</tr>
<%
while(rs.next())
{
%>
<tr>
<td><%=rs.getString(1)%></td>
<td><%=rs.getString(2)%></td>
<td><%=rs.getString(3)%></td>
<td>
<select>
<%//课程种类
sql2="select * from kechengleixing";
ResultSet rs2=mdb.Query(sql2);
while(rs2.next())
{
%>
<option value="<%=rs2.getString(1)%>"
<%
if((rs2.getString(1)!=null && rs2.getString(1).equals(rs.getString(4)))){out.print("selected");}
//System.out.println(rs2.getString(1));
//System.out.println(rs.getString(4));
%>
><%=rs2.getString(1)%></option>
<%
}
%>
</select>
</td>
<td><%=rs.getString(5)%></td>
<td>
<select>
<%//学生类型
sqlstr="select * from xueshengleixing";
ResultSet rsstr=mdb.Query(sqlstr);
while(rsstr.next())
{
%>
<option value="<%rsstr.getString(1)%>"
<%
if((rsstr.getString(1)!=null && rsstr.getString(1).equals(rs.getString(6)))){out.print("selected");}
System.out.println(rsstr.getString(1));
System.out.println(rs.getString(6));
%>
><%=rsstr.getString(1)%></option>
<%
}
%>
</select>
</td>
<td><%=rs.getString(7)%></td>
<td>
<select>
<%//班级数目
for(int i=1;i<=8;i++)
{
%>
<option value="<%=i%>"<%if(i==rs.getInt(8))out.print("selected");%>><%=i%></option>
<%
}
%>
</select>
</td>
<td><%=rs.getString(9)%></td>
<td><%=rs.getString(10)%></td>
<td>
<select>
<option value="1" <%if(rs.getInt(11)==1)out.print("selected");%>>是</option>
<option value="0" <%if(rs.getInt(11)==0)out.print("selected");%>>否</option>
</select>
</td>
<td>
<select>
<option value="1" <%if(rs.getInt(12)==1)out.print("selected");%>>是</option>
<option value="0" <%if(rs.getInt(12)==0)out.print("selected");%>>否</option>
</select>
</td>
<td>
<select>
<option value="1" <%if(rs.getInt(13)==1)out.print("selected");%>>是</option>
<option value="0" <%if(rs.getInt(13)==0)out.print("selected");%>>否</option>
</select>
</td>
<td width="57">
<select>
<option value="1" <%if(rs.getInt(14)==1)out.print("selected");%>>是</option>
<option value="0" <%if(rs.getInt(14)==0)out.print("selected");%>>否</option>
</select>
</td>
<td><%=rs.getLong(15)%></td>
</tr>
<%
}
%>
</table>
</form>
</body>
</html>
解决方案 »
- 刚学servlet,对于eclipse中的目录结构不明白,求前辈解疑!!
- 用Java WebService作为数据查询端(服务器端)用.Net C#作为数据展示端(客户端)数据处理问题
- 连接Mysql出了问题,高手赐教!加急.......
- ajax和取值的问题
- 关于jsp的javabean问题
- 部署问题.............
- jsp中关于hidden应用,为何得到总是空值?
- 关于SSH框架的Spring3和struts2的问题!
- 各位大神 MacbookPro ME865 适合JAVA WEB开发吗?
- 兄弟们给一个JAVA树型结构比较优化的算法吧
- servlet问题 ,form中的action如何写?
- 在JSP中用bean封装常用的功能(实例)
昨天的那个帖子结贴了 分数都给你了!^_^ 不过又有这个新问题出现了!
<option value="<%=rsstr.getString(1)%>" 呵呵,换个好用点的IDE吧。。:)