《案例精解企业级网络构建》赠书活动开始啦！　最新活动：“Web安全大家谈”有奖征文

JSP测试连接MySQL

2008-07-18 10:11:18

数据库连接类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>

　下一篇 MyEclipse6.0 修改Jsp默认模板

类别：未分类 ┆ 技术圈() ┆ 阅读() ┆ 评论() ┆推送到技术圈 ┆返回首页

相关文章

文章评论

昵称：
验证码：		点击图片可刷新验证码　　博客过2级，无需填写验证码
内容：

ヅ惡魔ぺ嫙嵂

JSP测试连接MySQL