JavaWeb应用实例servlet实现oracle基本增删改查（精）

A．Practising her violin． B．Helping her neighbours． C．Writing her English paper.

12．How does the woman feel about her life? A．Very easy． B．Too busy． C．Too boring

听第9段材料，回答第13至16题。

13．What's the plan about?

A．New production methods and advertisements. B．Costs of advertisements． C．Television commercials．

14．Who has the woman been trying to talk to about the human resources? A．Finance section． B．Personnel and staff． C．Personnel and finance section. 15． String id=request.getParameter(

A．It's not expensive any more to do that39. System.out.println(id; B． String name=request.getParameter(\ C． String grent=request.getParameter(\

16．What will be the result of the investment according to the woman? A．Higher profits, B．

43. //更新SQL Higher quality products．

\ + 段材料，回答第

45. \+grent+\+result+\+id+\;

17 46. // 1 、使用 Class 类加载驱动程序

47. Class.forName(\; 48. // 2、连接数据库

17． conn = DriverManager.getConnection(DBURL, DBUSER, DBPASS;

50. // 3

B．By posting notices around．接口进行实例化操作 C．

51. stmt = conn.createStatement(; 52. What should we pay besides the first month's rent?

A．Water and electricity． if(pd!=0 B．

54. { 55.

C．A security deposit

56. out.println(\

A． out.println(\; 58. out.println(\; C

59. out.print(\更新成功

查看列表 \;

60. out.println(\; 61. out.println( 第二部分：英语知识运用（共两节, 62. } 63. C、

64. out.close(;

65. stmt.close(; ____ of what had happened when the attack took place．

A． } ．

68.

A．application B．assumption C

70. 23．It is generally acknowledged that education shouldn't be ____ purely by examination

71.

A．measured B．confirmed C．classified D．identified

24．The examination was coming, but she couldn't go to sleep easily

74. throws ServletException, IOException

A．crowded B．broke

77. }

settled

78. 79. }

addPage .java，添加数据页面]

[java] view plaincopy

1. package org.lsy.servlet; 2.

3. import java.io.IOException; 4. import java.io.PrintWriter; 5.

6. import javax.servlet.ServletException; 7. import javax.servlet.http.HttpServlet; 8. import javax.servlet.http.HttpServletRequest; 9. import javax.servlet.http.HttpServletResponse; 10.

11. public class AddPage extends HttpServlet 12. { 13.

14. public void doGet(HttpServletRequest request, HttpServletResponse response

15. throws ServletException, IOException 16. {

17. //设置请求和响应的编码 ，不然页面上容易出现乱码 18. request.setCharacterEncoding(\;

19. response.setCharacterEncoding(\; 20. response.setContentType(\; 21. PrintWriter out = response.getWriter(; 22. out.println(\; 23. out.println(\; 24. out.println(\; 25. out.println(\;

26. //输入成绩的表单，提交至add 27. out.print(\; 28. out.print(\姓名： \; 29. out.print(\班级： \; 30. out.print(\成绩： \; 31. out.print(\添加 '> 重置 '>\; 32. out.println(\查看列表\; 33. out.println(\; 34. out.println(\; 35. out.flush(; 36. out.close(; 37. } 38. 39. }

add 接收addpage传来的传，更新数据库

[java] view plaincopy

1. package org.lsy.servlet; 2.

3. import java.io.IOException; 4. import java.io.PrintWriter; 5. import java.sql.Connection; 6. import java.sql.DriverManager; 7. import java.sql.PreparedStatement; 8. import java.sql.ResultSet;