以前在寫應用程式時，有過通過jdbc串連mysql成功的經驗。
在用JSP編寫的網頁中是否可以通過同樣的代碼串連mysql呢？
結果是否定的，我將相同的代碼複製到檔案中時，出現錯誤。
於是百度發威，搜到一篇相關的文章。經研究，其實只需稍作改動。
將原來的驅動管理器改為：
Class.forName("org.gjt.mm.mysql.Driver");
以下的代碼可以作為參考：
<html>
<head><title>helloworld.jsp</title></head>
<body>
<%@ page language="java" import="java.sql.*" %>
<%
try{
Class.forName("org.gjt.mm.mysql.Driver");
out.println("Success loading Mysql Driver!");
}
catch(Exception e)
{
out.print("Error loading Mysql Driver!");
e.printStackTrace();
}
try{
Connection connect=DriverManager.getConnection("jdbc:mysql://localhost/jdbctest","userid","password");
out.print("Success connect Mysql server!");
Statement stmt = connect.createStatement();
ResultSet rs=stmt.executeQuery("select * from employees");
while(rs.next())
{
out.println(rs.getInt(1));
out.println(rs.getString(2));
out.println(rs.getInt(3));
out.println(rs.getInt(4));
}
}
catch(Exception e)
{
out.print("get data error!");
e.printStackTrace();
}
%>
</body></html>
注意：mysql的JDBC驅動的下載可以參考我以前的文章
下載後將jar檔案複製到tomcat安裝目錄下的common/lib下（我用的是tomcat的伺服器，其他類型的伺服器我沒有作研究）。
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
