《数据库原理及应用》课件第14章.ppt

tdwidth=85class=STYLE1divalign=leftclass=STYLE1nbsp;labelinputname=studentIdtype=hiddenid=textfield2size=10value=%=studentId%/inputname=cnotype=textid=textfield2

size=10value=%=rs.getString(1)%//label/div/td

tdwidth=76class=STYLE2divalign=rightclass=STYLE1课程名：/div/td

tdwidth=171class=STYLE1divalign=leftclass=STYLE1nbsp;inputname=cnametype=textid=textfield3size=20value=%=rs.getString(2)%//div/td

tdwidth=74class=STYLE2divalign=rightclass=STYLE1成绩：/div/td

tdwidth=154class=STYLE1divalign=leftclass=STYLE1inputname=resulttype=textid=textfield4size=15value=%=rs.getString(3)%//div/td

tdwidth=154class=STYLE1divalign=centerclass=STYLE1labelinputtype=submitname=button2id=button2value=修改//label/div/td

/tr/table/form

%}}%

/body/html

tUpdateAction.jsp程序清单：

%@pagelanguage=javaimport=java.util.*,java.sql.*pageEncoding=ISO-8859-1%

%Stringpath=request.getContextPath();

StringbasePath=request.getScheme()+://+request.getServerName()+:+request.getServerPort()+path+/;%

!DOCTYPEHTMLPUBLIC-//W3C//DTDHTML4.01Transitional//EN

html

head

basehref=%=basePath%

titleMyJSPtUpdateAction.jspstartingpage/title

metahttp-equiv=pragmacontent=no-cache

metahttp-equiv=cache-controlcontent=no-cache

metahttp-equiv=expirescontent=0

metahttp-equiv=keywordscontent=keyword1,keyword2,keyword3

metahttp-equiv=descriptioncontent=Thisismypage

!--

linkrel=stylesheettype=text/csshref=styles.css

--

/head

body

%Stringsno=request.getParameter(studentId);

Stringcno=request.getParameter(cno).trim();

Stringresult=request.getParameter(result);

if(sno!=nullsno.length()0){sno.trim();

//intresult=Integer.parseInt(request.getParameter(result));

Stringsql=updateSCsetresult=+result+wheresno=+sno+andcno=+cno+;

System.out.println(sql);

Connectioncon=null;

Statementstmt=null;ResultSetrs=null;

try{Class.forName(