Przejdź do głównej zawartości

Posty

Wyświetlam posty z etykietą SQL

Inserting Data into SQL Database with Java

Inserting Data into SQL Database with Java Java Documentation - Processing SQL statements with JDBC  Process: Get connection to database Create a statement Execute SQL query import java.sql.*; /**  *  * @author www.luv2code.com  *  */ public class JdbcTest { public static void main(String[] args) throws SQLException { Connection myConn = null; Statement myStmt = null; ResultSet myRs = null; String dbUrl = "jdbc:mysql://localhost:3306/demo ?autoReconnect=true&useSSL=false "; String user = "root"; String pass = "Sasanka01"; try { // 1. Get a connection to database myConn = DriverManager.getConnection(dbUrl, user, pass); System.out.println("Database connection successfully created"); // 2. Create a statement myStmt = myConn.createStatement(); int rowsAffected = myStmt.executeUpdate(                          "...

Java Database Connection: JDBC and MySQL

Java Database Connection: JDBC and MySQL JDBC - standard API allow to connect with MySQL Java Application <--------- >JDBC <---------> Database JDBC Architecture JDBC Driver  JDBC Driver Implementation JDBC Driver Manager JDBC API is definded in following packages: java.sql and javax.sql ------------------------ Submitting SQL Queries  - JAVA Get a connection to database Create Statement object Execute SQL query Process Result Set Get a connection to database                    import java.sql.*;                     ....                    String dbUrl = "jdbc:mysql://localhost:3306/demo ?                                                  ...

ER Diagrams Intro - SQL podstawy

ER Diagrams Intro