標籤：
1. 配置說明:
=> 編輯器: Eclipse (Java EE IDE)
=> 資料庫: MySQL (MySQL Workbench 進行資料庫管理, 用 MySQL Connector/J 串連)
=> 伺服器: Tomcat
2. Eclipse 是綠色版的, 不需要安裝, 可以裝一些外掛程式方便開發
3. Tomcat 需要配置環境變數, 也就是bin目錄, 裡面有各種平台下啟動和關閉等操作的指令碼.不要手動開啟, 否則在Eclipse啟動並執行時候可能會有連接埠衝突
4. Eclipse 在建立動態web網站的時候需要按指示將Tomcat伺服器添加進去即可
5. MySQL Connector/J 安裝後會在 C/Program File(/x86) 下面有一個 jar檔案, 匯入工程的build path即可. 否則import jdbc的 Driver的時候可能會報錯.
注意在安裝MySQL時設定好密碼, 以及預設的字型(選用了 utf-8 default collation)
模板代碼: (先在資料庫中建立相應的schema 和table)
<%@ page language="java" contentType="text/html; charset=utf-8" pageEncoding="utf-8"%><%@ page import="com.mysql.jdbc.Driver" %><%@ page import="java.sql.*" %><%//驅動程式名String driverName = "com.mysql.jdbc.Driver";//資料庫使用者名稱String uname = "root";//密碼String upassword = "roger";//表名String tableName = "Person";//資料庫名String dbName = "roger";// urlString url = "jdbc:mysql://localhost/"+dbName+"?user="+uname+"&password="+upassword;Class.forName("com.mysql.jdbc.Driver").newInstance();Connection conn = DriverManager.getConnection(url);Statement stmt = conn.createStatement();String sql = "SELECT * FROM "+ tableName;ResultSet rs = stmt.executeQuery(sql);// 擷取資料集的列數ResultSetMetaData rsmd = rs.getMetaData();int iColumns = rsmd.getColumnCount();out.print("<table border=1><tr>");for(int i=1;i<iColumns;++i){ out.print("<td>"+rsmd.getCatalogName(i)+"</td>");}out.print("</tr>");while(rs.next()){ out.print("<tr>"); for(int i=1;i<iColumns;++i){ out.print("<td>"+rs.getString(i)+"</td>"); } out.print("</tr>");}out.print("</table>");out.print("success!");rs.close();stmt.close();conn.close();%><!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>串連MySQL</title></head><body> </body></html>
結果:
上面的代碼可能還會有其他問題, 至少整個流程是走通了的!
Windows下搭建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
