JSP写入数据库的初级代码Word文档格式.docx

JSP写入数据库的初级代码Word文档格式.docx

《JSP写入数据库的初级代码Word文档格式.docx》由会员分享，可在线阅读，更多相关《JSP写入数据库的初级代码Word文档格式.docx（13页珍藏版）》请在冰豆网上搜索。

/title>

linkrel=stylesheethref="

style.css"

type="

text/css"

>

/head>

bodybgcolor=pink>

CENTER>

%

Stringgrade=request.getParameter（"

grade"

）;

Stringbclass=request.getParameter（"

bclass"

intgraden=Integer.parseInt（grade）;

intbclassn=Integer.parseInt（bclass）;

<

hr>

写入数据库的数据；

fontcolor=red>

高<

%=grade%>

年级<

%=bclass%>

班<

/font>

各位老师的评价信息:

Stringsubject1=request.getParameter（"

subject1"

Stringname1=newString（request.getParameter（"

name1"

）.getBytes（"

ISO8859_1"

））;

Stringde1=request.getParameter（"

de1"

Stringneng1=request.getParameter（"

neng1"

Stringqin1=request.getParameter（"

qin1"

Stringji1=request.getParameter（"

ji1"

Stringjy1=request.getParameter（"

jy1"

byte[]messageTextTemp=request.getParameter（"

Stringresume=newString（messageTextTemp）;

Stringjys1=newString（resume.trim（））;

out.println（name1）;

out.println（subject1）;

out.println（de1）;

out.println（neng1）;

out.println（qin1）;

out.println（ji1）;

out.println（jys1）;

intsubjectn=Integer.parseInt（subject1）;

intden=Integer.parseInt（de1）;

intnengn=Integer.parseInt（neng1）;

intqinn=Integer.parseInt（qin1）;

intjin=Integer.parseInt（ji1）;

Class.forName（"

sun.jdbc.odbc.JdbcOdbcDriver"

//载入驱动程式类别

Connectioncon=DriverManager.getConnection（"

jdbc:

odbc:

dcpj"

//建立数据库连线

//建立Statement变量,并设定记录指标类型为可前後移动

Statementstmt=con.createStatement（）;

//建立新增数据至数据库的SQL语句

//StringstrSQL="

insertintodcpj_data（teacher_name）Values（'

"

+name+"

'

）"

;

insertintodcpj_data（de,neng,qin,ji）Values（"

+de2+"

"

+neng2+"

+qin2+"

+ji2+"

insertintodcpj_data（teacher_name,grade,teacher_class）Values（"

+grade2+"

+bclass2+"

insertintodcpj_data（grade,teacher_class,subject,de,neng,qin,ji）Values（"

+subject+"

insertintodcpj_data（teacher_name,grade,teacher_class,subject,de,neng,qin,ji）Values（'

+"

StringstrSQL="

insertintodcpj_data（teacher_name,grade,teacher_class,subject,de,neng,qin,ji,jy）Values（'

+name1+"

+graden+"

+bclassn+"

+subjectn+"

+den+"

+nengn+"

+qinn+"

+jin+"

+jys1+"

stmt.executeUpdate（strSQL）;

//利用SQL语句将数据新增至数据库

stmt.close（）;

//关闭Statement对象

con.close（）;

//关闭Connection对象

%>

Stringsubject2=request.getParameter（"

subject2"

Stringname2=newString（request.getParameter（"

name2"

Stringde2=request.getParameter（"

de2"

Stringneng2=request.getParameter（"

neng2"

Stringqin2=request.getParameter（"

qin2"

Stringji2=request.getParameter（"

ji2"

Stringjy2=request.getParameter（"

jy2"

byte[]messageTextTemp2=request.getParameter（"

Stringresume2=newString（messageTextTemp2）;

Stringjys2=newString（resume.trim（））;

out.println（name2）;

out.println（subject2）;

out.println（de2）;

out.println（neng2）;

out.println（qin2）;

out.println（ji2）;

out.println（jys2）;

subjectn=Integer.parseInt（subject2）;

den=Integer.parseInt（de2）;

nengn=Integer.parseInt（neng2）;

qinn=Integer.parseInt（qin2）;

jin=Integer.parseInt（ji2）;

Class.forName（"

con=DriverManager.getConnection（"

stmt=con.createStatement（）;

strSQL="

+name2+"

+jys2+"

Stringsubject3=request.getParameter（"

subject3"

Stringname3=newString（request.getParameter（"

name3"

Stringde3=request.getParameter（"

de3"

Stringneng3=request.getParameter（"

neng3"

Stringqin3=request.getParameter（"

qin3"

Stringji3=request.getParameter（"

ji3"

Stringjy3=request.getParameter（"

jy3"

byte[]messageTextTemp3=request.getParameter（"

Stringresume3=newString（messageTextTemp3）;

Stringjys3=newString（resume.trim（））;

out.println（name3）;

out.println（subject3）;

out.println（de3）;

out.println（neng3）;

out.println（qin3）;

out.println（ji3）;

out.println（jys3）;

subjectn=Integer.parseInt（subject3）;

den=Integer.parseInt（de3）;

nengn=Integer.parseInt（neng3）;

qinn=Integer.parseInt（qin3）;

jin=Integer.parseInt（ji3）;

con