请问如何jsp如何连接SQL server数据库,要用到哪些工具

tomcat，sqlserver的jdbc驱动程序：JSP 连数据库SQLServer2000<%@page contentType="text/html;charset=gb2312"%> 
<% 
//声名 
java.sql.Connection sqlConn; 
java.sql.Statement sqlStmt; 
java.sql.ResultSet sqlRst; 
//regiester jdbc driver 
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance(); 
//connect to the database 
sqlConn=java.sql.DriverManager.getConnection("jdbc:microsoft:sqlserver://192.168.0.2:1433;DatabaseName=pubs;SelectMethod=direct","dxxx","");
//create the driver handle 
sqlStmt=sqlConn.createStatement(java.sql.ResultSet.TYPE_SCROLL_INSENSITIVE,java.sql.ResultSet.CONCUR_READ_ONLY); 
//excute sql 
sqlRst=sqlStmt.executeQuery("select title_id,title,type from titles"); 
%> 
<html> 
<head> 
<title>Linux-JSP-JDBC-MYSQL TESTING -SELETCT copyright [email protected] </title> 
</head> 
<body> 
<table border="1" cellspace ="0" align="center"> 
<tr> 
<th>title </th> 
<th>type </th> 
</tr> 
<% while(sqlRst.next()) {%> 
<tr> 
<td> <%=sqlRst.getString(1)%></td> 
<td><%=sqlRst.getString(2)%></td> 
</tr> 
<%}%> 
</table> 
</body> 
</html> 
<% 
sqlRst.close(); 
sqlStmt.close(); 
sqlConn.close(); 
%>