[教育学]6AdvancedJDBC.ppt

© Anthony J H Simons, University of Sheffield 2012 Java E-Commerce Part 6: Database Management in Java http://staffwww.dcs.shef.ac.uk/people/A.Simons/ Home  Teaching  Lectures  COM4514/COM6514 © Anthony J H Simons, University of Sheffield 2012 2 Bibliography Database Systems T Connolly and C Begg, Database Systems – a Practical Approach to Design, Implementation and Management, 5th ed., Addison Wesley, 2009. C J Date, An Introduction to Database Systems, 8th ed., Addison Wesley, 2004. MySQL and Java T King, G Reese, R Yarger, MySQL and mSQL, O’Reilly, 1999. G Reese, Programming with JDBC and Java, 2nd ed., O’Reilly, 2000. as usual, age-related health-warnings apply Advanced JDBC Access metadata Prepared statements Batch processing Transactions Concurrency control Connection pooling © Anthony J H Simons, University of Sheffield 2012 3 Access Table Metadata When you don’t know how many columns When you don’t know the names of columns To find out other properties of columns © Anthony J H Simons, University of Sheffield 2012 4 ResultSet res = stmt.executeQuery(“SELECT * FROM lecturer”); ResultSetMetaData rsmd = res.getMetaData();int columns = rsmd.getColumnCount(); // 3String label3 = rsmd.getColumnLabel(3); // “office”boolean auto = rsmd.isAutoIncrement(1); // trueboolean searchable = rsmd.isSearchable(2); // trueString table = rsmd.getTableName(); // “lecturer”… Access Database Metadata When you don’t know what concurrency support there is When you don’t know what transaction support there is © Anthony J H Simons, University of Sheffield 2012 5 DatabaseMetaData dbmd = con.getMetaData(); boolean hasTransactions = dbmd.supportsTransactions(); boolean isSerializable = dbmd.supportsTransactionIsolationLevel( Connection.TRANSACTION_SERIALIZABLE); boolean hasUpdatableResults = dbmd.supportsResultSetConcurrency( ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_UPDATABLE); Prepared Statements For common queries with similar patterns To speed