jsp连接sql server

<%@ page language=“java” import=“java.util." pageEncoding=“UTF-8”%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"😕/"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<%@ page import="java.sql.”%>

<%

String URL = "jdbc:sqlserver://127.0.0.1:1433;databaseName=医药销售管理系统";
Connection con = null;
ResultSet rs=null;
Statement st=null;
try {
	Class.forNam`在这里插入代码片`e("com.microsoft.sqlserver.jdbc.SQLServerDriver");
	con = DriverManager.getConnection(URL, "sa", "12345678");
	st = con.createStatement();
	rs=st.executeQuery("select * from dbo.店长  where 店长姓名='张三'");
	if(rs.next())
	{
		out.print("连接成功<br/>");
		String name=rs.getString("店长姓名");
		out.print("姓名："+name);
	}
	else
		out.print("连接失败<br/>");
	

}catch(Exception e){
  			out.print(e);
  			
  }finally{
  		if(rs!=null)
			rs.close();
		if(st!=null)
			st.close();
		if(con!=null)
			con.close();
	}

%>

连接成功，页面显示如下：