Chad Darby darbyluv2code

darbyluv2code / gist:190193afe61fce97c3f7

Created April 10, 2015 14:53

UserDAO.addUser(...) method - How to create encrypted passwords in the database

	package com.luv2code.jdbc.employeesearch.dao;

	import java.io.FileInputStream;
	import java.sql.Connection;
	import java.sql.DriverManager;
	import java.sql.PreparedStatement;
	import java.sql.ResultSet;
	import java.sql.SQLException;
	import java.sql.Statement;
	import java.sql.Timestamp;

darbyluv2code / EmployeeSearchApp.java

Created April 21, 2015 21:47

User names are populated in lines 64-69

	package com.luv2code.jdbc.employeesearch.ui;

	import java.awt.BorderLayout;
	import java.awt.EventQueue;

	import javax.swing.JFrame;
	import javax.swing.JPanel;
	import javax.swing.border.EmptyBorder;
	import javax.swing.JLabel;

darbyluv2code / table-setup.sql

Created September 21, 2016 15:12

	create database if not exists demo;

	use demo;

	drop table if exists employees;

	CREATE TABLE `employees` (
	`id` int(11) NOT NULL AUTO_INCREMENT,
	`last_name` varchar(64) DEFAULT NULL,
	`first_name` varchar(64) DEFAULT NULL,

darbyluv2code / Driver.java

Created September 30, 2016 13:57

Watching files in Java with WatchService

	import java.nio.file.Path;
	import java.nio.file.Paths;
	import java.nio.file.StandardWatchEventKinds;
	import java.nio.file.WatchEvent;
	import java.nio.file.WatchKey;
	import java.nio.file.WatchService;
	import java.util.List;

	public class Driver {

darbyluv2code / Student.java

Created October 3, 2016 14:32

FAQ: How to populate radiobuttons with items from Java class like we did with selectlist?

	package com.luv2code.springdemo.mvc;

	import java.util.LinkedHashMap;

	public class Student {

	private String firstName;
	private String lastName;

	private String favoriteLanguage;

darbyluv2code / gist:29d28eb911a5a1f3fc1b669911db2f28

Created October 4, 2016 15:16

	CREATE TABLE `employees` (
	`id` int(11) NOT NULL AUTO_INCREMENT,
	`last_name` varchar(64) DEFAULT NULL,
	`first_name` varchar(64) DEFAULT NULL,
	`checkout_time` timestamp DEFAULT NULL,
	PRIMARY KEY (`id`)
	) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;

darbyluv2code / gist:5f01514ad256b26bfa54c7b902a0ea0e

Last active March 31, 2017 00:53

	String sql = "INSERT INTO employees (last_name, first_name, checkout_time) values (?, ?, ?)";
	PreparedStatement myStmt = myConn.prepareStatement(sql);
	...
	java.util.Date now = new java.util.Date();
	java.sql.Timestamp currentTimetamp = new java.sql.Timestamp(now.getTime());

	myStmt.setTimestamp(3, currentTimestamp);

	myStmt.executeUpdate();

darbyluv2code / gist:be3b9fb545676034bbaa0547c3d58521

Created October 4, 2016 15:17

	String sql = "select * from employees";
	ResultSet myRs = myStmt.executeQuery(sql);

	while (myRs.next()) {
	System.out.println(myRs.getTimestamp("checkout_time"));
	}

darbyluv2code / add-student-form.jsp

Created November 1, 2016 14:35

	<!DOCTYPE html>
	<html>

	<head>
	<title>Add Student</title>

	<link type="text/css" rel="stylesheet" href="css/style.css">
	<link type="text/css" rel="stylesheet" href="css/add-student-style.css">
	</head>

darbyluv2code / student-dropdown-form.html

Created January 4, 2017 15:30

JSP: Drop down forms

	<html>

	<head><title>Student Registration Form</title></head>

	<body>

	<form action="student-dropdown-response.jsp">

	First name: <input type="text" name="firstName" />