Jsp 访问SQLsever2008R2

最新推荐文章于 2018-12-26 14:39:04 发布

贫嘴小李子的幸福生活

最新推荐文章于 2018-12-26 14:39:04 发布

阅读量1.7k

点赞数

分类专栏：工作足迹

本文链接：https://blog.csdn.net/u013491262/article/details/44240891

版权

工作足迹专栏收录该内容

148 篇文章 1 订阅

订阅专栏

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8" import="java.util.Date"%>
<%@ page import="java.sql.*"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>Insert title here</title>
</head>
<body>
                <%
			         String url = "jdbc:sqlserver://202.195.145.169:1368;databaseName=Student;user=sa;password=123456";//sa身份连接    
			         Connection con = null;    
			         Statement stmt = null;    
			         ResultSet rs = null;    
			     
			         try {  
			        	 Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver"); 
			             con = DriverManager.getConnection(url);       
			             String SQL = "SELECT * FROM Login";    
			             stmt = con.createStatement();    
			             rs = stmt.executeQuery(SQL);    
			             while (rs.next()) {    
			        %>    	 
			             <%=rs.getString("Name")%> <br/>
			        <%  
			            }    
			         }  
			         catch (Exception e) {    
			             e.printStackTrace();    
			         }    
			     
			         finally {    
			             if (rs != null)    
			                 try {    
			                     rs.close();    
			                 } catch (Exception e) {    
			                 }    
			             if (stmt != null)    
			                 try {    
			                     stmt.close();    
			                 } catch (Exception e) {    
			                 }    
			             if (con != null)    
			                 try {    
			                     con.close();    
			                 } catch (Exception e) {    
			                 }    
			         }       
             %>
</body>
</html>