Презентация 7. Java databases and JDBC 2. JDBC Database Access JDBC онлайн
На нашем сайте вы можете скачать и просмотреть онлайн доклад-презентацию на тему 7. Java databases and JDBC 2. JDBC Database Access JDBC абсолютно бесплатно. Урок-презентация на эту тему содержит всего 40 слайдов. Все материалы созданы в программе PowerPoint и имеют формат ppt или же pptx. Материалы и темы для презентаций взяты из открытых источников и загружены их авторами, за качество и достоверность информации в них администрация сайта не отвечает, все права принадлежат их создателям. Если вы нашли то, что искали, отблагодарите авторов - поделитесь ссылкой в социальных сетях, а наш сайт добавьте в закладки.
Презентации » Устройства и комплектующие » 7. Java databases and JDBC 2. JDBC Database Access JDBC
Оцените!
Оцените презентацию от 1 до 5 баллов!
- Тип файла:ppt / pptx (powerpoint)
- Всего слайдов:40 слайдов
- Для класса:1,2,3,4,5,6,7,8,9,10,11
- Размер файла:319.50 kB
- Просмотров:60
- Скачиваний:0
- Автор:неизвестен
Слайды и текст к этой презентации:
№6 слайд
![Basic Example II Connection](/documents_6/42b603582adf9cd9bc225bf5ddc42f8a/img5.jpg)
Содержание слайда: Basic Example II
Connection con = DriverManager.getConnection ("jdbc:derby:C:\\VMO\\Курсы\\Projects\\CM");
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery(
"SELECT name, charge FROM merchant");
while (rs.next()){
String nm = rs.getString("name");
double p = rs.getDouble(2);
System.out.println(nm + " " + p);
}
con.close();
See 721JDBCBasics project for the full text
№8 слайд
![Establishing a connection. A](/documents_6/42b603582adf9cd9bc225bf5ddc42f8a/img7.jpg)
Содержание слайда: Establishing a connection.
A JDBC application connects to a target data source using one of two classes:
DriverManager - connects an application to a data source, specified by a database URL
DataSource - allows details about the underlying data source to be transparent to your application
№9 слайд
![Connection example public](/documents_6/42b603582adf9cd9bc225bf5ddc42f8a/img8.jpg)
Содержание слайда: Connection example
public static Connection getConnection() throws IOException, SQLException{
Connection conn = null;
Properties props = new Properties();
InputStreamReader in = new InputStreamReader(new FileInputStream("appProperties.txt"), "UTF-8");
props.load(in);
in.close();
String connString = props.getProperty("DBConnectionString");
conn = DriverManager.getConnection(connString);
return conn;
}
See 722JDBCConnection project for the full text
№11 слайд
![Creating Statements Kinds of](/documents_6/42b603582adf9cd9bc225bf5ddc42f8a/img10.jpg)
Содержание слайда: Creating Statements
Kinds of statements:
Statement - simple SQL statements with no parameters
PreparedStatement (extends Statement) - precompiling SQL statements that might contain input parameters
CallableStatement (extends PreparedStatement) - used to execute stored procedures that may contain both input and output parameters
№12 слайд
![Insert New Customer Example I](/documents_6/42b603582adf9cd9bc225bf5ddc42f8a/img11.jpg)
Содержание слайда: Insert New Customer Example I
Connection con = getConnection();
String sql = "INSERT INTO customer (name, address, ";
sql += " email, ccNo, ccType, maturity) values(";
sql += " 'Clar Nelis', 'Vosselaar st. 19, Trnaut, Belgium', ";
sql += " 'Clar@adw.com', '11345694671231', ";
sql += " 'MasterCard', '2014-07-31') ";
Statement stmt = con.createStatement();
stmt.executeUpdate(sql);
con.close();
See 723SimpleInsert project for the full text
№13 слайд
![Prepared Statements Usually](/documents_6/42b603582adf9cd9bc225bf5ddc42f8a/img12.jpg)
Содержание слайда: Prepared Statements
Usually reduces execution time (the DBMS can just run the PreparedStatement SQL statement without having to compile it first)
Used most often for SQL statements that take parameters. You can use the same statement and supply it with different values each time you execute it
№14 слайд
![Insert New Customer Example](/documents_6/42b603582adf9cd9bc225bf5ddc42f8a/img13.jpg)
Содержание слайда: Insert New Customer Example II
public void addCustomer(String name, String address, String email, String ccNo, String ccType, java.sql.Date dt) throws SQLException, IOException{
Connection con = getConnection();
String sql = "INSERT INTO customer (name, address, ";
sql += " email, ccNo, ccType, maturity) values(?,?,?,?,?,?) ";
PreparedStatement stmt = con.prepareStatement(sql);
stmt.setString(1, name);
stmt.setString(2, address);
stmt.setString(3, email);
stmt.setString(4, ccNo);
stmt.setString(5, ccType);
stmt.setDate(6, dt);
stmt.executeUpdate();
con.close();
}
See 724PreparedInsert project for the full text
№15 слайд
![SQL Date From](/documents_6/42b603582adf9cd9bc225bf5ddc42f8a/img14.jpg)
Содержание слайда: SQL Date
From GregorianCalendar:
GregorianCalendar c = new GregorianCalendar(2012, 03, 31);
java.util.Date dt = c.getTime();
java.sql.Date dt1 = new java.sql.Date(dt.getTime());
From LocalDate:
LocalDate dt1 = LocalDate.of(2015, 2, 15);
Instant instant = dt1.atStartOfDay(ZoneId.systemDefault()).toInstant();
java.sql.Date dt = new java.sql.Date(java.util.Date.from(instant).getTime());
№21 слайд
![Processing ResultSet Objects](/documents_6/42b603582adf9cd9bc225bf5ddc42f8a/img20.jpg)
Содержание слайда: Processing ResultSet Objects
You access the data in a ResultSet object through a cursor
Note that this cursor is not a database cursor
This cursor is a pointer that points to one row of data in the ResultSet object
Initially, the cursor is positioned before the first row
You call various methods defined in the ResultSet object to move the cursor
№22 слайд
![Exercise List of Merchants](/documents_6/42b603582adf9cd9bc225bf5ddc42f8a/img21.jpg)
Содержание слайда: Exercise: List of Merchants
Create an application to display list of merchants:
Create a Merchant class with fields necessary for saving merchant’s data and getStringForPrint method for displaying these data
Create getMerchants method for filling list of merchants from a corresponding data table
Process this list of merchants to display it on the system console
№28 слайд
![Handling SQLExceptions The](/documents_6/42b603582adf9cd9bc225bf5ddc42f8a/img27.jpg)
Содержание слайда: Handling SQLExceptions
The SQLException contains the following information
A description of the error - getMessage()
A SQLState standard code – getSQLState()
An error code (DB specific) – getErrorCode()
A cause (Throwable objects that caused the SQLException instance to be thrown) – getCause()
A reference to any chained exceptions – getNextException()
№33 слайд
![Using Transactions public](/documents_6/42b603582adf9cd9bc225bf5ddc42f8a/img32.jpg)
Содержание слайда: Using Transactions
public static void addPayment(Connection conn, java.util.Date dt, int customerId, int merchantId, String goods, double total) throws SQLException{
conn.setAutoCommit(false);
double charge = getCharge(conn, merchantId);
if (charge < 0.0) return;
// Insert new record into PAYMENT table
// Update corresponding record in MERCHANT table
conn.commit();
}
№34 слайд
![Rollback Method Calling the](/documents_6/42b603582adf9cd9bc225bf5ddc42f8a/img33.jpg)
Содержание слайда: Rollback Method
Calling the method rollback terminates a transaction and returns any values that were modified to their previous values.
If you are trying to execute one or more statements in a transaction and get a SQLException, call the method rollback to end the transaction and start the transaction all over again.
№37 слайд
![Object-Relational Mapping SQL](/documents_6/42b603582adf9cd9bc225bf5ddc42f8a/img36.jpg)
Содержание слайда: Object-Relational Mapping
SQL DBMS can only store and manipulate scalar values such as integers and strings organized within tables
Data management tasks in object-oriented programming are typically implemented by manipulating objects that are almost always non-scalar values
The problem is translating the logical representation of the objects into an atomized form that is capable of being stored on the database
№39 слайд
![Some Java ORM Systems](/documents_6/42b603582adf9cd9bc225bf5ddc42f8a/img38.jpg)
Содержание слайда: Some Java ORM Systems
Hibernate, open source ORM framework, widely used
MyBatis, formerly named iBATIS, has .NET port
Cayenne, Apache, open source for Java
Athena Framework, open source Java ORM
Carbonado, open source framework, backed by Berkeley DB or JDBC
EclipseLink, Eclipse persistence platform
TopLink by Oracle
QuickDB ORM, open source ORM framework (GNU LGPL)
Скачать все slide презентации 7. Java databases and JDBC 2. JDBC Database Access JDBC одним архивом:
Похожие презентации
-
7. Java databases and JDBC 3. JDBC Additional Tasks
-
8. Java Databases and JDBC 1. Introduction to Databases
-
Основы JDBC (Java DataBase Connectivity)
-
Построение Standby Database на основе технологии Oracle Active Data Guard
-
Database usage in java object-relational mapping. (Лекция 8)
-
Mathematical functions, characters, and strings. Introduction to Java Programming
-
Internet and Java Foundations, Programming and Practice
-
Database Management Systems 1
-
Spring data. Familiar and consistent programming model for data access
-
JDBC стандартный прикладной интерфейс (API) языка Java. (Лекция 16)