IT-Homer 专栏
成功是优点的发挥,失败是缺点的积累! 不为失败找理由,只为成功找
方法……
Linux JSP连接MySQL数据库
分类: Java/JSP SQL Index 2011-10-11 20:19 392人阅读评论(0) 收藏举报
Linux(Ubuntu平台)JSP通过JDBC连接MySQL数据库,与Windows平台类似,步骤如下:
下载 jdbc: mysql-connector-java-
解压 jdbc: tar -zxvf mysql-connector-java-
配置 jdbc:cp mysql-connector-java-- /usr/local//
JSP示例:
<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML Transitional//EN" "/html4/">
<%@ page language="java" import=".*"%>
<%@ page language="java" import=".*" %>
<html>
<head>
<title>Read from mySQL Database</title>
</head>
<body>
<p align="center"><b>Following records are selected from table "gametop800"</b><br></p>
<center>
<table border="1" borderColor="#ffe9bf" cellPadding="0" cellSpacing="0" width="60%" >
<tbody>
<tr>
<td bgColor="#008080" width="10%" height="28" align="center" valign="middle">
<font color="#ffffff"><b>top</b></font></td>
<td bgColor="#008080" width="30%" height="28" align="center" valign="middle">
<font color="#ffffff"><b>id</b></font></td>
<td bgColor="#008080" width="20%" height="28" align="center" valign="middle">
<font color="#ffffff"><b>name</b></font></td>
<td bgColor="#008080" width="20%" height="28" align="center" valign="middle">
<font co
Linux JSP连接MySQL数据库 来自淘豆网m.daumloan.com转载请标明出处.
