Results for "Author: jeff patterson"
Creates an object to read Microsoft Excel spreadsheets. This is a really easy way to get data out of a Microsoft Excel Spreadsheet. Methods allow for getting the data from a worksheet as a 2 diminsional String array or a specific column from a worksheet as a 1 diminsional String array. It really isn't that complex of code - there is a sample program included to show you exactly how to use it!! If you find this useful, then please VOTE for me at the bottom of this page!
This will teach you how to connect to a Microsoft Access database. It's also a great overview of JDBC. Once you are connected, you may run any SQL statement that is allowable on Access, such as SELECT, etc. You don't even have to have MS Access installed to run this tutorial - it shows you how to make a blank one without Access!
This JDBC Connection Pool is SELF REGULATING. That is, when you create the pool, you tell it how big to make itself. If, over time, you need more connections than you originally requested in the pool to be opened, the pool will build new ones. These extra connections, if left idle for more than a certain definable time, will be closed down by the pool to be nice to your database. You can access a report from your pool to find out how many connections are in it, how long they have been idle, which ones are being used, and what program is using the used connections. The code is VERY WELL javadoc'd, and it comes with two sample programs to show you exactly how to use it! Please download it and check it out - I'd love for you to rate my code!!
Creates an object to read Microsoft Excel spreadsheets. This is a really easy way to get data out of a Microsoft Excel Spreadsheet. Methods allow for getting the data from a worksheet as a 2 diminsional String array or a specific column from a worksheet as a 1 diminsional String array. It really isn't that complex of code - there is a sample program included to show you exactly how to use it!! If you find this useful, then please VOTE for me at the bottom of this page!
This will teach you how to connect to a Microsoft Access database. It's also a great overview of JDBC. Once you are connected, you may run any SQL statement that is allowable on Access, such as SELECT, etc. You don't even have to have MS Access installed to run this tutorial - it shows you how to make a blank one without Access!
This JDBC Connection Pool is SELF REGULATING. That is, when you create the pool, you tell it how big to make itself. If, over time, you need more connections than you originally requested in the pool to be opened, the pool will build new ones. These extra connections, if left idle for more than a certain definable time, will be closed down by the pool to be nice to your database. You can access a report from your pool to find out how many connections are in it, how long they have been idle, which ones are being used, and what program is using the used connections. The code is VERY WELL javadoc'd, and it comes with two sample programs to show you exactly how to use it! Please download it and check it out - I'd love for you to rate my code!!
Creates an object to read Microsoft Excel spreadsheets. This is a really easy way to get data out of a Microsoft Excel Spreadsheet. Methods allow for getting the data from a worksheet as a 2 diminsional String array or a specific column from a worksheet as a 1 diminsional String array. It really isn't that complex of code - there is a sample program included to show you exactly how to use it!! If you find this useful, then please VOTE for me at the bottom of this page!
This will teach you how to connect to a Microsoft Access database. It's also a great overview of JDBC. Once you are connected, you may run any SQL statement that is allowable on Access, such as SELECT, etc. You don't even have to have MS Access installed to run this tutorial - it shows you how to make a blank one without Access!
This JDBC Connection Pool is SELF REGULATING. That is, when you create the pool, you tell it how big to make itself. If, over time, you need more connections than you originally requested in the pool to be opened, the pool will build new ones. These extra connections, if left idle for more than a certain definable time, will be closed down by the pool to be nice to your database. You can access a report from your pool to find out how many connections are in it, how long they have been idle, which ones are being used, and what program is using the used connections. The code is VERY WELL javadoc'd, and it comes with two sample programs to show you exactly how to use it! Please download it and check it out - I'd love for you to rate my code!!
Creates an object to read Microsoft Excel spreadsheets. This is a really easy way to get data out of a Microsoft Excel Spreadsheet. Methods allow for getting the data from a worksheet as a 2 diminsional String array or a specific column from a worksheet as a 1 diminsional String array. It really isn't that complex of code - there is a sample program included to show you exactly how to use it!! If you find this useful, then please VOTE for me at the bottom of this page!