Core Java. Лекция 8

Failed to generate image: Could not load PlantUML. Either require 'asciidoctor-diagram-plantuml' or specify the location of the PlantUML JAR(s) using the 'DIAGRAM_PLANTUML_CLASSPATH' environment variable. Alternatively a PlantUML binary can be provided (plantuml-native in $PATH).
@startuml
skinparam dpi 180
rectangle Application {
rectangle "Code" as app
rectangle JDBC {
rectangle "Driver" as driver
}
}
database "database" as db
app->JDBC
driver-->db

@enduml

jdbc:sqlserver://172.16.1.114:52836;databaseName=celesta

jdbc:postgresql://127.0.0.1:5432/celesta

jdbc:oracle:thin:192.168.110.128:1521:XE

jdbc:derby://localhost:1527/corejava;create=true

Failed to generate image: Could not load PlantUML. Either require 'asciidoctor-diagram-plantuml' or specify the location of the PlantUML JAR(s) using the 'DIAGRAM_PLANTUML_CLASSPATH' environment variable. Alternatively a PlantUML binary can be provided (plantuml-native in $PATH).
skinparam dpi 150
hide footbox
client-> DataSource : getConnection()
DataSource -> connection **: new

connection-->client: connection

client->connection: createStatement()
connection->statement **:new
statement-->client: statement

client->statement: executeQuery()
statement->resultSet **:new
resultSet-->client: resultSet

client->resultSet: next()
client->resultSet: next()
client->resultSet: next()

try (Connection conn = dataSource.getConnection();
     Statement stmt = conn.createStatement()){

  ResultSet result = stmt.executeQuery("select name from speaker");

  while (result.next()) {

      System.out.println(result.getString("name"));

  }
}

String connString = "jdbc:postgresql://127.0.0.1:5432/celesta"
Connection conn = DriverManager.getConnection(connString);

Failed to generate image: Could not load PlantUML. Either require 'asciidoctor-diagram-plantuml' or specify the location of the PlantUML JAR(s) using the 'DIAGRAM_PLANTUML_CLASSPATH' environment variable. Alternatively a PlantUML binary can be provided (plantuml-native in $PATH).
skinparam dpi 150
hide footbox
client->pool : getConnection()
pool->pool: poll()
alt Pool is not empty
  pool-->client: pooledConnection
else Pool is empty
  pool->DriverManager: getConnection()
  DriverManager-->pool: connection
  pool-->pooledConnection **:new(connection)
  pooledConnection-->client: pooledConnection
end
client->pooledConnection: close()
pooledConnection->pool: add(this)

DataSource connectionPool = ...
try (Connection conn = connectionPool.getConnection()) {
    ...
}

Failed to generate image: Could not load PlantUML. Either require 'asciidoctor-diagram-plantuml' or specify the location of the PlantUML JAR(s) using the 'DIAGRAM_PLANTUML_CLASSPATH' environment variable. Alternatively a PlantUML binary can be provided (plantuml-native in $PATH).
@startuml

skinparam dpi 180

interface AutoCloseable
interface Statement {
boolean execute(String sql)
int executeUpdate(String sql)
ResultSet executeQuery(String sql)

ResultSet getResultSet()
}

interface PreparedStatement {
void setXXX(int parameterIndex, XXX x)
}

interface CallableStatement {
void registerOutParameter(int parameterIndex, int sqlType)
}

AutoCloseable <|- Statement
Statement <|- PreparedStatement
PreparedStatement <|- CallableStatement
@enduml

int confId = ...
try (PreparedStatement stmt =
  conn.prepareStatement(
    "select name from talk where conferenceid = ?")) {
  //устанавливаем значение параметра
  //индексация с единицы!!
  stmt.setInt(1, confId);

  ResultSet result = stmt.executeQuery();
  while (result.next()) {
      System.out.println(result.getString("name"));
  }

}

sql = "SELECT * FROM users WHERE name = '" + userName + "'"

userName = "' OR '1'='1"

userName = "a';DROP TABLE users;"

//... и много другой гадости

Failed to generate image: Could not load PlantUML. Either require 'asciidoctor-diagram-plantuml' or specify the location of the PlantUML JAR(s) using the 'DIAGRAM_PLANTUML_CLASSPATH' environment variable. Alternatively a PlantUML binary can be provided (plantuml-native in $PATH).
@startuml
skinparam dpi 180

hide circle

class speaker {
  id: INT
  name: VARCHAR
}

class conference {
  id: INT
  name: VARCHAR
}

class talk {
  id: INT
  conferenceid: INT
  name: VARCHAR
}

class talkspeakers {
 talkid: INT
 speakerid: INT
}

talk --> conference: conferenceid

talkspeakers --> speaker: speakerid

talkspeakers --> talk: talkid

@enduml

Failed to generate image: Could not load PlantUML. Either require 'asciidoctor-diagram-plantuml' or specify the location of the PlantUML JAR(s) using the 'DIAGRAM_PLANTUML_CLASSPATH' environment variable. Alternatively a PlantUML binary can be provided (plantuml-native in $PATH).
@startuml
skinparam dpi 180
object ConnectionPool
object JdbcTemplate
object ConferenceDao
object SpeakerDao
object TalkDao
object Controller

JdbcTemplate --> ConnectionPool
SpeakerDao --> JdbcTemplate
TalkDao --> JdbcTemplate
ConferenceDao --> JdbcTemplate
Controller --> SpeakerDao
Controller --> TalkDao
Controller --> ConferenceDao
@enduml

Failed to generate image: Could not load PlantUML. Either require 'asciidoctor-diagram-plantuml' or specify the location of the PlantUML JAR(s) using the 'DIAGRAM_PLANTUML_CLASSPATH' environment variable. Alternatively a PlantUML binary can be provided (plantuml-native in $PATH).
@startuml
skinparam dpi 180
object Controller1
object Controller2

object Service1
object Service2
object Service3

object Dao1
object Dao2
object Dao3

Controller1 --> Service1
Controller1 --> Service2
Controller2 --> Service2
Controller2 --> Service1
Controller2 --> Service3
note on link
  «соединение
  проводами»,
  aka "wiring"
end note

Service1 --> Dao1
Service2 --> Dao1
Service3 --> Dao2
Service3 --> Dao3
Service1 --> Dao2

@enduml