在管理工具里面有数据源 选择sql数据源
在代码中:
<%@page contentType="text/html" pageEncoding="UTF-8"%>
<%@page import="java.sql.*"%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>JSP Page</title>
</head>
<body>
<%
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc:odbc:Ybz");
Statement stat=con.createStatement();
ResultSet rs=stat.executeQuery("select * from [case] ");
//或者
// PreparedStatement pstat=con.prepareStatement("select * from 数据库表的名称 where ID=?");
// pstat.setString(1,值);
// ResultSet rs=pstat.executeQuery();
%>
<table border="1">
<%
while(rs.next())
{
%>
<tr>
<td>
<%=rs.getString(1)%>
</td>
</tr>
<%}%>
</table>
</body>
</html>