数据库编程

开发平台：
Visual C++

index.aspx：源码内容
							﻿<%@ Page Language="C#"  MasterPageFile = "../MasterPage2.master" AutoEventWireup="true" CodeFile="index.aspx.cs" Inherits="student_index"  Title="学生首页"%>
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" runat="server">
    <script type="text/javascript" src="../js/imgplayer1.js"></script>
    
    <div style="margin-top:20px;height:350px;">
         <div style="float:left;width:200px; height:300px;">
             <div id="ImgBlk">
					<div id="ss_img_div"><a href="javascript:ss.hotlink();"><img id="ss_img" src="../image/pic_1.jpg" alt="华东师范大学软件学院工程硕士管理系统""/></a></div>
					<div id="ImgNum">
						<ul>
							<li class="itemOff" id="imbtn0" onclick="ss.goto_slide(0)">1</li>
							<li class="itemOff" id="imbtn1" onclick="ss.goto_slide(1)">2</li>
							<li class="itemOff" id="imbtn2" onclick="ss.goto_slide(2)">3</li>
							<li class="itemOff" id="imbtn3" onclick="ss.goto_slide(3)">4</li>
							<li class="itemOff" id="imbtn4" onclick="ss.goto_slide(4)">5</li>
						</ul>
						<div id="Play" onclick="ss.play(); document.getElementById('Pause').style.display='block'; this.style.display='none';" onmousemove="this.style.color='#c00';" onmouseout="this.style.color='#000';" style="display:none;">自动播放</div>
						<div id="Pause" onclick="ss.pause(); document.getElementById('Play').style.display='block'; this.style.display='none';" onmousemove="this.style.color='#c00';" onmouseout="this.style.color='#000';">暂停播放</div>
					</div>
			</div>
             <div style=" margin-top:20px;height:100px;">
	            <img src="../image/huashixinwen.gif" longdesc="../image/huashixinwen.gif" id="IMG1"/>
		        <li class="STYLE6"><a href="http://www.xgb.ecnu.edu.cn/system/xsglgd_list.asp" target="_blank">规章制度</a></li>
		        <li class="STYLE6"><a href="http://www.xgb.ecnu.edu.cn/system/zxtz_list.asp" target="_blank">通知公告</a></li>
		        <li class="STYLE6"><a href="http://www.xgb.ecnu.edu.cn/system/jzgl_list.asp" target="_blank">奖助信息</a></li>
		        <li class="STYLE6"><a href="http://www.xgb.ecnu.edu.cn/system/bszn_list.asp" target="_blank">办事指南</a></li>
		    </div>  
         </div>
        <div style="float:left;margin-left:15px; width:280px;">
           <div style="float:left;">
              <img src="../image/biaoti_xiushi.gif" width="21" height="21" longdesc="../image/biaoti_xiushi.gif" />
           </div>
		   <div style="float:left;">
			  <span class="STYLE4">导师查询</span>			  
		   </div>
		   <div style="background-image:url(../image/division.JPG);background-repeat:repeat-x; height:2px; width:300px;">
		   </div>
		   <div style="width:300px; height:300px;">
               <asp:GridView ID="GridView1" runat="server" AllowPaging="True" AllowSorting="True" AutoGenerateColumns="False" DataKeyNames="tea_id" DataSourceID="SqlDataSource1">
                   <Columns>
                        <asp:HyperLinkfield DataTextField="tea_name"  HeaderText="导师姓名" SortExpression="tea_name"  DataNavigateUrlFields="tea_id" DataNavigateUrlFormatString = "details.aspx?tea_Id={0}">
                            <ItemStyle  Height="20px" Width="100px" HorizontalAlign="Center" VerticalAlign="Middle" />
                        </asp:HyperLinkfield>
                        <asp:BoundField DataField="tea_toward" HeaderText="研究方向" SortExpression="tea_toward">
                            <ItemStyle HorizontalAlign="Center" VerticalAlign="Middle" Width="200px" />
                        </asp:BoundField>
                   </Columns>
               </asp:GridView>
               <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ConnectionStrings:ecnuprosysConnectionString%>"
                   SelectCommand="SELECT tea_id, tea_name, tea_toward FROM tea_table WHERE (tea_maxstu > tea_nowstu) GROUP BY tea_toward, tea_id, tea_name">
               </asp:SqlDataSource>
          </div>
	   </div>
	   <div style="float:right;width:180px; height:180px;">
		    <img src="../image/shangcaigk.gif" longdesc="../image/shangcaigk.gif" />
			<li class="STYLE6"><asp:HyperLink ID="HyperLink1" runat="server" >科研实践能力考核表</asp:HyperLink>&nbsp; &nbsp;&nbsp;<asp:Label ID="Label1" runat="server" Text="未提交"></asp:Label></li>
			<li class="STYLE6"><asp:HyperLink ID="HyperLink2" runat="server" >企业导师表</asp:HyperLink>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;<asp:Label ID="Label2" runat="server" Text="未提交"></asp:Label></li>
			<li class="STYLE6"><asp:HyperLink ID="HyperLink3" runat="server" >选报导师表</asp:HyperLink>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;<asp:Label ID="Label3" runat="server" Text="未提交"></asp:Label></li>
			<li class="STYLE6"><asp:HyperLink ID="HyperLink4" runat="server" >开题报告</asp:HyperLink>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;<asp:Label ID="Label4" runat="server" Text="未提交"></asp:Label></li>
			<li class="STYLE6"><asp:HyperLink ID="HyperLink5" runat="server" >我的论文</asp:HyperLink>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;<asp:Label ID="Label5" runat="server" Text="未提交"></asp:Label></li>
	   </div>
	   <div style="float:right; width:180px; height:150px;">
	     <img src="../image/gonggongfw.gif" longdesc="../image/gonggongfw.gif" />
		 <li class="STYLE6"><a href="arrangement.aspx" target="_parent">答辩安排</a></li>
	   </div>   
    </div>  
    
        <script type="text/javascript" language="javascript">
	ss = new slideshow("ss");
	ss.prefetch = 1;
	ss.sizelmt = true;
	ss.repeat = true;
	s = new slide();
	
	s.src = "../image/pic_1.jpg";
	//s.link = "third.aspx?id=2";
	ss.add_slide(s);
	s = new slide();
	s.src = "../image/pic_2.jpg";
	//s.link = "third.aspx?id=1";
	ss.add_slide(s);
	s = new slide();
	s.src = "../image/pic_3.jpg";
	//s.link = "third.aspx?id=3";
	ss.add_slide(s);
	s = new slide();
	s.src = "../image/pic_4.jpg";
	//s.link = "third.aspx?id=41";
	ss.add_slide(s);
	s = new slide();
	s.src = "../image/pic_5.jpg";
	//s.link = "third.aspx?id=40";
	ss.add_slide(s);
						
	for (var i=0; i < ss.slides.length; i++) {
	s = ss.slides[i];
	s.target = "_blank";
	}
    </script>
            
    <script type="text/javascript">
    ss.pre_update_hook = function() {
	sid = ss.current;
	linkurl = ss.slides[sid].link;
	tempid = parseInt(sid) + 1;
	for (var i = 0;i < ss.slides.length;i++){
		document.getElementById("imbtn"+i).className = "itemOff";
	}
		document.getElementById("imbtn"+sid).className = "itemOn";
	return;
	}
	if (document.images) {
	ss.image = document.images.ss_img;
	ss.update();
	ss.play();
    }
    </script>
    
</asp:Content>

						