[IBATIS] prb de récuperation de données

Version imprimable

Salut,
j ai un problème qd je veux afficher des données de ma DB.

Ma JSP:

Code:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
<%@ page language="java" pageEncoding="ISO-8859-1" contentType="text/html;charset=ISO-8859-1"%>
<%@ taglib uri="/WEB-INF/c.tld" prefix="c" %>
<%@ taglib uri="/WEB-INF/taglibs-datetime.tld" prefix="dt" %>
<%@ page isELIgnored="false" %>
 
<html>
	<head>
		<title>Liste</title>
	</head>
	<body>
 
		<h2>Liste</h2>
		<table border="1">
			<tr>
 
				<th>Domaine</th>
 
				<th></th>
			</tr>
			<c:forEach var="domaine" items="${domaines}">
				<tr>
					<td><c:out value="${domaine.aiddomaine}"/></td>
 
				</tr>
			</c:forEach>
		</table>
 
	</body>
</html>

Mon controleur

Code:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
package code.web;
 
import java.util.HashMap;
import java.util.Map;
import code.service.IService;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
 
//import org.springframework.web.bind.RequestUtils;
import org.springframework.web.servlet.ModelAndView;
import org.springframework.web.servlet.mvc.Controller;
 
public class Menu1 implements Controller {
	IService service;
 
 
		public IService getService(){
			return service;
		}
		public void setService(IService service){
 
		this.service=service;
	}
		public ModelAndView handleRequest(HttpServletRequest request,
				HttpServletResponse response) throws Exception {
 
			String alogin="sniper";
			Map model = new HashMap();
			model.put("domaines", service.getDomaine(alogin));
 
			return new ModelAndView("menu1", model);
		}
 
 
}

Ma classe DAO:

Code:

1
2
3
4
5
6
7
8
9
10
11
12
13
package code.dao;
 
import java.util.Collection;
 
import org.springframework.orm.ibatis.support.SqlMapClientDaoSupport;
 
public class DaoImplDomaine extends SqlMapClientDaoSupport implements IDao {
	public Collection getDomaine(String alogin){
		return getSqlMapClientTemplate().queryForList("Appartient.getdomaine", new String(alogin) );
 
	}
 
}

Mon fichier XML d IBATIS:

Code:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE sqlMap
 PUBLIC "-//iBATIS.com//DTD SQL Map 2.0//EN" "http://www.ibatis.com/dtd/sql-map-2.dtd">
<sqlMap>
<!-- alias classe [Appartient] -->
 <typeAlias alias="Appartient.classe" type="code.tables.Appartient"/>
 <!-- mapping table [Appartient] - objet [Appartient] -->
 <resultMap id="Appartient.map"
 class="Appartient.classe">
 <result property="alogin" column="a_login" />
 <result property="aiddomaine" column="a_id_domaine" />
 
</resultMap>
 
 <!-- obtenir une personne en particulier -->
<select id="Appartient.getdomaine" resultMap="Appartient.map" >select a_id_domaine FROM appartient WHERE a_login LIKE '%value%'</select> 
 </sqlMap>

Le prb c que qd j éxecute ma jsp il y a que ça qui est afficher

Code:

<th>Domaine</th>

et le résultat de la requette n est pas afficher est ce que qlq un vois le prb.
Merci

10/06/2006, 19h33
Laurent.B

Bien... Et les logs ne disent-ils rien?

voila le contenu du log, mais je vois pas le prb:

