数据库连接类DBConn.java
package com.wincom.struts.util;
import java.sql.*;
public class DBConn {
 public static Connection getConnection(){
  Connection conn = null;
  try {
   Class.forName("com.mysql.jdbc.Driver");
   String url = "jdbc:mysql://localhost:3306/wincom";
   String user = "root";
   String pass = "root";
   conn = DriverManager.getConnection(url,user,pass);
  } catch (ClassNotFoundException e) {
   e.printStackTrace();
  } catch (SQLException e) {
   e.printStackTrace();
  }
  return conn;
 }
}
------------------------------------------------------------------------------------------------
JSP测试页
<%@ page language="java" pageEncoding="GB2312"%>
< %@page import="java.sql.*"%>
< %@page import="com.wincom.struts.util.DBConn"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>  
    <title>My JSP 'index.jsp' starting page</title>
  </head> 
  <body>
<%
Connection conn = DBConn.getConnection();
Statement stmt = null;
String sql = null;
ResultSet rs = null;
try {
   stmt = conn.createStatement();
   sql = "select * from customer";
   rs = stmt.executeQuery(sql);
   while (rs.next()) {%>
    <%=rs.getString(2) %>
    <%=rs.getString(3) %>
    数据库连接成功！
   <%}%>
  <% } catch (SQLException e) {
   e.printStackTrace();
  }
%>
  </body>
</html>