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);
}
}
}