Code:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
NFO: Server startup in 15281 ms
 INFO [http-8080-Processor25] - Initializing servlet 'droit'
 INFO [http-8080-Processor25] - FrameworkServlet 'droit': initialization started
 INFO [http-8080-Processor25] - Loading XML bean definitions from ServletContext resource [/WEB-INF/droit-servlet.xml]
 INFO [http-8080-Processor25] - Bean factory for application context [WebApplicationContext for namespace 'droit-servlet']: org.springframework.beans.factory.support.DefaultListableBeanFactory defining beans [org.springframework.web.servlet.handler.SimpleUrlHandlerMapping,menu1Controller,authentification,org.springframework.web.servlet.view.ResourceBundleViewResolver]; parent: org.springframework.beans.factory.support.DefaultListableBeanFactory defining beans [dataSource,sqlMapClient,dao,transactionManager,service]; root of BeanFactory hierarchy
 INFO [http-8080-Processor25] - 4 beans defined in application context [WebApplicationContext for namespace 'droit-servlet']
 INFO [http-8080-Processor25] - Unable to locate MessageSource with name 'messageSource': using default [org.springframework.context.support.DelegatingMessageSource@1ce835b]
 INFO [http-8080-Processor25] - Unable to locate ApplicationEventMulticaster with name 'applicationEventMulticaster': using default [org.springframework.context.event.SimpleApplicationEventMulticaster@11201a1]
 INFO [http-8080-Processor25] - Unable to locate ThemeSource with name 'themeSource': using default [org.springframework.ui.context.support.DelegatingThemeSource@1292d12]
 INFO [http-8080-Processor25] - Pre-instantiating singletons in factory [org.springframework.beans.factory.support.DefaultListableBeanFactory defining beans [org.springframework.web.servlet.handler.SimpleUrlHandlerMapping,menu1Controller,authentification,org.springframework.web.servlet.view.ResourceBundleViewResolver]; parent: org.springframework.beans.factory.support.DefaultListableBeanFactory defining beans [dataSource,sqlMapClient,dao,transactionManager,service]; root of BeanFactory hierarchy]
 INFO [http-8080-Processor25] - Using context class [org.springframework.web.context.support.XmlWebApplicationContext] for servlet 'droit'
 INFO [http-8080-Processor25] - Unable to locate MultipartResolver with name 'multipartResolver': no multipart request handling provided
 INFO [http-8080-Processor25] - Unable to locate LocaleResolver with name 'localeResolver': using default [org.springframework.web.servlet.i18n.AcceptHeaderLocaleResolver@12ab74f]
 INFO [http-8080-Processor25] - Unable to locate ThemeResolver with name 'themeResolver': using default [org.springframework.web.servlet.theme.FixedThemeResolver@10c0ef2]
 INFO [http-8080-Processor25] - No HandlerAdapters found in servlet 'droit': using default
 INFO [http-8080-Processor25] - FrameworkServlet 'droit': initialization completed in 328 ms
 INFO [http-8080-Processor25] - Servlet 'droit' configured successfully
 WARN [http-8080-Processor25] - Use of 'class' property in [org.springframework.beans.factory.support.PropertiesBeanDefinitionReader] is deprecated in favor of '(class)'
 WARN [http-8080-Processor25] - Use of 'class' property in [org.springframework.beans.factory.support.PropertiesBeanDefinitionReader] is deprecated in favor of '(class)'
 INFO [http-8080-Processor25] - 2 beans defined in application context [org.springframework.web.context.support.GenericWebApplicationContext;hashCode=17274753]
 INFO [http-8080-Processor25] - Unable to locate MessageSource with name 'messageSource': using default [org.springframework.context.support.DelegatingMessageSource@b80017]
 INFO [http-8080-Processor25] - Unable to locate ApplicationEventMulticaster with name 'applicationEventMulticaster': using default [org.springframework.context.event.SimpleApplicationEventMulticaster@dec87]
 INFO [http-8080-Processor25] - Unable to locate ThemeSource with name 'themeSource': using default [org.springframework.ui.context.support.DelegatingThemeSource@239525]
 INFO [http-8080-Processor25] - Pre-instantiating singletons in factory [org.springframework.beans.factory.support.DefaultListableBeanFactory defining beans [menu1,login]; parent: org.springframework.beans.factory.support.DefaultListableBeanFactory defining beans [org.springframework.web.servlet.handler.SimpleUrlHandlerMapping,menu1Controller,authentification,org.springframework.web.servlet.view.ResourceBundleViewResolver]; parent: org.springframework.beans.factory.support.DefaultListableBeanFactory defining beans [dataSource,sqlMapClient,dao,transactionManager,service]; root of BeanFactory hierarchy]
 INFO [http-8080-Processor25] - JDBC 3.0 Savepoint class is available

ma table est bien éxistante la voila:

Code:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
mysql> select * from appartient;
+---------+--------------+
| a_login | a_id_domaine |
+---------+--------------+
| sniper  | forage       |
| sniper  | labo         |
+---------+--------------+
2 rows in set (0.00 sec)
mysql> select * from appartient where a_login="sniper";
+---------+--------------+
| a_login | a_id_domaine |
+---------+--------------+
| sniper  | forage       |
| sniper  | labo         |
+---------+--------------+
2 rows in set (0.00 sec)
 
mysql> select * from appartient where a_login="sn";
Empty set (0.00 sec)

qd je cherche un 'a_login' inéxistant ça retourn une page vide donc c comme si j ai tjr un empty set avec mon code!!
est ce que qlq un peut me dir si lui semble que mon code n est pas corrécte car je vois vraiment pas le prb.
merci8O

Code:

1 2 3 4  <select id="Appartient.getdomaine" resultMap="Appartient.map" >select a_id_domaine FROM appartient WHERE a_login LIKE '%value%'</select> </sqlMap>
Es-tu sûr que ta requête soit bien paramétrée? Essaye de remplacer '%value%' par #value#

qd je remplace '%value%' par '%sniper%' ça marche j ai mon résultat afficher par ma jsp.

est ce que quelqu un peux me dir si la classe si dessou est correcte car je voix pas d autre chose, je crois que le parametre '%value%' ne récupère pas la valeur passer ds cette classe.
Code:

1 2 3 4 5 6 7 8 9 10 11 12 13 package code.dao; import java.util.Collection; import org.springframework.orm.ibatis.support.SqlMapClientDaoSupport; public class DaoImplDomaine extends SqlMapClientDaoSupport implements IDao { public Collection getDomaine(String alogin){ return getSqlMapClientTemplate().queryForList("Appartient.getdomaine", new String(alogin) ); } }
merci

12/06/2006, 20h52
iftolotfi

en faite il faut mettre
<select id="Appartient.getdomaine" resultMap="Appartient.map" >select a_id_domaine FROM appartient WHERE a_login LIKE #value#</select>