jsp实现连接数据库分页浏览增删改查等功能精Word文件下载.docx

1、String oracledriver=oracle.jdbc.driver.OracleDriver;String oracleUrl=jdbc:oracle:thin:localhost:1521:ORACLEString username=scottString password=tigerConnection con;Class.forName（oracledriver;con=DriverManager.getConnection（oracleUrl,username,password;int intPageSize;int intRowCount;int intPageCount;

2、int intPage;String strPage;int i;intPageSize = 10;strPage = request.getParameter（pageif（strPage=null intPage =1;elseintPage = java.lang.Integer.parseInt（strPage;if（intPageintPageCountintPage =intPageCount;if（intPageCount0rs.absolute（intPage-1*intPageSize+1;i = 0;while（i %rs.next（;i+;工号姓名性别工龄工资%=rs.g

3、etString（idnamesexworkyearsal第页 共页if（intPage 下一页1上一页rs.close（;stmt.close（;con.close（;Input.jsp代码如下:提交取消Inputcheck.jsp 代码如下：已添加员工信息String empID = request.getParameter（empIDbyte b=empID.getBytes（ISO-8859-1empID = new String（b,String empName = request.getParameter（empNamebyte b1=empName.getBytes（empNam

4、e = new String（b1,String empSex = request.getParameter（empSexbyte b2=empSex.getBytes（empSex = new String（b2,String empWorkyear= request.getParameter（empWorkyearbyte b3=empWorkyear.getBytes（empWorkyear = new String（b3,String empSal = request.getParameter（empSalbyte b4=empSal.getBytes（empSal = new Str

5、ing（b4,Connection con=DriverManager.getConnection（oracleUrl,username,password;Statement stmt=con.createStatement（;String sql=insert into worker values（ +empID +,+empName+empSex+,+empWorkyear+empSal+ stmt.executeUpdate（sql;已删除员工信息String oracledriver1=String oracleUrl1=String username1=String password

6、1=Class.forName（oracledriver1;Connection con1=DriverManager.getConnection（oracleUrl1,username1,password1;Statement stmt1=con1.createStatement（;String sql1=delete from worker where empName=韩信stmt1.executeUpdate（sql1;stmt1.close（;con1.close（;已更改员工信息String oracledriver2=String oracleUrl2=String usernam

7、e2=String password2=Class.forName（oracledriver2;Connection con2=DriverManager.getConnection（oracleUrl2,username2,password2;Statement stmt2=con2.createStatement（;String sql2=update worker set empName=李莉莉 where empName=Kababastmt2.executeUpdate（sql2;stmt2.close（;con2.close（;经过以上操作后，Worker表如下：String or

8、acledriver3=String oracleUrl3=String username3=String password3=Class.forName（oracledriver3;Connection con3=DriverManager.getConnection（oracleUrl3,username3,password3;Statement stmt3=con3.createStatement（;String sql3=Select * from workerResultSet rs=stmt3.executeQuery（sql3;while（rs.next（ rs.close（;stmt3.close（;con3.close（;编号