2015 第七章-嵌入式编程.pptVIP

* * * * * Copyright ? 1997 Alex Chaffee Type getType(int columnIndex) returns the given field as the given type E.g., int getInt(5); string getString(3); fields indexed starting at 1 (not 0) Type getType(String columnName) same, but uses name of field less efficient int findColumn(String columnName) looks up column index given column name Getting Values from Rows Copyright ? 1997 Alex Chaffee isNull In SQL, NULL means the field is empty Not the same as 0 or “” In JDBC, you must explicitly ask if a field is null by calling ResultSet.isNull(column) Copyright ? 1997 Alex Chaffee Mapping Java Types to SQL Types SQL type Java Type CHAR, VARCHAR, LONGVARCHAR String NUMERIC, DECIMAL java.math.BigDecimal BIT boolean TINYINT byte SMALLINT short INTEGER int BIGINT long REAL float FLOAT, DOUBLE double BINARY, VARBINARY, LONGVARBINARY byte[] DATE java.sql.Date TIME java.sql.Time TIMESTAMP java.sql.Timestamp Copyright ? 1997 Alex Chaffee Database Time Times in SQL are nonstandard Java defines three classes to help java.sql.Date year, month, day java.sql.Time hours, minutes, seconds java.sql.Timestamp year, month, day, hours, minutes, seconds, nanoseconds usually use this one * Optimized Statements Prepared Statements SQL calls that you make again and again allows driver to optimize (compile) queries created with Connection.prepareStatement() Stored Procedures written in DB-specific language stored inside database accessed with Connection.prepareCall() * Prepared Statement Example PreparedStatement updateSales; String updateString = update COFFEES + set SALES = ? where COF_NAME like ?; updateSales = con.prepareStatement(updateString); int [] salesForWeek = {175, 150, 60, 155, 90}; String [] coffees = {Colombian, French_Roast, Espresso,Colombian_Decaf,French_Roast_Decaf}; int len = coffees.length; for(int i = 0; i len; i++) { updateSales.setInt(1, salesForWeek[i]); updateSales.setString(2, coffees[i]); updateSales.executeUpdate(); } Copyright ? 1997 Alex Chaffee JDBC