🗊 Презентация 7. Java databases and JDBC 3. JDBC Additional Tasks

Нажмите для полного просмотра!
7. Java databases and JDBC 3. JDBC Additional Tasks, слайд №1 7. Java databases and JDBC 3. JDBC Additional Tasks, слайд №2 7. Java databases and JDBC 3. JDBC Additional Tasks, слайд №3 7. Java databases and JDBC 3. JDBC Additional Tasks, слайд №4 7. Java databases and JDBC 3. JDBC Additional Tasks, слайд №5 7. Java databases and JDBC 3. JDBC Additional Tasks, слайд №6 7. Java databases and JDBC 3. JDBC Additional Tasks, слайд №7 7. Java databases and JDBC 3. JDBC Additional Tasks, слайд №8 7. Java databases and JDBC 3. JDBC Additional Tasks, слайд №9 7. Java databases and JDBC 3. JDBC Additional Tasks, слайд №10 7. Java databases and JDBC 3. JDBC Additional Tasks, слайд №11 7. Java databases and JDBC 3. JDBC Additional Tasks, слайд №12 7. Java databases and JDBC 3. JDBC Additional Tasks, слайд №13 7. Java databases and JDBC 3. JDBC Additional Tasks, слайд №14 7. Java databases and JDBC 3. JDBC Additional Tasks, слайд №15 7. Java databases and JDBC 3. JDBC Additional Tasks, слайд №16 7. Java databases and JDBC 3. JDBC Additional Tasks, слайд №17 7. Java databases and JDBC 3. JDBC Additional Tasks, слайд №18 7. Java databases and JDBC 3. JDBC Additional Tasks, слайд №19 7. Java databases and JDBC 3. JDBC Additional Tasks, слайд №20 7. Java databases and JDBC 3. JDBC Additional Tasks, слайд №21 7. Java databases and JDBC 3. JDBC Additional Tasks, слайд №22 7. Java databases and JDBC 3. JDBC Additional Tasks, слайд №23 7. Java databases and JDBC 3. JDBC Additional Tasks, слайд №24 7. Java databases and JDBC 3. JDBC Additional Tasks, слайд №25

Вы можете ознакомиться и скачать презентацию на тему 7. Java databases and JDBC 3. JDBC Additional Tasks. Доклад-сообщение содержит 25 слайдов. Презентации для любого класса можно скачать бесплатно. Если материал и наш сайт презентаций Mypresentation Вам понравились – поделитесь им с друзьями с помощью социальных кнопок и добавьте в закладки в своем браузере.

Слайды и текст этой презентации


Слайд 1


7. Databases and JDBC 3. JDBC Additional Tasks
Описание слайда:
7. Databases and JDBC 3. JDBC Additional Tasks

Слайд 2


1. Pay List You should create a pay list for merchants accordingly their parameters: period of payment and minimal payment sum Please, create a DB...
Описание слайда:
1. Pay List You should create a pay list for merchants accordingly their parameters: period of payment and minimal payment sum Please, create a DB table for saving pay list

Слайд 3


