Jsp 访问SQLsever2008R2

<%@ 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>

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值