直接上代码!
请选择课程:<select id="course" name="course" onChange="getSelectCourse();">
<option value="0" selected="selected">请选择课程</option>
<%
//连接数据库,查询该老师教授的所有课程信息,然后循环
Class.forName("com.mysql.jdbc.Driver");
String strConn="jdbc:mysql://localhost/qtech";
String strUser="root";
String strPassword="";
Connection conn=DriverManager.getConnection(strConn,strUser,strPassword);
Statement stat=conn.createStatement();
//String strSql="SELECT coursename FROM tb_course,tb_cs WHERE teacno='"+session.getAttribute("user").toString()+"' and tb_cs.courseno=tb_course.courseno";
String strSql="SELECT coursename FROM tb_course,tb_cs WHERE teacno='001' and tb_cs.courseno=tb_course.courseno";
ResultSet result=stat.executeQuery(strSql);
while(result.next())
{
out.print("<option value="+result.getString(1)+">"+result.getString(1)+"</option>");
}
%>
</select>