Skip to content

Instantly share code, notes, and snippets.

View ajfmo's full-sized avatar
🎯
Focusing

Adrian Flores ajfmo

🎯
Focusing
View GitHub Profile
package ajfmo.sislic.controller;
import java.util.List;
import javax.persistence.criteria.CriteriaBuilder;
import javax.persistence.criteria.CriteriaQuery;
import javax.persistence.criteria.Root;
import org.hibernate.Session;
import org.hibernate.Transaction;
package ajfmo.sislic.controller;
import java.time.LocalDate;
import java.util.List;
import javax.persistence.Query;
import javax.persistence.criteria.CriteriaBuilder;
import javax.persistence.criteria.CriteriaQuery;
import javax.persistence.criteria.Root;
package ajfmo.sislic.view;
import java.net.URL;
import java.util.Optional;
import java.util.ResourceBundle;
import ajfmo.sislic.controller.EmployeeDAO;
import ajfmo.sislic.controller.ProductTransactionDAO;
import ajfmo.sislic.controller.SucursalDAO;
import ajfmo.sislic.controller.TransactionsDAO;
package ajfmo.sislic.entities;
// Generated 25/01/2018 11:46:31 PM by Hibernate Tools 4.3.1
import static javax.persistence.GenerationType.IDENTITY;
import javax.persistence.CascadeType;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.FetchType;
import javax.persistence.GeneratedValue;
package ajfmo.sislic.entities;
// Generated 05/12/2017 10:46:05 PM by Hibernate Tools 5.2.5.Final
import javax.persistence.CascadeType;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.FetchType;
import javax.persistence.Id;
import javax.persistence.JoinColumn;
import javax.persistence.ManyToOne;
@ajfmo
ajfmo / students.sql
Created December 31, 2017 13:05
Database script
CREATE DATABASE `students` /*!40100 DEFAULT CHARACTER SET utf8 */;
use students;
CREATE TABLE `career` (
`career_id` varchar(25) NOT NULL,
`career_name` varchar(100) NOT NULL,
PRIMARY KEY (`career_id`),
UNIQUE KEY `career_name_UNIQUE` (`career_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `section` (
@ajfmo
ajfmo / pom.xml
Created December 31, 2017 13:00
Maven POM
<?xml version="1.0" encoding="utf-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
<modelVersion>4.0.0</modelVersion>
<groupId>ajfmo</groupId>
<artifactId>Study-Control</artifactId>
<name>Study-Control</name>
<packaging>jar</packaging>
<version>0.0.1-SNAPSHOT</version>
<organization>
@ajfmo
ajfmo / MenuEstudiante.fxml
Created December 31, 2017 12:58
Menu Estudiante (form)
<?xml version="1.0" encoding="UTF-8"?>
<?import javafx.scene.control.Button?>
<?import javafx.scene.control.ComboBox?>
<?import javafx.scene.control.Label?>
<?import javafx.scene.control.SplitPane?>
<?import javafx.scene.control.TableColumn?>
<?import javafx.scene.control.TableView?>
<?import javafx.scene.control.TextField?>
<?import javafx.scene.layout.AnchorPane?>
@ajfmo
ajfmo / StudentView.java
Created December 31, 2017 12:57
View Controller for Student Menu
package ajfmo.studycontrol.view;
import java.net.URL;
import java.util.ResourceBundle;
import ajfmo.studycontrol.DAO.StudentDAO;
import ajfmo.studycontrol.entities.Career;
import ajfmo.studycontrol.entities.Section;
import ajfmo.studycontrol.entities.Student;
import ajfmo.studycontrol.utils.HibernateUtil;
@ajfmo
ajfmo / StudentDAO.java
Created December 31, 2017 12:55
DAO for Student
package ajfmo.studycontrol.DAO;
import java.util.List;
import javax.persistence.criteria.CriteriaBuilder;
import javax.persistence.criteria.CriteriaQuery;
import javax.persistence.criteria.Root;
import org.hibernate.HibernateException;
import org.hibernate.Session;