Download, install the SQLServer 2000 for JDBC driver:
Quote page http://www.microsoft.com/china/sql/downloads/2000/jdbc.asp
Put the directory:
C: / Program Files / Microsoft SQL Server 2000 Driver for JDBC / LIB
The three JAR package copies to the directory:
K: / Tomcat / Shared / LIB
Create a database:
Use master
Go
Create Database [MyData] ON (Name = N'MYDATA_1 ', filename = n'k: /sqlserver/mydata/mydata_1.mdf', size = 5, MaxSize = 20, FileGrowth = 5), (Name = N'MYDATA_2 ' , Filename = n'k: /sqlserver/mydata/mydata_2.ndf ', size = 5, maxsize = 20, fileGrowth = 5) log on (name = n'myData_log1', filename = n'k: / sqlserver / mydata / MyData_log1.ldf ', size = 5, MaxSize = 20, FileGrowth = 5), (Name = N'MyData_Log2', filename = n'k: /sqlserver/mydata/mydata_log2.ldf ', size = 5, MaxSize = 20, Filegrowth = 5) Go
Create a table:
Use mydata
Create Table [User] ([Id] [INT] Identity (1, 1) Not Null, [Name] [VARCHAR] (20) Collate Chinese_PRC_CI_AS NULL, [Password] [varchar] (40) collate Chinese_prc_ci_as not null, [ Createtime] NULL, PRIMARY Key Clustered ([ID]) ON [PRIMARY]) ON [PRIMARY] GO
Insert record:
1 bitan bbbbbbbbbbbbbb 0x00000000000000CA2 Helen Hhhhhhhhh 0x00000000000000CB3 Susan sssssssss 0x00000000000000CC4 Kathy Kkkkkkkkkk 0x00000000000000CD
SQLServer.jsp
<% @ Page ContentType = "Text / HTML; Charset = GBK"%> <% @ page import = "java.sql. *"%> <% try {class.forname ("com.microsoft.jdbc.sqlser.sqlserverdriver ") .newinstance (); string url =" JDBC: Microsoft: SQLServer: // localhost: 1433; databasename = mydata "; connection conn = drivermanager.getConnection (URL," SA ","); string sql = "SELECT ID, Name, Password from users; statement stmt = conn.createstatement (); for (ResultSet RS = Stmt.executeQuery (SQL); rs.next ();) {Int ID = rs.Getint (1); string Name = rs.getstring (2); string password = rs.getstring (3); out.println ("id =" ID "Name =" Name "Password =" password ");"); }}} Catch (Exception E) {E.PrintStackTrace ();}%> Result:
Http: // localhost: 2000 / SQLSERVER1 / SQLSERVER.JSP
ID = 1 Name = Bitan password = bbbbbbbbbbbbbid = 2 name = helen password = HHHHHHHHHHHHHHID = 3 name = Susan password = sssssssssssiD = 4 name = kathy password = kkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkk
