db.jsp

对入学者很实用用JAVA的基本语言写的

<%@ page contentType="text/html; charset=UTF-8"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
<%@ taglib prefix="fmt" uri="http://java.sun.com/jsp/jstl/fmt"%>
<%@ taglib prefix="fn" uri="http://java.sun.com/jsp/jstl/functions"%>
<%@ taglib prefix="sql" uri="http://java.sun.com/jsp/jstl/sql"%>
<sql:setDataSource var="ds"
	driver="com.microsoft.sqlserver.jdbc.SQLServerDriver"
	url="jdbc:sqlserver://localhost:1433;databaseName=training"
	user="sa"
	password="sa" />
<sql:query var="resultList" dataSource="${ds}">
   SELECT * FROM USER_INFO ORDER BY USERID
</sql:query>
<c:set var="rows" scope="session" value="${resultList.rows}" />
<c:redirect url="list.jsp"></c:redirect>