使用jdbc連接配接資料庫首先需下載下傳sqljdbc4.jar (點此下載下傳)
下載下傳後放入工程WEB-INF/lib目錄下并添加進工程庫:
![](https://img.laitimes.com/img/9ZDMuAjOiMmIsIjOiQnIsICdzFWRoRXdvN1LclHdpZXYyd2LcBzNvwVZ2x2bzNXak9CX90TQNNkRrFlQKBTSvwFbslmZvwFMwQzLcVmepNHdu9mZvwFVywUNMZTY18CX052bm9CX9sGROl3aU9UejpXTmZEWjZXUYpVd1kmYr50MZV3YyI2cKJDT29GRjBjUIF2LcRHelR3LcJzLctmch1mclRXY39DM5AjNxkTN2EzNxMDM3EDMy8CX0Vmbu4GZzNmLn9Gbi1yZtl2Lc9CX6MHc0RHaiojIsJye.jpg)
對jar檔案右鍵選擇:
或者如下操作
1.
2.
3.
jsp連接配接代碼:
/**注意加try-catch塊
<%@ page import="java.sql.*" %><%--
Created by IntelliJ IDEA.
User: Vove
Date: //
Time: :
To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
<title>SQl</title>
</head>
<body>
<%
String DB_Url="jdbc:sqlserver://localhost:1433;DataName=資料庫名";
String user="使用者名";//登陸資料庫
String password="密碼";
try {
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
Connection connection= null;
try {
connection = DriverManager.getConnection(DB_Url,user,password);
} catch (SQLException e) {
e.printStackTrace();
}
Statement statement= null;
try {
statement = connection.createStatement();
} catch (SQLException e) {
e.printStackTrace();
}
try {
statement.executeQuery("SELECT TOP 1000 [Username]\n" +
" ,[Password]\n" +
" ,[email]\n" +
" ,[register_date]\n" +
" FROM [Vove].[dbo].[User_im]");
} catch (SQLException e) {
e.printStackTrace();
}
ResultSet resultSet=statement.getResultSet();
while (resultSet.next()){
String username=resultSet.getString("Username");
String userpassword=resultSet.getString("password");
Date date=resultSet.getDate("register_date");
out.println(username+"\t"+userpassword+"\t"+date+"<br>");
}
%>
</body>
</html>
最後吐槽一下教科書上的Class.forName(“com.microsoft**.jdbc.sqlserver.**SQLServerDriver”);