实验八 JDBC数据库访问一
一、实验目标:
掌握并熟练使用JDBC连接数据库
区分两种连接方式的特点
二、实验内容:
1、 必做:在JavaBean中实现对数据库的两种连接方式:JDBC-ODBC桥、纯Java驱动,并在JSP中调用;
2、 选作:能够浏览表中所有记录。
三、项目代码
package com.jdbc.one;
import java.io.Serializable;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
public class DbBean implements Serializable {
private String jdbcUrl;
private String username;
private String password;
public DbBean() {
try{
Class.forName("com.mysql.jdbc.Driver");
}catch(ClassNotFoundException ex){
throw new RuntimeException(ex);
}
}
public boolean isConnectedOK() {
boolean ok = false;
Connection conn = null;
SQLException ex = null;
try {
conn=DriverManager.getConnection(jdbcUrl,
username,password);
System.out.println(jdbcUrl+username+password);
if (conn!=null) {
ok = true;
}
} catch (SQLException e) {
ex = e;
} finally {
if (conn != null) {
try {
conn.close();
} catch (SQLException e) {
if(ex == null) {
ex = e;
}
}
}
if(ex != null) {
throw new RuntimeException(ex);
}
}
return ok;
}
public void setJdbcUrl(String jdbcUrl) {
this.jdbcUrl = jdbcUrl;
}
public void setUsername(String username) {
this.username = username;
}
public void setPassword(String password) {
this.password = password;
}
}
<%@page contentType="text/html" pageEncoding="UTF-8"%>
<%@taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
<jsp:useBean id="db" class="com.jdbc.one.DbBean"/>
<c:set target="${db}" property="jdbcUrl"
value="jdbc:mysql://localhost:3306/test"/>
<c:set target="${db}" property="username" value="root"/>
<c:set target="${db}" property="password" value="1234"/>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type"
content="text/html; charset=UTF-8">
<title>测试数据库连线</title>
</head>
<body><h1>
<c:choose>
<%--<c:when test="${db.isconnectedOK}">恭喜你,纯Jdbc方式数据库连线成功!</c:when> --%>
<c:when test="<%db.isConnectedOK();%>">恭喜你,纯Jdbc方式数据库连线成功!</c:when>
<c:otherwise>很遗憾,数据库连线失败!</c:otherwise>
</c:choose>
</h1></body>
</html>