Connect SQL Server successfully without ODBC

Odbc|server|sqlserver 1, first install JDBC, then copy the three files under Lib to the root of the Web page WEB_INF\LIB2, statement
<%@ page contenttype= "text/html; charset=gb2312 "language=" java "import=" java.sql.* "errorpage=" "%>"
<%
Connection Conn=null;
try{
Class.forName ("Com.microsoft.jdbc.sqlserver.SQLServerDriver"). newinstance ();
String url= "Jdbc:microsoft:sqlserver://localhost:1433;databasename=pubs";
String user= "SA";
String pwd= "";
Conn=drivermanager.getconnection (URL,USER,PWD);
}catch (SQLException e) {
Out.println (e);
}
Statement stmt=conn.createstatement ();
String sql= "SELECT * from Jobs";
ResultSet rs=stmt.executequery (SQL);
Out.println (rs.getstring (1));
%>
3. Note:
The IP address and database password need to be modified.
Be sure to succeed.