Recipes installation

Prepared Statement : compile only one time Statement : compile each time to run If we have to use one SQL statement several times, it would better to use Preparerd Statement. PreparedStatement java.sql.Connection.prepareStatement(String sql) throws SQLException Arguments : setting by parameters “?”

34p nguyenvanhabk1 04-09-2012 77 5   Download

[ Team LiB ] Recipe 10.13 Listing Installed OLE DB Providers Problem You need a list of the OLE DB providers installed on the machine running your code. Solution Use a SQL Server extended stored procedure or search the registry.

3p luvpro 04-08-2010 112 10   Download

[ Team LiB ] Recipe 10.16 Listing Installed ODBC Drivers Problem You need a list of the ODBC drivers installed on the computer running your code. Solution Consult the registry. The sample code uses the Microsoft.Win32.

2p luvpro 04-08-2010 78 6   Download