81,091
社区成员
发帖
与我相关
我的任务
分享
1.<?xml version="1.0" encoding="UTF-8"?>
2.<beans
3. xmlns="http://www.springframework.org/schema/beans"
4. xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
5. xmlns:p="http://www.springframework.org/schema/p"
6. xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-2.5.xsd">
7.
8.
9. <bean id="dataSource"
10. class="org.apache.commons.dbcp.BasicDataSource">
11. <property name="driverClassName"
12. value="oracle.jdbc.driver.OracleDriver">
13. </property>
14. <property name="url"
15. value="jdbc:oracle:thin:@42.1.37.219:1521:ORCL">
16. </property>
17. <property name="username" value="picc_bbs"></property>
18. <property name="password" value="xm1234"></property>
19. </bean>
20. <bean id="sessionFactory"
21. class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
22. <property name="dataSource">
23. <ref bean="dataSource" />
24. </property>
25. <property name="hibernateProperties">
26. <props>
27. <prop key="hibernate.dialect">
28. org.hibernate.dialect.Oracle9Dialect
29. </prop>
30. </props>
31. </property>
32. <property name="mappingResources">
33. <list>
34. <value>pojo/Bbsblock.hbm.xml</value></list>
35. </property></bean>
36.
37.
38. <bean id="blockDao" class="dao.BlockDao" abstract="false"
39. lazy-init="default" autowire="default" dependency-check="default">
40. <property name="sessionFactory">
41. <ref local="sessionFactory" />
42. </property>
43. </bean>
1.<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
2.<%@ page import="pojo.Bbsblock"%>
3.<%@page import="dao.BlockDao"%>
4.<%@page
5. import="org.springframework.web.context.support.WebApplicationContextUtils"%>
6.<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
7.<html>
8. <head>
9. <title>查询</title>
10. <link rel="stylesheet" type="text/css" href="${ctx}/style/style.css">
11.
12. </head>
13. <style>
14.ul,li {
15. list-style: none;
16. float: left;
17. margin: 0;
18. padding: 0;
19.}
20.
21.ul {
22. width: 650px;
23. height: 30px;
24.}
25.
26.li {
27. width: 130px;
28. border: 1px solid white;
29. text-align: left;
30. height: 30px;
31.}
32.
33.li.lititle {
34. border: 0;
35. height: 30px;
36.}
37.
38.li.qtitle {
39. text-align: center;
40. height: 30px;
41.}
42.</style>
43.
44. <body>
45. <ul>
46. <li class="lititle">
47. <a href="block.jsp?temp=0">全部客户</a>
48. </li>
49. <li class="lititle">
50. <input type="text" id="pname" value="输入姓名查询"
51. onblur="if(this.value.length >0 && this.value != '输入姓名查询'){}else{this.value='输入姓名查询'}"
52. onfocus="if(this.value=='输入姓名查询'){this.value = ''}" />
53. </li>
54. <li class="lititle">
55. <input type="button" value="查询" onclick="queryByName()"/>
56. </li>
57. </ul>
58. <br>
59. <br>
60. <center>
61. <ul>
62. <li class="qtitle">
63. 姓名
64. </li>
65. <li class="qtitle">
66. 用户代码
67. </li>
68. <li class="qtitle">
69. 版块名称
70. </li>
71. <li class="qtitle">
72. 注册时间
73. </li>
74. <li class="qtitle">
75. 删除
76. </li>
77. </ul>
78. <%
79. request.setCharacterEncoding("utf-8");
80. response.setCharacterEncoding("utf-8");
81. String stemp = request.getParameter("temp");
82. String userName = request.getParameter("userName");
83. int temp = 0;
84. if(stemp != null){
85. temp = Integer.parseInt(stemp);
86. }
87. //List<Person> allStudent = new ArrayList<Person>();
88. String pageNumber = request.getParameter("pageNumber");
89. int pageInt = 1;
90. if(pageNumber == null || "".equals(pageNumber.trim())){
91. pageInt = 1;
92. }else{
93. try{
94. pageInt = Integer.parseInt(pageNumber);
95. }catch(Exception e){
96. pageInt = 1;
97. }
98.
99. if(pageInt < 1){
100. pageInt = 1;
101. }
102. }
103. int pageSize = 5;//定义一页的显示数
104. int stuAmount = 0;//定义总记录数
105. BlockDao blockDao = (BlockDao)WebApplicationContextUtils.getWebApplicationContext(this.getServletContext()).getBean("blockDao");
106. if(temp == 0){
107. stuAmount = blockDao.blockAmount();//获取总记录数
108. }else{
109. stuAmount = blockDao.blockByNameAmount(userName);
110. }
111.
112. int totalPage = 1;//定义总页数totalPage
113. totalPage = (stuAmount%pageSize==0)?(stuAmount/pageSize):((stuAmount/pageSize)+1);
114. //如果要查询的page值大于totalPage,就将page值设置为totalPage
115. if(pageInt > totalPage){
116. pageInt = totalPage;
117. }
118.
119.
120. try{
121. List<Bbsblock> list = new ArrayList<Bbsblock>();
122. if(temp == 0){
123. //list = BlockDao.allBlock();
124. list = BlockDao.allBlocks(pageInt,pageSize);
125. }else{
126. //list = BlockDao.queryBlockByName(blockName);
127. list = BlockDao.queryBlockByName(pageInt,pageSize,userName);
128. }
129.
130. Iterator<Bbsblock> iter = list.iterator();
131. Bbsblock block = null;
132. while(iter.hasNext()){
133. block = new Bbsblock();
134. block =(Bbsblock) iter.next();
135. %>
weblogic.servlet.jsp.CompilationException: Failed to compile JSP /theBlock.jsp
theBlock.jsp:47:35: No match was found for method getBean(java.lang.String) in type <error>.
BlockDao blockDao = (BlockDao)WebApplicationContextUtils.getWebApplicationContext(this.getServletContext()).getBean("blockDao");
^-----------------------------------------------------------------------------------------------^
theBlock.jsp:47:87: No match was found for method getServletContext() in type jsp_servlet.__theblock.
BlockDao blockDao = (BlockDao)WebApplicationContextUtils.getWebApplicationContext(this.getServletContext()).getBean("blockDao");
^----------------------^
theBlock.jsp:51:77: This method cannot be accessed from a static context.
<form name="name1" method="post" action="servlet.UpdateBlock?blockId=<%=Bbsblock.getBlockid()%>">