Chris

Jan
19
2007

要在 Tomcat 下使用 MySQL 及 PostgreSQL, 首先要下載 JDBC Driver.

下載後把兩個 jar 檔案放在 /usr/local/tomcat/common/lib (或其他已設置好的 Classpath)

然後 JSP 檔案中要 import java.sql 中的 API classes:

JSP + MySQL:

<%@ page contentType="text/html;charset=big5"%>
<%@ page import="java.sql.*"%>
<%
Class.forName("com.mysql.jdbc.Driver").newInstance();
String db_url ="jdbc:mysql://localhost/db_name";
String db_user="db_user";
String db_pw="db_pwd";
Connection conn=DriverManager.getConnection(db_url, db_user, db_pw);
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql="SELECT id, name FROM table1";
ResultSet rs=stmt.executeQuery(sql);
while(rs.next())
{
%>
<%=rs.getString(1)%> <%=rs.getString(2)%>
<%
}
rs.close();
stmt.close();
conn.close();
%>

JSP + PostgreSQL:

<%@ page contentType="text/html;charset=big5"%>
<%@ page import="java.sql.*"%>
<html>
<body>
<%
//Class.forName("org.gjt.mm.mysql.Driver").newInstance();
Class.forName("org.postgresql.Driver").newInstance();
String db_url ="jdbc:postgresql://localhost/admin_test1";
String db_user="da_admin";
String db_pw="g639604";
Connection conn= DriverManager.getConnection(db_url, db_user, db_pw);
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql="SELECT table_name FROM information_schema.tables WHERE table_schema = 'public'";
ResultSet rs=stmt.executeQuery(sql);%>
<%while(rs.next()) {%>
<%=rs.getString(1)%>
<%}%>
<%rs.close();
stmt.close();
conn.close();
%>
</body>
</html>

Written by Chris Lam in: 程式編寫 |

No Comments »

You must be logged in to post a comment.