Java Link SQL Server database

One, operand vs. asp

Object type	ado	Jdbc
Connection object	SqlConnection	Java.sql.Connection
Execution Object	SqlCommand	Java.sql.Statement
Precompiled execution Object		Java.sql.PreparedStatement
Stored procedure Execution Object	???	Java.sql.CallableStatement
Result set	SqlDataReader	Java.sql.ResultSet
Data set	DataSet	CachedRowSet

Ii. Link Database

2.1 Adding drivers

Class.forName ("Com.microsoft.sqlserver.jdbc.SQLServerDriver");

2.2 Linked databases

String URL = "jdbc:sqlserver://database server address: port number; database= database name"

Connection con=drivermanager.getconnection (URL,UID,PWD);--Login login Password

Java Link SQL Server database