jsp通过JDBC读取Mysql

<%@ page language="java" contentType="text/html; charset=GB18030"

pageEncoding="GB18030"%>

<%@page import="java.sql.Connection" %>

<%@page import="java.sql.*" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">

<html>

<head>

<title>Jsp读取数据库</title>

</head>

<body>

<!--

-->

<tr>

</tr>

String driverClass = "com.mysql.jdbc.Driver";

String url = "jdbc:mysql://localhost:3306/c2cd";

String user = "root";

String password = "root";

Connection conn;

try {

Class.forName(driverClass).newInstance();

conn = DriverManager.getConnection(url, user, password);

Statement stmt = conn.createStatement();

String sql = "SELECT * FROM tb_books";

ResultSet rs = stmt.executeQuery(sql);

while (rs.next()) {

<tr>

</tr>

}

} catch (Exception ex) {

ex.printStackTrace();

}

</table>

</body>

</html>

java Build Path里面选择 mysql-connector-java-5.1.6-bin
并且在web Deployment Assembly里面引用 mysql-connector-java-5.1.6-bin

posted on 2012-07-04 11:40 jhtchina 阅读(199) 评论(0) 编辑收藏所属分类: jsp初学

文章分类


只有注册用户登录后才能发表评论。




网站导航: 博客园 IT新闻 Chat2DB C++博客博问管理
相关文章: jsp 内置对象获取异常信息 jsp 内置对象 application jsp 内置对象cookie JSP内置对象 Request jsp通过JDBC读取Mysql 99乘法表输出 html5 学习 java 文件操作接口Interface