jsp文件访问sqlserver数据库

这是一个数据库表格，内容如下，接下来我们通过jsp范访问它。

1、把sqlserver的驱动包放到tomcat安装目录下的lib文件夹中：

2、sqlserver.jsp

<%@ page pageEncoding="UTF-8"%>
<%@ page import="java.sql.*"%>
<script type="text/javascript">
	function changeColor(obj,color){
		obj.bgColor = color;
	}
</script>
<%!//驱动路径
	public static final String DBDRIVER = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
	//数据库地址,;DataBaseName=CreditorAutomation可以不写
	public static final String DBURL = "jdbc:sqlserver://127.0.0.1";
	//数据库登录用户名
	public static final String DBUSER = "sa";
	//数据库用户密码
	public static final String DBPASSWORD = "******";
%>

<%//编写程序语句
	//数据库连接
	Connection conn = null;
	//数据库操作
	PreparedStatement stmt = null;
	//数据库查询结果集
    ResultSet rs = null;
%>

<%
	//加载驱动程序
	Class.forName(DBDRIVER);
	//连接数据库
	conn = DriverManager.getConnection(DBURL, DBUSER, DBPASSWORD);
	stmt = conn.prepareStatement("select * from aaa_MyTest.dbo.banji");
	rs = stmt.executeQuery();
%>
<table border="1" cellpadding="5" cleespacing="0" bgcolor="#F2F2F2">
	<tr onmousemove="changeColor(this,'#FFFFFF')" onmouseout="changeColor(this,'#F2F2F2')">
		<td><strong>班级id</strong></td>
		<td><strong>班级人数</strong></td>
		<td><strong>班级名称</strong></td>
	</tr>
	<%
		while(rs.next()){
			String banji_id = rs.getString(1);
			String banji_num = rs.getString(2);
			String banji_name = rs.getString(3);
	%>
	<tr onmousemove="changeColor(this,'#FFFFFF')" onmouseout="changeColor(this,'#F2F2F2')">
		<td><%=banji_id%></td>
		<td><%=banji_num%></td>
		<td><%=banji_name%></td>
	</tr>
	<%
		}
	%>
</table>
<%//数据库必须关闭
	conn.close();
%>

3、效果如下：