jsp如何使用数据库工具类
来源:百度知道 编辑:UC知道 时间:2024/09/20 23:41:19
我有一个纯java的数据库工具类,如下:
package com.mingdi;
import java.sql.*;
public class JdbcUtil {
static {
String driver = "com.mysql.jdbc.Driver";
try {
Class.forName(driver);
} catch (Exception e) {
e.printStackTrace();
}
}
public static Connection getConnection() {
String url = "jdbc:mysql://localhost:3306/mingdi_web_dat?user=root&password=";
String user = "root";
String password = "";
Connection con = null;
try {
con = DriverManager.getConnection(url, user, password);
} catch (Exception e) {
e.printStackTrace();
}
return con;
}
public static void release(ResultSet rs, Statement stmt, Connection con) {
if (rs != null) {
try {
rs.close();
} catch (Exception e) {
e.printStackTrace();
}
}
}
public st
package com.mingdi;
import java.sql.*;
public class JdbcUtil {
static {
String driver = "com.mysql.jdbc.Driver";
try {
Class.forName(driver);
} catch (Exception e) {
e.printStackTrace();
}
}
public static Connection getConnection() {
String url = "jdbc:mysql://localhost:3306/mingdi_web_dat?user=root&password=";
String user = "root";
String password = "";
Connection con = null;
try {
con = DriverManager.getConnection(url, user, password);
} catch (Exception e) {
e.printStackTrace();
}
return con;
}
public static void release(ResultSet rs, Statement stmt, Connection con) {
if (rs != null) {
try {
rs.close();
} catch (Exception e) {
e.printStackTrace();
}
}
}
public st
1:使用java脚本
<@ page import="com.mingdi.JdbcUtil">
<@ page import="java.sql.*">
<%
JdbcUtil db = new JdbcUtil();
Connection conn = db.getConnection();
Statement stmt = con.getStatement();
String sql = "select * from yourtable";
ResultSet rs = stmt.executeQuery(sql) ;
if(rs.next){
while(rs.next)
{
}
db.release(rs,stat,con);
}
%>
2:使用javaBean技术
<jsp:useBean id="db" class="com.mingdi.JdbcUtil">
</jsp:useBean>
其他操作一样
<%
Connection con = com.mingdi.JdbcUtil.getConnection();
Statement stmt = con.getStatement();
ResultSet rs = stat.executeQuery("select * from testTable");
while(rs.next)
{
}
com.mingdi.JdbcUtil.release(rs,stat,con);
%>