Advertisement
Guest User

Untitled

a guest
Feb 15th, 2017
172
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 9.74 KB | None | 0 0
  1. <context:component-scan base-package="com.tricas.controllers" />
  2. <mvc:annotation-driven />
  3.  
  4. <context:annotation-config />
  5. <context:component-scan base-package="com" />
  6.  
  7. <bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
  8. <property name="prefix">
  9. <value>/WEB-INF/pages/</value>
  10. </property>
  11. <property name="suffix">
  12. <value>.jsp</value>
  13. </property>
  14. </bean>
  15.  
  16. <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">
  17. <property name="driverClassName" value="com.mysql.jdbc.Driver" />
  18. <property name="url" value="jdbc:mysql://localhost:3306/cobranzas" />
  19. <property name="username" value="root" />
  20. <property name="password" value="12345" />
  21. </bean>
  22.  
  23. <bean id="sessionFactory"
  24. class="org.springframework.orm.hibernate4.LocalSessionFactoryBean">
  25. <property name="dataSource" ref="dataSource" />
  26. <property name="annotatedClasses">
  27. <list>
  28. <value>com.tricas.models.Perfil</value>
  29. </list>
  30. </property>
  31. <property name="packagesToScan" value="com.tricas.models" />
  32. <property name="hibernateProperties">
  33. <props>
  34. <prop key="hibernate.dialect">org.hibernate.dialect.MySQLDialect</prop>
  35. <prop key="hibernate.show_sql">true</prop>
  36. <prop key="hibernate.enable_lazy_load_no_trans">true</prop>
  37. <prop key="format_sql">true</prop>
  38. <prop key="use_sql_comments">true</prop>
  39. </props>
  40. </property>
  41. </bean>
  42.  
  43. <tx:annotation-driven transaction-manager="transactionManager" />
  44. <bean id="transactionManager"
  45. class="org.springframework.orm.hibernate4.HibernateTransactionManager">
  46. <property name="sessionFactory" ref="sessionFactory" />
  47. </bean>
  48.  
  49. <servlet>
  50. <servlet-name>spring-web</servlet-name>
  51. <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
  52. <init-param>
  53. <param-name>contextConfigLocation</param-name>
  54. <param-value>/WEB-INF/config/springMVC.xml</param-value>
  55. </init-param>
  56. <load-on-startup>1</load-on-startup>
  57. </servlet>
  58. <servlet-mapping>
  59. <servlet-name>spring-web</servlet-name>
  60. <url-pattern>/</url-pattern>
  61. </servlet-mapping>
  62.  
  63. <welcome-file-list>
  64. <welcome-file>
  65. verusuarios.html
  66. </welcome-file>
  67. </welcome-file-list>
  68.  
  69. <session-config>
  70. <session-timeout>
  71. 30
  72. </session-timeout>
  73. </session-config>
  74.  
  75. public class Anexo implements Serializable {
  76.  
  77. @OneToMany(mappedBy = "encargado")
  78. private Collection<Caja> cajaCollection;
  79.  
  80. private static final long serialVersionUID = 1L;
  81. @Id
  82. @GeneratedValue(strategy = GenerationType.IDENTITY)
  83. @Basic(optional = false)
  84. @Column(name = "idanexo")
  85. private Integer idanexo;
  86. @Column(name = "nombre")
  87. private String nombre;
  88. @Column(name = "apepat")
  89. private String apepat;
  90. @Column(name = "apemat")
  91. private String apemat;
  92. @Column(name = "tipodocumento")
  93. private String tipodocumento;
  94. @Column(name = "numdocumento")
  95. private String numdocumento;
  96. @Column(name = "direccion")
  97. private String direccion;
  98. @Column(name = "aahh")
  99. private String aahh;
  100. @Column(name = "cpm")
  101. private String cpm;
  102. @Column(name = "sector")
  103. private String sector;
  104. @Column(name = "referencia")
  105. private String referencia;
  106. @Column(name = "telefono")
  107. private String telefono;
  108. @Column(name = "celular")
  109. private String celular;
  110. @Column(name = "edad")
  111. private Integer edad;
  112. @Column(name = "fechanac")
  113. @Temporal(TemporalType.TIMESTAMP)
  114. private Date fechanac;
  115. @Column(name = "fechareg")
  116. @Temporal(TemporalType.TIMESTAMP)
  117. private Date fechareg;
  118. @Column(name = "sexo")
  119. private Character sexo;
  120. @Column(name = "email")
  121. private String email;
  122. @Column(name = "tipoanexo")
  123. private String tipoanexo;
  124. @Column(name = "codven")
  125. private String codven;
  126. @Column(name = "estcivil")
  127. private String estcivil;
  128. @Column(name = "conyuge")
  129. private String conyuge;
  130. @Column(name = "dniconyu")
  131. private String dniconyu;
  132. @Column(name = "direccionconyu")
  133. private String direccionconyu;
  134. @Column(name = "ocupacionconyu")
  135. private String ocupacionconyu;
  136. @Column(name = "cpropia")
  137. private String cpropia;
  138. @Column(name = "zona")
  139. private String zona;
  140. @Column(name = "sueldo")
  141. private Integer sueldo;
  142. @Column(name = "tienda")
  143. private String tienda;
  144. @JoinColumn(name = "iddistrito", referencedColumnName = "iddistrito")
  145. @ManyToOne
  146. private Distrito iddistrito;
  147. @OneToMany(mappedBy = "idanexo")
  148. private Collection<Ocupacion> ocupacionCollection;
  149. @OneToMany(mappedBy = "idanexo")
  150. private Collection<Operacion> operacionCollection;
  151. @OneToMany(cascade = CascadeType.ALL, mappedBy = "idanexo")
  152. private Collection<Credito> creditoCollection;
  153. @OneToMany(mappedBy = "idanexo")
  154. private Collection<Creditoaval> creditoavalCollection;
  155. @OneToMany(mappedBy = "idanexo")
  156. private Collection<Conceptos> conceptosCollection;
  157. @OneToMany(mappedBy = "idanexo")
  158. private Collection<Usuario> usuarioCollection;
  159.  
  160. public Anexo() {
  161. }
  162. /* Getters and Setters*/
  163.  
  164. @Repository
  165. @Transactional
  166. public class AnexoDaoImpl implements AnexoDao{
  167.  
  168. @Autowired
  169. private SessionFactory session;
  170.  
  171. @Override
  172. public List<Anexo> anexos() {
  173. return session.getCurrentSession().createQuery("from Anexo ").list();
  174. }
  175.  
  176. @Override
  177. public void ingresarModificar(Anexo anexo) {
  178. session.getCurrentSession().saveOrUpdate(anexo);
  179. }
  180.  
  181. @Service("anexoService")
  182. public class AnexoService {
  183.  
  184. @Autowired
  185. private AnexoDao anexodao;
  186.  
  187. @Transactional
  188. public List<Anexo> getAllAnexo() {
  189. return anexodao.anexos();
  190. }
  191.  
  192. @Transactional
  193. public void crearModificar(Anexo u) {
  194. anexodao.ingresarModificar(u);
  195. }
  196.  
  197. @Controller("anexoController")
  198. public class AnexoController {
  199.  
  200. @Autowired
  201. private AnexoService anexoserv;
  202.  
  203. @RequestMapping(value = "/veranexos", method = RequestMethod.GET)
  204. public String listPersons(Model model) {
  205. List<Anexo> list = anexoserv.getAllAnexo();
  206. model.addAttribute("anexo", new Anexo());
  207. model.addAttribute("list", list);
  208. return "anexo";
  209. }
  210.  
  211. @RequestMapping(value = "/anexo/add", method = RequestMethod.POST)
  212. public String addPerson(@ModelAttribute("anexo") Anexo p) {
  213. anexoserv.crearModificar(p);
  214. return "redirect:/veranexos";
  215. }
  216.  
  217. @RequestMapping("/edita/{idanexo}")
  218. public String editPerson(@PathVariable("idanexo") int id, Model model) {
  219. model.addAttribute("anexo", anexoserv.getById(id));
  220. model.addAttribute("list", anexoserv.getAllAnexo());
  221. return "anexo";
  222. }
  223.  
  224. @RequestMapping("/removea/{idanexo}")
  225. public String removePerson(@PathVariable("idanexo") int id) {
  226. Anexo p = new Anexo();
  227. p = anexoserv.getById(id);
  228. anexoserv.eliminar(p);
  229. return "redirect:/veranexos";
  230. }
  231.  
  232. java.lang.StringIndexOutOfBoundsException: String index out of range: 0
  233. at java.lang.String.charAt(String.java:646)
  234. at org.hibernate.type.descriptor.java.CharacterTypeDescriptor.wrap(CharacterTypeDescriptor.java:78)
  235. at org.hibernate.type.descriptor.java.CharacterTypeDescriptor.wrap(CharacterTypeDescriptor.java:33)
  236. at org.hibernate.type.descriptor.sql.VarcharTypeDescriptor$2.doExtract(VarcharTypeDescriptor.java:74)
  237. at org.hibernate.type.descriptor.sql.BasicExtractor.extract(BasicExtractor.java:64)
  238. at org.hibernate.type.AbstractStandardBasicType.nullSafeGet(AbstractStandardBasicType.java:263)
  239. at org.hibernate.type.AbstractStandardBasicType.nullSafeGet(AbstractStandardBasicType.java:259)
  240. at org.hibernate.type.AbstractStandardBasicType.nullSafeGet(AbstractStandardBasicType.java:249)
  241. at org.hibernate.type.AbstractStandardBasicType.hydrate(AbstractStandardBasicType.java:334)
  242. at org.hibernate.persister.entity.AbstractEntityPersister.hydrate(AbstractEntityPersister.java:2969)
  243. at org.hibernate.loader.Loader.loadFromResultSet(Loader.java:1695)
  244. at org.hibernate.loader.Loader.instanceNotYetLoaded(Loader.java:1627)
  245. at org.hibernate.loader.Loader.getRow(Loader.java:1514)
  246. at org.hibernate.loader.Loader.getRowFromResultSet(Loader.java:725)
  247. at org.hibernate.loader.Loader.processResultSet(Loader.java:952)
  248. at org.hibernate.loader.Loader.doQuery(Loader.java:920)
  249. at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:354)
  250. at org.hibernate.loader.Loader.doList(Loader.java:2551)
  251. at org.hibernate.loader.Loader.doList(Loader.java:2537)
  252. at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2367)
  253. at org.hibernate.loader.Loader.list(Loader.java:2362)
  254. at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:496)
  255. at org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:387)
  256. at org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:229)
  257. at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1260)
  258. at org.hibernate.internal.QueryImpl.list(QueryImpl.java:103)
  259. at com.tricas.dao.AnexoDaoImpl.anexos(AnexoDaoImpl.java:20)
  260. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  261. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  262. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  263. at java.lang.reflect.Method.invoke(Method.java:497)
  264. at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:333)
  265. at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)
  266. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
  267. at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:96)
  268. at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:260)
  269. at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:94)
  270. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
  271. at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:213)
  272. at com.sun.proxy.$Proxy799.anexos(Unknown Source)
  273. at com.tricas.services.AnexoService.getAllAnexo(AnexoService.java:19)
  274. at com.tricas.services.AnexoService$$FastClassBySpringCGLIB$$fb0c453f.invoke(<generated>)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement