1、确认SQL开启1433端口(sql2000 需SP4补丁)
2、准备msbase.jar/mssqlserver.jar/msutil.jar驱动、并复制到tomcat安装目录\Lib目录下重启机器
3、JSP代码如下
<%@page language="java" import="java.util.*" import="java.sql.*" pageEncoding="gb2312" %>
<!DOCTYPE html>
<html>
<head>
<title>JSP连接SQL Server数据库示例</title>
</head>
<body>
<%!
public static final String DBDRIVER ="com.microsoft.jdbc.sqlserver.SQLServerDriver";
public static final String DBURL = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=senyuan";
public static final String DBUSER ="sa";
public static final String DBPASS = "123456";
%>
<%
Connection conn = null; //声明数据库连接对象
PreparedStatement pstmt=null; //声明数据库操作
ResultSet rs=null; //声明操作结果集
%>
<%
try{ //检测异常
Class.forName(DBDRIVER);
conn = DriverManager.getConnection(DBURL,DBUSER,DBPASS);
String sql="select * from myinfo";
pstmt=conn.prepareStatement(sql); //实例化
rs=pstmt.executeQuery(); //执行
%>
<center>JSP连接SQL Server数据库示例
<table width="500" border="0" cellspacing="1" cellpadding="0" bgcolor="#0099FF">
<tr>
<td height="28" align="center" valign="middle" bgcolor="#FFFFFF"><strong>序号</strong></td>
<td align="center" bgcolor="#FFFFFF"><strong>姓名</strong></td>
<td align="center" bgcolor="#FFFFFF"><strong>年龄</strong></td>
</tr>
<%
while(rs.next()){
int empno=rs.getInt(1); //Get number
String empname=rs.getString(2); //Get name
int empage=rs.getInt(3); //Get age
%>
<tr>
<td height="28" align="center" valign="middle" bgcolor="#FFFFFF"><%=empno %></td>
<td align="center" valign="middle" bgcolor="#FFFFFF"><%=empname %></td>
<td align="center" valign="middle" bgcolor="#FFFFFF"><%=empage %></td>
</tr>
<%
} //End While
%>
</table>
</center>
<%
}catch(Exception e){
out.println(e); //Print Exception
}finally{
rs.close(); //关闭结果集
pstmt.close(); //关闭操作
conn.close(); //关闭数据库连接
}
%>
</body>
</html>
注:
myinfo表字段如下
Id int(4)
xm varchar(20)
age int(3)
转载于:https://blog.51cto.com/im9527/1288622