Using JDBC in JSP to access SQL Server 2008 Database Sample _JSP programming

Direct access to database by JDBC driver
Advantages: 100% Java, Fast and Cross-platform
Disadvantage: Access to different databases requires the download of a dedicated JDBC driver

(1) Download the corresponding database version of the JDBC driver and installation, attention to the installation of the resulting three file Msbase.jar,mssqlserver.jar,msutil.jar, copy it to the JSP project under the Web-inf/lib, Also copied to the Tomcat installation directory under LIB, no specific tests should be related to the configuration file.

(2) Data source, do not need

(3) configuration file, do not need

(4) Write JSP file test

<%@ page contenttype= "text/html; charset=gb2312 "language=" java import= "java.sql.*,java.io.*"%>