Question

jsp怎么连接access数据库

Answer 1

package com.;

import java.sql.Connection;
import java.sql.DriverManager;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class DBUtil
{

// 定义数据库连接的相关属性常量
private final static String DRIVERCLASS ="sun.jdbc.odbc.JdbcOdbcDriver";
private final static String URL = "jdbc:odbc:driver=;DBQ=C:\\";//DBQ的值是数据库的存放路径，这样写不需配数据源，少很多麻烦。

/**
* 数据库连接
* @return
* @throws ClassNotFoundException
* @throws SQLException
*/
public static Connection getConn () throws ClassNotFoundException, SQLException
{
Connection con = null;
Class.forName(DRIVERCLASS);
con=DriverManager.getConnection(URL);//用Access没设密码。

return con;

}

/**
*
* @param rs
* @param pstm
* @param con
*/
public static void closeAll(ResultSet rs, Statement pstm, Connection con) {
try {
if (rs != null)
rs.close();
if (pstm != null)
pstm.close();
if (con != null)
con.close();
} catch (SQLException e) {
e.printStackTrace();
}

}

}