Home > Developer > JSP

JDBC-ODBC bridge to access SQL Server2000 Database (jdk1.6 + JSP + Tomcat 5.5.20)

Source: Internet
Author: User
Developer on Alibaba Coud: Build your first app with APIs, SDKs, and tutorials on the Alibaba Cloud. Read more ＞
JDBC-ODBC bridge to access the SQL Server2000 Database, and JDBC driver implementation has many similarities, the difference is that the need to configure the data source, but does not need JDBC driver.

Create an SQL Server 2000 database

Start SQL Server 2000 Database Service Manager:

Open the Enterprise Manager, create a database, sky2098, and create a table, student, in the database ,:

Configure the data source

Select the data source configuration options as shown in:

Note that my system is Windows Server 2003. You only need to find this option to configure the data source. Then, the following window is displayed:

Select the system DSN tab. Otherwise, the connection may fail. Click Add:

Select "SQL Server" near the last position in the list box, and click "finish:

Enter the name of the data source you want to configure in the "name" location, and select local in the "server" location. You can select it based on the actual situation, and then click the "Next" button:

Here, you can set logon authentication. There are two options. Here, I select the SQL Server Logon account and click the "Next" button:

If the logon name and password of the SQL Server account are incorrect in the previous step, a message indicating a failure is displayed. For convenience, you can use the first Windows NT authentication.

Because I have created the table student in the database sky2098, I chose the database sky2098 as the default database and click the "Next" button:

In this step, follow the default configuration and click "finish:

The configuration information of the data source is displayed. Next, test the configured data source and click "Test Data Source:

The successful data source test information is displayed. Click OK to complete the data source configuration process.

Implement database access programs and other configurations

The directory hierarchy is as follows:

Relatively simple.

Below is the JSP file we tested to access the database, my named jdbc-odbc-student.jsp, the Code is as follows:

 

<%... @ Page contenttype = "text/html; charset = gb2312" Language = "Java" Import = "Java. SQL. *, java. Io. *" %>
<HTML>
<Body>
<Center>
<H1> student admission Information <HR>
<Table border = 1>
<Tr> <TD> Student ID </TD> <TD> name </TD> <TD> age </TD> <TD> from </TD> <TD> school </TD> <TD> major </TD> <TD> score </TD> </tr>
<%...
Class. forname ("Sun. JDBC. ODBC. jdbcodbcdriver ");
Connection con = drivermanager. getconnection ("JDBC: ODBC: sqlstudent", "sa", "sky2098"); // sqlstudent is the name of the data source we configured.
Statement stmt = con. createstatement ();
Resultset rs1_stmt.exe cutequery ("select * from student ");
While (Rs. Next ())
{
Out. println ("<tr> ");
Out. println ("<TD>" + Rs. getint ("num") + "</TD> ");
Out. println ("<TD>" + Rs. getstring ("name") + "</TD> ");
Out. println ("<TD>" + Rs. getint ("Age") + "</TD> ");
Out. println ("<TD>" + Rs. getstring ("fromw") + "</TD> ");
Out. println ("<TD>" + Rs. getstring ("school") + "</TD> ");
Out. println ("<TD>" + Rs. getstring ("Major") + "</TD> ");
Out. println ("<TD>" + Rs. getint ("score") + "</TD> ");
Out. println ("</tr> ");
Out. println ("</tr> ");
}
Rs. Close ();
Stmt. Close ();
Con. Close ();
%>
</Table>
</Body>
</Html>

Start Tomcat web server

To do the above work, you can start the Web Server ,:

Open IE and enter the hyperlink address:

Http: // localhost: 8080/sqlserver/jdbc-odbc-student.jsp

To access the SQL Server 2000 database ,:

So far, the realization of JDBC-ODBC Bridge access SQL Server2000 Database function.

This article is an English version of an article which is originally in the Chinese language on aliyun.com and is provided for information purposes only. This website makes no representation or warranty of any kind, either expressed or implied, as to the accuracy, completeness ownership or reliability of the article or any translations thereof. If you have any concerns or complaints relating to the article, please send an email, providing a detailed description of the concern or complaint, to info-contact@alibabacloud.com. A staff member will contact you within 5 working days. Once verified, infringing content will be removed immediately.

Related Keywords:
odbc jdbc bridge odbc jdbc bridge driver odbc connection to access database how to access sql database export sql database to access jsp upload file to database export sql to access database
Related Article
Set the html/jsp edit automatic prompt in MyEclipse 9/10 __html
JSP (6)--JSP declaration
Springboot load JSP refresh JSP, refresh controller (try it Y...
A simple calculator for JSP exercises (using Jsp+javabean mode)
Use absolute path $ {pagecontext. Request. contextpath} in JSP}

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

What's Trending
Top 10 Tags
datastax versions naming convention zookeeper client class definition md5 microsoft sql server 2005 data structures exception handling error handling
Top 10 Keywords
microsoft download center down wordpress address url site address url wordpress address url windows installer 4 0 download 302 not found web address url definition site address url wordpress db2 integer mac os installation step by step pdf abbreviation for return

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

Get Started for Free

  • Sales Support

    1 on 1 presale consultation

    Chat Contact Sales

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

    Open a Ticket

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.

    Learn More