jsp实现连接数据库分页浏览增删改查等功能精.docx
《jsp实现连接数据库分页浏览增删改查等功能精.docx》由会员分享,可在线阅读,更多相关《jsp实现连接数据库分页浏览增删改查等功能精.docx(8页珍藏版)》请在冰点文库上搜索。
jsp实现连接数据库分页浏览增删改查等功能精
一利用jsp实现Oracle数据库中表格的分页浏览:
二在Oracle数据库中建立表格,包含员工的工号、姓名、性别、工龄、工资等字段,并实现增删改查操作。
(1)所建的worker表格如下:
(2)Input.jsp运行结果如下:
(3)Inputcheck.jsp运行结果如下:
Pagebreak.jsp代码如下:
<%@pagecontentType="text/html"pageEncoding="UTF-8"import="java.sql.*"%>
分页显示记录内容
<%
Stringoracledriver="oracle.jdbc.driver.OracleDriver";
StringoracleUrl="jdbc:
oracle:
thin:
@localhost:
1521:
ORACLE";
Stringusername="scott";
Stringpassword="tiger";
Connectioncon;
Class.forName(oracledriver;
con=DriverManager.getConnection(oracleUrl,username,password;
intintPageSize;
intintRowCount;
intintPageCount;
intintPage;
StringstrPage;
inti;
intPageSize=10;
strPage=request.getParameter("page";
if(strPage==null{
intPage=1;
}else{
intPage=java.lang.Integer.parseInt(strPage;
if(intPage<1intPage=1;
}
Statementstmt=con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY;
Stringsql="select*fromworker";
ResultSetrs=stmt.executeQuery(sql;
rs.last(;
intRowCount=rs.getRow(;
intPageCount=(intRowCount+intPageSize-1/intPageSize;
if(intPage>intPageCount
intPage=intPageCount;
if(intPageCount>0{
rs.absolute((intPage-1*intPageSize+1;
i=0;
while(i
<%
rs.next(;
i++;
}
}
%>
工号
姓名
性别
工龄
工资
<%=rs.getString("id"%>
<%=rs.getString("name"%>
<%=rs.getString("sex"%>
<%=rs.getString("workyear"%>
<%=rs.getString("sal"%>
第<%=intPage%>页共<%=intPageCount%>页
<%
if(intPage
%>
下一页
<%
}
if(intPage>1{
%>
上一页
<%
}
rs.close(;
stmt.close(;
con.close(;
%>
Input.jsp代码如下:
<%@pagecontentType="text/html"pageEncoding="UTF-8"%>
工号
姓名
性别
工龄
工资
提交">
取消">
Inputcheck.jsp代码如下:
<%@pagecontentType="text/html"pageEncoding="UTF-8"import="java.sql.*"%>
已添加员工信息
<%
StringempID=request.getParameter("empID";
byte[]b=empID.getBytes("ISO-8859-1";
empID=newString(b,"UTF-8";
StringempName=request.getParameter("empName";
byte[]b1=empName.getBytes("ISO-8859-1";
empName=newString(b1,"UTF-8";
StringempSex=request.getParameter("empSex";
byte[]b2=empSex.getBytes("ISO-8859-1";
empSex=newString(b2,"UTF-8";
StringempWorkyear=request.getParameter("empWorkyear";
byte[]b3=empWorkyear.getBytes("ISO-8859-1";
empWorkyear=newString(b3,"UTF-8";
StringempSal=request.getParameter("empSal";
byte[]b4=empSal.getBytes("ISO-8859-1";
empSal=newString(b4,"UTF-8";
Stringoracledriver="oracle.jdbc.driver.OracleDriver";
StringoracleUrl="jdbc:
oracle:
thin:
@localhost:
1521:
ORACLE";
Stringusername="scott";
Stringpassword="tiger";
Class.forName(oracledriver;
Connectioncon=DriverManager.getConnection(oracleUrl,username,password;
Statementstmt=con.createStatement(;
Stringsql="insertintoworkervalues('"+empID+"','"+empName+"','"+empSex+"',"+empWorkyear+","+empSal+"";
stmt.executeUpdate(sql;
stmt.close(;
con.close(;
%>
已删除员工信息
<%
Stringoracledriver1="oracle.jdbc.driver.OracleDriver";
StringoracleUrl1="jdbc:
oracle:
thin:
@localhost:
1521:
ORACLE";
Stringusername1="scott";
Stringpassword1="tiger";
Class.forName(oracledriver1;
Connectioncon1=DriverManager.getConnection(oracleUrl1,username1,password1;
Statementstmt1=con1.createStatement(;
Stringsql1="deletefromworkerwhereempName='韩信'";
stmt1.executeUpdate(sql1;
stmt1.close(;
con1.close(;
%>
已更改员工信息
<%
Stringoracledriver2="oracle.jdbc.driver.OracleDriver";
StringoracleUrl2="jdbc:
oracle:
thin:
@localhost:
1521:
ORACLE";
Stringusername2="scott";
Stringpassword2="tiger";
Class.forName(oracledriver2;
Connectioncon2=DriverManager.getConnection(oracleUrl2,username2,password2;
Statementstmt2=con2.createStatement(;
Stringsql2="updateworkersetempName='李莉莉'whereempName='Kababa'";
stmt2.executeUpdate(sql2;
stmt2.close(;
con2.close(;
%>
经过以上操作后,Worker表如下:
<%
Stringoracledriver3="oracle.jdbc.driver.OracleDriver";
StringoracleUrl3="jdbc:
oracle:
thin:
@localhost:
1521:
ORACLE";
Stringusername3="scott";
Stringpassword3="tiger";
Class.forName(oracledriver3;
Connectioncon3=DriverManager.getConnection(oracleUrl3,username3,password3;
Statementstmt3=con3.createStatement(;
Stringsql3="Select*fromworker";
ResultSetrs=stmt3.executeQuery(sql3;
while(rs.next({
%>
<%
}rs.close(;
stmt3.close(;
con3.close(;
%>
编号
姓名
性别
工龄
工资
<%=rs.getString("empID"%>
<%=rs.getString("empName"%>
<%=rs.getString("empSex"%>
<%=rs.getString("empWorkyear"%>
<%=rs.getString("empSal"%>