一、環境配置
首先將驅動加入 classpath 。
1、串連 mysql 時的驅動儲存位置：
驅動名：mysql-connector-java-3.1.5-gamma-bin.jar
路徑：tomcat5.5/common/lib
重啟 Tomcat 後生效。
2、串連 Oracle 時驅動儲存位置：
驅動名：classes12.jar
路徑：tomcat5.5/common/lib
重啟 Tomcat 後生效。
二、測試代碼
<!--mysql.jsp-->
<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%>
<html>
<body>
<%
Class.forName("org.gjt.mm.mysql.Driver").newInstance();
String url ="jdbc:mysql://localhost/db_name?user=yourusername&password=yourpassword&useUnicode=true&characterEncoding=GB2312" ;
Connection conn= DriverManager.getConnection(url);
Statement stmt=conn.createStatement();
String query="select field_name from table_name order by id";
ResultSet rs=stmt.executeQuery(query);
while(rs.next())
{
String s=rs.getString("field_name");//看準你的欄位是不是字元型，不然就不能用getString,根據欄位類使用getBoolean等等
out.print(s+"<br>");
}
%>
</body>
</html>
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
