標籤：body html w3c 管理 except tst getc man database
<%@ 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"; //超級管理員 String password="sa"; //密碼 try { //1.載入驅動 Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver"); System.out.println("載入驅動成功！"); }catch(Exception e) { e.printStackTrace(); System.out.println("載入驅動失敗！"); } try { //2.串連 ct=DriverManager.getConnection( url,user,password); System.out.println("串連資料庫成功！"); }catch(Exception e) { e.printStackTrace(); System.out.println("串連資料庫失敗！"); } %></body></html>
JSP資料庫連接成功
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
