SQL Server's application in Java

Server|sqlserver
I. Application of JDBC-ODBC Bridge

1. Building databases and tables in SQL Server

2. Create a data source]

(1) Start-> Settings-> Control Panel-> admin tools->odbc Data Source

(2) Click the Add button under the User DSN to eject the Create Newdatasource dialog box

(3) Select Sqlserver-> Complete

(4) Specifies that name is your data source name, server is the IP address of the host computer where the SQL Server is located, and if it is local, it can be localhost,127.0.0.1.

(5) Select With...............by User, set username and password

(6) Select Change the default database to:

Select the appropriate database in the Drop-down list

(7) Test DataSource (test data source), failed to return third step reconfiguration.

3. Example

(1) Create the XS database in SQL Server and create the XS table in the XS database with the following fields:

Name
Sex
Age

Cjp
Male
22


(2) Configure the data source according to the 2nd step above, named XS

(3) Code:

Import java.sql.*;//SQL Package



public class XS {

public static void Main (string[] args) throws exception{

Class.forName ("Sun.jdbc.odbc.JdbcOdbcDriver");//Load Driver

Connection con=drivermanager.getconnection ("Jdbc:odbc:xs");//Get data source and connect

Statement st=con.createstatement ();//Create statement



ResultSet result=st.executequery ("SELECT * from XS");/execute query, get data set in unit of behavior



while (Result.next ()) {//traverse each row

System.out.println (result.getstring (1));//Get the first column of the first row

System.out.println (result.getstring (2));//Get the second column of the first row

System.out.println (Result.getstring (3))//Get the third column of the first row

}



}

}



Results:

Cjp

Male

22