JSP写入数据库的初级代码.docx

<%

Stringgrade=request.getParameter（"grade"）;

Stringbclass=request.getParameter（"bclass"）;

intgraden=Integer.parseInt（grade）;

intbclassn=Integer.parseInt（bclass）;

%>

写入数据库的数据；

高<%=grade%>年级<%=bclass%>班各位老师的评价信息:

<%

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（"jy1"）.getBytes（"ISO8859_1"）;

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+"'）";

//StringstrSQL="insertintodcpj_data（de,neng,qin,ji）Values（"+de2+","+neng2+","+qin2+","+ji2+"）";

//StringstrSQL="insertintodcpj_data（teacher_name,grade,teacher_class）Values（"+grade2+","+bclass2+"）";

//StringstrSQL="insertintodcpj_data（grade,teacher_class,subject,de,neng,qin,ji）Values（"+grade2+","+bclass2+","+subject+","+de2+","+neng2+","+qin2+","+ji2+"）";

//StringstrSQL="insertintodcpj_data（teacher_name,grade,teacher_class,subject,de,neng,qin,ji）Values（'"+name+"'"+","+grade2+","+bclass2+","+subject+","+de2+","+neng2+","+qin2+","+ji2+"）";

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"）.getBytes（"ISO8859_1"））;

Stringde2=request.getParameter（"de2"）;

Stringneng2=request.getParameter（"neng2"）;

Stringqin2=request.getParameter（"qin2"）;

Stringji2=request.getParameter（"ji2"）;

Stringjy2=request.getParameter（"jy2"）;

byte[]messageTextTemp2=request.getParameter（"jy2"）.getBytes（"ISO8859_1"）;

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（"sun.jdbc.odbc.JdbcOdbcDriver"）;//载入驱动程式类别

con=DriverManager.getConnection（"jdbc:

odbc:

dcpj"）;//建立数据库连线

stmt=con.createStatement（）;

strSQL="insertintodcpj_data（teacher_name,grade,teacher_class,subject,de,neng,qin,ji,jy）Values（'"+name2+"'"+","+graden+","+bclassn+","+subjectn+","+den+","+nengn+","+qinn+","+jin+","+"'"+jys2+"'）";

stmt.executeUpdate（strSQL）;//利用SQL语句将数据新增至数据库

stmt.close（）;//关闭Statement对象

con.close（）;//关闭Connection对象

%>

<%

Stringsubject3=request.getParameter（"subject3"）;

Stringname3=newString（request.getParameter（"name3"）.getBytes（"ISO8859_1"））;

Stringde3=request.getParameter（"de3"）;

Stringneng3=request.getParameter（"neng3"）;

Stringqin3=request.getParameter（"qin3"）;

Stringji3=request.getParameter（"ji3"）;

Stringjy3=request.getParameter（"jy3"）;

byte[]messageTextTemp3=request.getParameter（"jy3"）.getBytes（"ISO8859_1"）;

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）;

Class.forName（"sun.jdbc.odbc.JdbcOdbcDriver"）;//载入驱动程式类别

con