<%@ page language="java" contentType="text/html; charset=utf-8" pageEncoding="utf-8"%>
<%@ 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=utf-8">
<title>Insert title here</title>
</head>
<body>
<%
PreparedStatement ps = null;
Connection ct = null;
ResultSet rs = null;
String url = "jdbc:sqlserver://localhost:1433;databaseName=test";
String user="sa"; //Super administrator
String password="sa"; //password
Try {
//1. Load the driver
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
System.out.println("Load driver succeeded!");
}catch(Exception e) {
e.printStackTrace();
System.out.println("Load driver failed!");
}
Try {
//2. Connection
Ct=DriverManager.getConnection( url,user,password);
System.out.println("Connecting the database successfully!");
}catch(Exception e) {
e.printStackTrace();
System.out.println("Failed to connect to the database!");
}
%>
</body>
</html>
JSP database connection succeeded
Start building with 50+ products and up to 12 months usage for Elastic Compute Service
1 on 1 presale consultation
24/7 Technical Support 6 Free Tickets per Quarter Faster Response
Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.
A comprehensive suite of global cloud computing services to power your business
Payment Methods We Support
