java连接数据库

数据源的建立请参看，服务器类文章
<%-- jstl 连接数据库 --%>
include.inc
<sql:setDataSource var="ds" dataSource="jdbc/t"/>

jsp文件：
<%@ taglib uri="/WEB-INF/c.tld" prefix="c" %>
<%@ taglib uri="/WEB-INF/sql.tld" prefix="sql" %>
<%@ include file="include.inc"%>

<sql:query var="query" dataSource="${ds}">
 select * from orders 
</sql:query>

<c:forEach var = "row" items="${query.rows}">
 ${row.orderid}<br />
</c:forEach>

 

<%-- @ page import="javax.naming.*,javax.sql.*,java.sql.*" %>
<%
 try{
   //jdbc 获得数据据连接
   Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
   Connection conn = DriverManager.getConnection("jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=Northwind", "sa", "0");
  //JNDI 获得数据据连接
  /*InitialContext ctx = new InitialContext();
  DataSource ds = (DataSource)ctx.lookup("java:comp/env/jdbc/t");
  Connection conn = ds.getConnection();*/
  String sql = "select * from orders";
  PreparedStatement ps = conn.prepareStatement(sql);
  ResultSet rs = ps.executeQuery();
  ResultSetMetaData rsmd = rs.getMetaData();
  
  out.println("<table>");
  for( ; rs.next(); ){
   out.println("<tr>");
   for(int i = 1; i <= rsmd.getColumnCount(); i ++){
    out.println("<td>" + rs.getString(i) + "</td>");    
   }
   out.println("</tr>");
  }
  out.println("</table>");
 }catch(Exception e){
  e.printStackTrace();
 }
 --%>