Advertisement
Guest User

Untitled

a guest
Feb 15th, 2017
100
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 12.22 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.  
  45. <bean id="transactionManager"
  46. class="org.springframework.orm.hibernate4.HibernateTransactionManager">
  47. <property name="sessionFactory" ref="sessionFactory" />
  48. </bean>
  49.  
  50. <servlet>
  51. <servlet-name>spring-web</servlet-name>
  52. <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
  53. <init-param>
  54. <param-name>contextConfigLocation</param-name>
  55. <param-value>/WEB-INF/config/springMVC.xml</param-value>
  56. </init-param>
  57. <load-on-startup>1</load-on-startup>
  58. </servlet>
  59. <servlet-mapping>
  60. <servlet-name>spring-web</servlet-name>
  61. <url-pattern>/</url-pattern>
  62. </servlet-mapping>
  63.  
  64. <welcome-file-list>
  65. <welcome-file>
  66. verusuarios.html
  67. </welcome-file>
  68. </welcome-file-list>
  69.  
  70. <session-config>
  71. <session-timeout>
  72. 30
  73. </session-timeout>
  74. </session-config>
  75.  
  76. public class Anexo implements Serializable {
  77.  
  78. @OneToMany(mappedBy = "encargado")
  79. private Collection<Caja> cajaCollection;
  80.  
  81. private static final long serialVersionUID = 1L;
  82. @Id
  83. @GeneratedValue(strategy = GenerationType.IDENTITY)
  84. @Basic(optional = false)
  85. @Column(name = "idanexo")
  86. private Integer idanexo;
  87. @Column(name = "nombre")
  88. private String nombre;
  89. @Column(name = "apepat")
  90. private String apepat;
  91. @Column(name = "apemat")
  92. private String apemat;
  93. @Column(name = "tipodocumento")
  94. private String tipodocumento;
  95. @Column(name = "numdocumento")
  96. private String numdocumento;
  97. @Column(name = "direccion")
  98. private String direccion;
  99. @Column(name = "aahh")
  100. private String aahh;
  101. @Column(name = "cpm")
  102. private String cpm;
  103. @Column(name = "sector")
  104. private String sector;
  105. @Column(name = "referencia")
  106. private String referencia;
  107. @Column(name = "telefono")
  108. private String telefono;
  109. @Column(name = "celular")
  110. private String celular;
  111. @Column(name = "edad")
  112. private Integer edad;
  113. @Column(name = "fechanac")
  114. @Temporal(TemporalType.TIMESTAMP)
  115. private Date fechanac;
  116. @Column(name = "fechareg")
  117. @Temporal(TemporalType.TIMESTAMP)
  118. private Date fechareg;
  119. @Column(name = "sexo")
  120. private Character sexo;
  121. @Column(name = "email")
  122. private String email;
  123. @Column(name = "tipoanexo")
  124. private String tipoanexo;
  125. @Column(name = "codven")
  126. private String codven;
  127. @Column(name = "estcivil")
  128. private String estcivil;
  129. @Column(name = "conyuge")
  130. private String conyuge;
  131. @Column(name = "dniconyu")
  132. private String dniconyu;
  133. @Column(name = "direccionconyu")
  134. private String direccionconyu;
  135. @Column(name = "ocupacionconyu")
  136. private String ocupacionconyu;
  137. @Column(name = "cpropia")
  138. private String cpropia;
  139. @Column(name = "zona")
  140. private String zona;
  141. @Column(name = "sueldo")
  142. private Integer sueldo;
  143. @Column(name = "tienda")
  144. private String tienda;
  145. @JoinColumn(name = "iddistrito", referencedColumnName = "iddistrito")
  146. @ManyToOne
  147. private Distrito iddistrito;
  148. @OneToMany(mappedBy = "idanexo")
  149. private Collection<Ocupacion> ocupacionCollection;
  150. @OneToMany(mappedBy = "idanexo")
  151. private Collection<Operacion> operacionCollection;
  152. @OneToMany(cascade = CascadeType.ALL, mappedBy = "idanexo")
  153. private Collection<Credito> creditoCollection;
  154. @OneToMany(mappedBy = "idanexo")
  155. private Collection<Creditoaval> creditoavalCollection;
  156. @OneToMany(mappedBy = "idanexo")
  157. private Collection<Conceptos> conceptosCollection;
  158. @OneToMany(mappedBy = "idanexo")
  159. private Collection<Usuario> usuarioCollection;
  160.  
  161. public Anexo() {
  162. }
  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. <html>
  233. <head>
  234. <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
  235. <title>Mantenimiento Anexos</title>
  236. <style type="text/css">
  237. .tg {border-collapse:collapse;border-spacing:0;border-color:#ccc;}
  238. .tg td{font-family:Arial, sans-serif;font-size:14px;padding:10px 5px;border-style:solid;border-width:1px;overflow:hidden;word-break:normal;border-color:#ccc;color:#333;background-color:#fff;}
  239. .tg th{font-family:Arial, sans-serif;font-size:14px;font-weight:normal;padding:10px 5px;border-style:solid;border-width:1px;overflow:hidden;word-break:normal;border-color:#ccc;color:#333;background-color:#f0f0f0;}
  240. .tg .tg-4eph{background-color:#f9f9f9}
  241. </style>
  242. </head>
  243. <body>
  244. <h1>Agregar un Perfil</h1>
  245.  
  246. <c:url var="addAction" value="/anexo/add" ></c:url>
  247.  
  248. <form:form action="${addAction}" commandName="anexo" id="registro">
  249. <table>
  250. <c:if test="${!empty anexo.apepat}">
  251. <tr>
  252. <td>
  253. <form:label path="idanexo">
  254. <spring:message text="ID"/>
  255. </form:label>
  256. </td>
  257. <td>
  258. <form:input path="idanexo" readonly="true" size="8" disabled="true" />
  259. <form:hidden path="idanexo" />
  260. </td>
  261. </tr>
  262. </c:if>
  263. <tr>
  264. <td>
  265. <form:label path="nombre">
  266. <spring:message text="Nombre"/>
  267. </form:label>
  268. </td>
  269. <td>
  270. <form:input path="nombre" />
  271. </td>
  272. </tr>
  273. <tr>
  274. <td>
  275. <form:label path="apepat">
  276. <spring:message text="Descripcion"/>
  277. </form:label>
  278. </td>
  279. <td>
  280. <form:input path="apepat" />
  281. </td>
  282. </tr>
  283. <tr>
  284. <td colspan="2">
  285. <c:if test="${!empty anexo.apepat}">
  286. <input type="submit"
  287. value="<spring:message text="Editar Perfil"/>" />
  288. </c:if>
  289. <c:if test="${empty anexo.apepat}">
  290. <input type="submit"
  291. value="<spring:message text="Agregar Perfil"/>" />
  292. </c:if>
  293. </td>
  294. </tr>
  295.  
  296. </table>
  297. </form:form>
  298.  
  299. <h3>Lista de Perfiles</h3>
  300. <c:if test="${!empty list}">
  301. <table class="tg">
  302. <tr>
  303. <th width="80">Id</th>
  304. <th width="90">Abrev.</th>
  305. <th width="120">Nombre</th>
  306. <th width="120">Editar</th>
  307. <th width="120">Eliminar</th>
  308. <c:forEach items="${list}" var="anexo">
  309. <tr>
  310. <td>${anexo.idanexo}</td>
  311. <td>${anexo.nombre}</td>
  312. <td>${anexo.apepat}</td>
  313. <td><a href="<c:url value='/edita/${anexo.idanexo}' />" >Editar</a></td>
  314. <td><a href="<c:url value='/removea/${anexo.idanexo}' />" >Eliminar</a></td>
  315. </tr>
  316. </c:forEach>
  317. </table>
  318. </c:if>
  319. </body>
  320.  
  321. java.lang.StringIndexOutOfBoundsException: String index out of range: 0
  322. at java.lang.String.charAt(String.java:646)
  323. at org.hibernate.type.descriptor.java.CharacterTypeDescriptor.wrap(CharacterTypeDescriptor.java:78)
  324. at org.hibernate.type.descriptor.java.CharacterTypeDescriptor.wrap(CharacterTypeDescriptor.java:33)
  325. at org.hibernate.type.descriptor.sql.VarcharTypeDescriptor$2.doExtract(VarcharTypeDescriptor.java:74)
  326. at org.hibernate.type.descriptor.sql.BasicExtractor.extract(BasicExtractor.java:64)
  327. at org.hibernate.type.AbstractStandardBasicType.nullSafeGet(AbstractStandardBasicType.java:263)
  328. at org.hibernate.type.AbstractStandardBasicType.nullSafeGet(AbstractStandardBasicType.java:259)
  329. at org.hibernate.type.AbstractStandardBasicType.nullSafeGet(AbstractStandardBasicType.java:249)
  330. at org.hibernate.type.AbstractStandardBasicType.hydrate(AbstractStandardBasicType.java:334)
  331. at org.hibernate.persister.entity.AbstractEntityPersister.hydrate(AbstractEntityPersister.java:2969)
  332. at org.hibernate.loader.Loader.loadFromResultSet(Loader.java:1695)
  333. at org.hibernate.loader.Loader.instanceNotYetLoaded(Loader.java:1627)
  334. at org.hibernate.loader.Loader.getRow(Loader.java:1514)
  335. at org.hibernate.loader.Loader.getRowFromResultSet(Loader.java:725)
  336. at org.hibernate.loader.Loader.processResultSet(Loader.java:952)
  337. at org.hibernate.loader.Loader.doQuery(Loader.java:920)
  338. at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:354)
  339. at org.hibernate.loader.Loader.doList(Loader.java:2551)
  340. at org.hibernate.loader.Loader.doList(Loader.java:2537)
  341. at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2367)
  342. at org.hibernate.loader.Loader.list(Loader.java:2362)
  343. at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:496)
  344. at org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:387)
  345. at org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:229)
  346. at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1260)
  347. at org.hibernate.internal.QueryImpl.list(QueryImpl.java:103)
  348. at com.tricas.dao.AnexoDaoImpl.anexos(AnexoDaoImpl.java:20)
  349. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  350. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  351. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  352. at java.lang.reflect.Method.invoke(Method.java:497)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement