Connecting to SQL Server from Servlet

This chapter provides tutorial notes and example codes on connecting to SQL Server from Servlet pages. Topics include downloading and installing SQL Server JDBC driver JAR file; selecting JDBC driver version to match JVM version; testing JDBC connection in Servlet pages; loading JDBC class explicitly in Servlet code.

SQL Server Connection Requirements

Download and Install SQL Server JDBC Driver

Test SQL Server JDBC Driver

Use JDBC Driver in Servlet

Load JDBC Driver Class in Servlet

Conclusions:

Table of Contents

 About This Book

 JSP (JavaServer Pages) Overview

 Tomcat Installation on Windows Systems

 JSP Scripting Elements

 Java Servlet Introduction

 JSP Implicit Objects

 Syntax of JSP Pages and JSP Documents

 JSP Application Session

 Managing Cookies in JSP Pages

 JavaBean Objects and "useBean" Action Elements

 Managing HTTP Response Header Lines

 Non-ASCII Characters Support in JSP Pages

 Performance of JSP Pages

 EL (Expression Language)

 Overview of JSTL (JSP Standard Tag Libraries)

 JSTL Core Library

 JSP Custom Tags

 JSP Java Tag Interface

 Custom Tag Attributes

 Multiple Tags Working Together

 File Upload Test Application

 Using Tomcat on CentOS Systems

 Using Tomcat on macOS Systems

Connecting to SQL Server from Servlet

 Developing Web Applications with Servlet

 Archived Tutorials

 References

 Full Version in PDF/EPUB