1. Pay List – DB Structure create table transMoney ( id int not null generated always as identity, merchantId int constraint merchmoney_fk references...
Описание слайда:
1. Pay List – DB Structure create table transMoney ( id int not null generated always as identity, merchantId int constraint merchmoney_fk references merchant, sumSent decimal(19,2), sentDate timestamp, status char(1), primary key (id) );

Слайд 4


1. Pay List – periodEnum public enum periodEnum {UNKNOWN, WEEKLY, TENDAYS, MONTHLY};
Описание слайда:
1. Pay List – periodEnum public enum periodEnum {UNKNOWN, WEEKLY, TENDAYS, MONTHLY};

Слайд 5


1. Pay List – getMerchantInfo Method public ArrayList getMerchantInfo(Connection conn) throws SQLException{ Statement stmt = conn.createStatement();...
Описание слайда:
1. Pay List – getMerchantInfo Method public ArrayList getMerchantInfo(Connection conn) throws SQLException{ Statement stmt = conn.createStatement(); ArrayList list = new ArrayList(); String sql = "select id, period, needToSend, lastSent, minSum from merchant"; ResultSet rs = stmt.executeQuery(sql);

Слайд 6


1. Pay List – MerchantInfo Inner Class class MerchantInfo{ private int id; private java.sql.Date lastSent; private double sum; private periodEnum...
Описание слайда:
1. Pay List – MerchantInfo Inner Class class MerchantInfo{ private int id; private java.sql.Date lastSent; private double sum; private periodEnum period; private double minSum; public MerchantInfo(){} // accessors }

Слайд 7


1. Pay List – getMerchantInfo Method while (rs.next()){ MerchantInfo info = new MerchantInfo(); info.setId(rs.getInt("id"));...
Описание слайда:
1. Pay List – getMerchantInfo Method while (rs.next()){ MerchantInfo info = new MerchantInfo(); info.setId(rs.getInt("id")); info.setLastSent(rs.getDate("lastSent")); info.setPeriod(periodEnum.values()[rs.getInt("period")]); info.setSum(rs.getDouble("needToSend")); info.setMinSum(rs.getDouble("minSum")); list.add(info); } return list; }

Слайд 8


1. Pay List – filterList Method public ArrayList filterList(ArrayList list){ ArrayList listRet = new ArrayList(); for (MerchantInfo info: list){ if...
Описание слайда:
1. Pay List – filterList Method public ArrayList filterList(ArrayList list){ ArrayList listRet = new ArrayList(); for (MerchantInfo info: list){ if (info.getMinSum() > info.getSum()) continue; Instant instant = Instant.ofEpochMilli(info.getLastSent().getTime()); LocalDate dt = LocalDateTime.ofInstant(instant, ZoneId.systemDefault()).toLocalDate(); LocalDate current = LocalDate.now();

Слайд 9


1. Pay List – filterList Method switch(info.getPeriod()){ case WEEKLY: if (dt.until(current, ChronoUnit.WEEKS) < 1) continue; break; case TENDAYS: if...
Описание слайда:
1. Pay List – filterList Method switch(info.getPeriod()){ case WEEKLY: if (dt.until(current, ChronoUnit.WEEKS) < 1) continue; break; case TENDAYS: if (dt.until(current, ChronoUnit.DAYS) < 10) continue; break; case MONTHLY: if (dt.until(current, ChronoUnit.MONTHS) < 1) continue; break;

Слайд 10


1. Pay List – filterList Method default: break; } listRet.add(info); } return listRet; }
Описание слайда:
1. Pay List – filterList Method default: break; } listRet.add(info); } return listRet; }

Слайд 11


1. Pay List – addToTrans Method public void addToTrans(Connection conn, ArrayList list) throws SQLException{ String sql = "INSERT INTO...
Описание слайда:
1. Pay List – addToTrans Method public void addToTrans(Connection conn, ArrayList list) throws SQLException{ String sql = "INSERT INTO transMoney(merchantId, sumSent, sentDate, status) values(?,?,?, '0')"; PreparedStatement stmt = conn.prepareStatement(sql); for(MerchantInfo info: list){ stmt.setInt(1, info.getId()); stmt.setDouble(2, info.getSum()); java.sql.Timestamp dt = new java.sql.Timestamp(new java.util.Date().getTime()); stmt.setTimestamp(3, dt); stmt.executeUpdate(); }}

Слайд 12


1. Pay List – main Method public static void main(String[] args) { try{ Connection conn = getConnection(); TransMoney t = new TransMoney(); ArrayList...
Описание слайда:
1. Pay List – main Method public static void main(String[] args) { try{ Connection conn = getConnection(); TransMoney t = new TransMoney(); ArrayList list = t.getMerchantInfo(conn); list = t.filterList(list); t.addToTrans(conn, list); conn.close(); } catch(Exception ex){ System.out.println("Error " + ex.getMessage()); }}

Слайд 13


1. Pay List See 729TransMoney project for the full text
Описание слайда:
1. Pay List See 729TransMoney project for the full text

Слайд 14


2. Money Transfer Create a method that gets an accessible transfer sum as a parameter and sends money to merchants accordingly to the pay list under...
Описание слайда:
2. Money Transfer Create a method that gets an accessible transfer sum as a parameter and sends money to merchants accordingly to the pay list under condition that general transfer sum should not grater then accessible transfer sum.

Слайд 15


2. Money Transfer – transMoney Table create table transMoney ( id int not null generated always as identity, merchantId int constraint merchmoney_fk...
Описание слайда:
2. Money Transfer – transMoney Table create table transMoney ( id int not null generated always as identity, merchantId int constraint merchmoney_fk references merchant, sumSent decimal(19,2), sentDate timestamp, status char(1), primary key (id) );

Слайд 16


TransferInfo Inner Class class TransferInfo{ private int id; private int merchantId; private double sumSent; private java.sql.Date sentDate; private...
Описание слайда:
TransferInfo Inner Class class TransferInfo{ private int id; private int merchantId; private double sumSent; private java.sql.Date sentDate; private String status; public TransferInfo(){} // accessors }

Слайд 17


2. Money Transfer - getUnpayed public ArrayList getUnpayed(Connection conn) throws SQLException{ Statement stmt = conn.createStatement(); ArrayList...
Описание слайда:
2. Money Transfer - getUnpayed public ArrayList getUnpayed(Connection conn) throws SQLException{ Statement stmt = conn.createStatement(); ArrayList list = new ArrayList(); String sql = "select id, merchantId, sumSent, sentDate, status from transMoney where status='0' order by sentDate, sumSent"; ResultSet rs = stmt.executeQuery(sql);

Слайд 18


2. Money Transfer - getUnpayed while (rs.next()){ TransferInfo info = new TransferInfo(); info.setId(rs.getInt("id"));...
Описание слайда:
2. Money Transfer - getUnpayed while (rs.next()){ TransferInfo info = new TransferInfo(); info.setId(rs.getInt("id")); info.setMerchantId(rs.getInt("merchantId")); info.setSumSent(rs.getDouble("sumSent")); info.setSentDate(rs.getDate("sentDate")); info.setStatus(rs.getString("status")); list.add(info); } return list; }

Слайд 19


2. Money Transfer - procUnpayed public void procUnpayed(Connection conn, ArrayList list, double sum) throws SQLException{ double sentSum = 0.0;...
Описание слайда:
2. Money Transfer - procUnpayed public void procUnpayed(Connection conn, ArrayList list, double sum) throws SQLException{ double sentSum = 0.0; for(TransferInfo info: list){ if (sentSum + info.getSumSent() > sum) continue; sentSum += info.getSumSent(); try{ conn.setAutoCommit(false); sendPayment(conn, info); updateMerchant(conn, info); conn.commit();

Слайд 20


2. Money Transfer - procUnpayed } catch (Exception ex){ ex.printStackTrace(); conn.rollback(); } } }
Описание слайда:
2. Money Transfer - procUnpayed } catch (Exception ex){ ex.printStackTrace(); conn.rollback(); } } }

Слайд 21


2. Money Transfer - sendPayment public void sendPayment(Connection conn, TransferInfo info) throws SQLException{ String sql = "UPDATE transMoney...
Описание слайда:
2. Money Transfer - sendPayment public void sendPayment(Connection conn, TransferInfo info) throws SQLException{ String sql = "UPDATE transMoney set sentDate=?, status='1' where id=?"; PreparedStatement stmt = conn.prepareStatement(sql); java.sql.Timestamp dt = new java.sql.Timestamp(new java.util.Date().getTime()); stmt.setTimestamp(1, dt); stmt.setInt(2, info.getId()); stmt.executeUpdate(); }

Слайд 22


2. Money Transfer - updateMerchant public void updateMerchant(Connection conn, TransferInfo info) throws SQLException{ String sql = "SELECT...
Описание слайда:
2. Money Transfer - updateMerchant public void updateMerchant(Connection conn, TransferInfo info) throws SQLException{ String sql = "SELECT needToSend, sent FROM merchant where id=?"; PreparedStatement stmtRead = conn.prepareStatement(sql); stmtRead.setInt(1, info.getMerchantId()); ResultSet rs = stmtRead.executeQuery(); rs.next(); double needToSend = rs.getDouble("needToSend"); double sent = rs.getDouble("sent");

Слайд 23


2. Money Transfer - updateMerchant sql = "UPDATE merchant set lastSent=?, needToSend=?, sent=? where id=?"; PreparedStatement stmt =...
Описание слайда:
2. Money Transfer - updateMerchant sql = "UPDATE merchant set lastSent=?, needToSend=?, sent=? where id=?"; PreparedStatement stmt = conn.prepareStatement(sql); java.sql.Timestamp dt = new java.sql.Timestamp(new java.util.Date().getTime()); stmt.setTimestamp(1, dt); stmt.setDouble(2, needToSend - info.getSumSent()); stmt.setDouble(3, sent + info.getSumSent()); stmt.setInt(4, info.merchantId); stmt.executeUpdate(); }

Слайд 24


2. Money Transfer - main public static void main(String[] args) throws SQLException{ Connection conn = null; try{ double sum1 =...
Описание слайда:
2. Money Transfer - main public static void main(String[] args) throws SQLException{ Connection conn = null; try{ double sum1 = Double.valueOf(args[0]); conn = getConnection(); MainTrans t = new MainTrans(); ArrayList list = t.getUnpayed(conn); t.procUnpayed(conn, list, sum1); }

Слайд 25


2. Money Transfer - main catch(SQLException ex){ System.out.println("Error " + ex.getMessage()); } catch(Exception ex){...
Описание слайда:
2. Money Transfer - main catch(SQLException ex){ System.out.println("Error " + ex.getMessage()); } catch(Exception ex){ System.out.println("Error " + ex.getMessage()); } finally{ if (conn!= null) conn.close(); } } See 729aTransMoney project for the full text



Похожие презентации
Mypresentation.ru
Загрузить презентацию