JSP写入数据库的初级代码.docx
- 文档编号:3025191
- 上传时间:2022-11-17
- 格式:DOCX
- 页数:13
- 大小:16.37KB
JSP写入数据库的初级代码.docx
《JSP写入数据库的初级代码.docx》由会员分享,可在线阅读,更多相关《JSP写入数据库的初级代码.docx(13页珍藏版)》请在冰豆网上搜索。
JSP写入数据库的初级代码
JSP写入数据库的初级代码
最低级代码,写入数据库,完成任务,效率极低
<%@pagecontentType="text/html;charset=GB2312"%>
<%@pagelanguage="java"import="java.io.*"%>
<%@pageerrorPage="errorPage.jsp"%>
<%@pageimport="java.sql.*"%>
<%
Stringgrade=request.getParameter("grade");
Stringbclass=request.getParameter("bclass");
intgraden=Integer.parseInt(grade);
intbclassn=Integer.parseInt(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
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- JSP 写入 数据库 初级 代码