仅用Jsp实现对数据库的增删改查.docx
《仅用Jsp实现对数据库的增删改查.docx》由会员分享,可在线阅读,更多相关《仅用Jsp实现对数据库的增删改查.docx(43页珍藏版)》请在冰豆网上搜索。
仅用Jsp实现对数据库的增删改查
仅用Jsp实现对数据库的增删改查
首先,打开sql*plus,输入用户名(我用的scott)密码(我设置的是tiger)。
先建个表student,
Createtablestudent(
idnumber(30)notnullprimarykey,
namevarchar(50),
agenumber(30),
gendervarchar(30),
majorvarchar(50));
1,打开myeclipse8.5新建一个webproject
2,在projectname中输入合法名字,比如normal
3,新建的normal工程
4,在webRoot目录下添加以下.jsp文件
4.1submit.jsp文件
代码如下:
<%@pagelanguage="java"import="java.util.*"pageEncoding="UTF-8"%>
<%
Stringpath=request.getContextPath();
StringbasePath=request.getScheme()+":
//"+request.getServerName()+":
"+request.getServerPort()+path+"/";
%>
DOCTYPEHTMLPUBLIC"-//W3C//DTDHTML4.01Transitional//EN">
">
输入学生信息界面
--
-->
functionvalidate()
{
varid=document.forms[0].id.value;
varname=document.forms[0].name.value;
varage=document.forms[0].age.value;
varmajor=document.forms[0].major.value;
if(id<=0){
alert("学号不能为空,请输入学号!
");
returnfalse;
}
elseif(name.length<=0){
alert("姓名不能为空,请输入姓名!
");
returnfalse;
}
elseif(age<=0){
alert("请输入合法年龄!
");
returnfalse;
}
elseif(major.length<=0){
alert("专业不能为空,请输入所学专业!
");
returnfalse;
}
else{
returntrue;
}
//document.getElementById("form").submit();
}
学生信息输入
学号:
true}">
姓名:
年龄:
性别:
男
女
专业:
查看已输入信息
4.2insert.jsp文件
<%@pagelanguage="java"import="java.util.*"pageEncoding="UTF-8"%>
<%@pageimport="java.sql.*"%>
<%
Stringpath=request.getContextPath();
StringbasePath=request.getScheme()+":
//"+request.getServerName()+":
"+request.getServerPort()+path+"/";
%>
DOCTYPEHTMLPUBLIC"-//W3C//DTDHTML4.01Transitional//EN">
">
插入学生信息
--
-->
<%
request.setCharacterEncoding("UTF-8");
Stringid=request.getParameter("id");
Stringname=request.getParameter("name");
System.out.println(name);
Stringage=request.getParameter("age");
Stringgender=request.getParameter("gender");
Stringmajor=request.getParameter("major");
Connectionconn=null;
Statementstat=null;
ResultSetrs=null;
Class.forName("oracle.jdbc.driver.OracleDriver");
Stringurl="jdbc:
oracle:
thin:
@localhost:
1521:
orcl";
Stringuser="scott";
Stringpassword="tiger";
conn=DriverManager.getConnection(url,user,password);
stat=conn.createStatement();
rs=stat.executeQuery("insertintostudent(id,name,age,gender,major)values("+id+",'"+name+"',"+age+",'"+gender+"','"+major+"')");
%>
<%
if(rs.next())
{
out.print("
成功输入!
");
}
else{
out.print("
输入失败!
");
}
%>
返回信息输入页面进入信息查询页面
<%
if(rs!
=null)
{
rs.close();
}
if(stat!
=null)
{
stat.close();
}
if(conn!
=null)
{
conn.close();
}
%>
4.3layout.jsp文件
<%@pagelanguage="java"import="java.util.*"pageEncoding="UTF-8"%>
<%@pageimport="java.sql.*"%>
<%
Stringpath=request.getContextPath();
StringbasePath=request.getScheme()+":
//"+request.getServerName()+":
"+request.getServerPort()+path+"/";
%>
DOCTYPEHTMLPUBLIC"-//W3C//DTDHTML4.01Transitional//EN">
">
学生信息
--
-->
<%
response.setCharacterEncoding("UTF-8");
request.setCharacterEncoding("UTF-8");
Stringid=request.getParameter("id");
Stringname=request.getParameter("name");
Stringage=request.getParameter("age");
Stringgender=request.getParameter("gender");
Stringmajor=request.getParameter("major");
Connectionconn=null;
Statementstat=null;
ResultSetrs=null;
Class.forName("oracle.jdbc.driver.OracleDriver");
Stringurl="jdbc:
oracle:
thin:
@localhost:
1521:
orcl";
Stringuser="scott";
Stringpassword="tiger";
conn=DriverManager.getConnection(url,user,password);
stat=conn.createStatement();
//stat.execute("insertintostudent(id,name,age,gender,major)values("+id+",'"+name+"',"+age+",'"+gender+"','"+major+"')");
rs=stat.executeQuery("select*fromstudent");
%>
学生信息
全部学生信息如下
15pt;border:
dashed1pt">
学号 | 姓名 | 年龄 | 性别 | 专业 |
<%
while(rs.next())
{
out.print("
");out.print("
"+rs.getInt("id")+" | ");out.print("
"+rs.getString("name")+" | ");out.print("
"+rs.getInt("age")+" | ");out.print("
"+rs.getString("gender")+" | ");out.print("
"+rs.getString("major")+" | ");%>
id=<%=rs.getInt("id")%>">删除 | id=<%=rs.getInt("id")%>">修改 | <%
out.print("
");
}
%>
按学号查询:
按姓名查询:
按年龄查询:
按性别查询:
按专业查询:
返回信息输入页面
<%
if(rs!
=null)
{
rs.close();
}
if(stat!
=null)
{
stat.close();
}
if(conn!
=null)
{
conn.close();
}
%>
4.4delete.jsp文件
<%@pagelanguage="java"import="java.util.*"pageEncoding="UTF-8"%>
<%@pageimport="java.sql.*"%>
<%
Stringpath=request.getContextPath();
StringbasePath=request.getScheme()+":
//"+request.getServerName()+":
"+request.getServerPort()+path+"/";
%>
DOCTYPEHTMLPUBLIC"-//W3C//DTDHTML4.01Transitional//EN">
">
删除页面
--
-->
<%
request.setCharacterEncoding("UTF-8");
Stringid=request.getParameter("id");
//Stringname=request.getParameter("name");
//Stringage=request.getParameter("age");
//Stringgender=request.getParameter("gender");
//Stringmajor=request.getParameter("major");
Connectionconn=null;
Statementstat=null;
ResultSetrs=null;
Class.forName("oracle.jdbc.driver.OracleDriver");
Stringurl="jdbc:
oracle:
thin:
@localhost:
1521:
orcl";
Stringuser="scott";
Stringpassword="tiger";
conn=DriverManager.getConnection(url,user,password);
stat=conn.createStatement();
rs=stat.executeQuery("deletefromstudentwhereid="+id+"");
if(rs.next())
{
out.print("
删除成功!
");
}
else{
out.print("
删除失败!
");
}
%>
返回信息输入页面返回信息查询页面<%
if(rs!
=null)
{
rs.close();
}
if(stat!
=null)
{
stat.close();
}
if(conn!
=null)
{
conn.close();
}
%>
4.5idselect.jsp文件
<%@pagelanguage="java"import="java.util.*"pageEncoding="UTF-8"%>
<%@pageimport="java.sql.*"%>
<%
Stringpath=request.getContextPath();
StringbasePath=request.getScheme()+":
//"+request.getServerName()+":
"+request.getServerPort()+path+"/";
%>
DOCTYPEHTMLPUBLIC"-//W3C//DTDHTML4.01Transitional//EN">
">
按学号条件查询