eclipse workspace

instalcao do vaven]

instalação dasdependencias do maven

connwtion

jbdcb:derby

createStatement()

sql injection

statement

ACID

SOLID - autocomit

crud

mysql connector

mysql jdbc url

package br.edu.ifsp;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

import org.apache.commons.lang3.StringUtils;

/**
 * Hello world!
 *
 */
public class App {
	public static void main(String[] args) {
		
		try {
			Connection conn = DriverManager
				.getConnection(
						"jdbc:mysql://localhost:3306/estudante"
						, "estudante"
						, "estudante");
			
			PreparedStatement ps = 
					conn.prepareStatement("select * from Persons");
			
			ResultSet rs = ps.executeQuery();
			
			while(rs.next()) {
				System.out.println("nome " + rs.getString(2));
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		
		String x = null;
		
		if ( StringUtils.isEmpty(x) ) {
			System.out.println("x eh nulo ou branco.");
		} else {
			System.out.println("x eh " + x);			
		}

	}
}