高手请看看这些access数据库连接代码有什么问题?
1、先建立一个JDBC类: Java codepackage com;
import java.sql.*;
public class JDBC{
private final String spath="/DataBase\\db1.mdb";
private final String dbpath = application.getRealPath(spath);
private final String dbname = "";
private final String pwd = "";
private final String url ="jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ="+dbpath;
private final Connection conn= DriverManager.getConnection(url);
public JDBC() {
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance(); //加载数据库驱动
} catch (Exception ex) {
System.out.println("数据库加载失败");
}
}
//创建数据库连接
public Connection getConnection() {
try {
conn= DriverManager.getConnection(url, dbname,pwd);
conn.setAutoCommit(true); } catch (SQLException e) {
System.out.println(e.getMessage());
System.out.println("creatConnectionError!");
}
return conn;
}
}2、在index.jsp页面调用如下:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%@ page import="java.util.*"%>
<jsp:useBean id="conn" scope="request" class="com.JDBC"/>
<%
Connection cnn = conn.getConnection();
Statement stmt=cnn.createStatement();
String query="insert into about(name) values('"+sContent+"')";
stmt.executeUpdate(query); String sql="select * from tb_userInfo";
ResultSet rs1=stmt.executeQuery(sql);
while(rs1.next())
{
String s=rs1.getString(1);
out.print(s+" <br>");
} %>谢谢!!
1、先建立一个JDBC类: Java codepackage com;
import java.sql.*;
public class JDBC{
private final String spath="/DataBase\\db1.mdb";
private final String dbpath = application.getRealPath(spath);
private final String dbname = "";
private final String pwd = "";
private final String url ="jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ="+dbpath;
private final Connection conn= DriverManager.getConnection(url);
public JDBC() {
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance(); //加载数据库驱动
} catch (Exception ex) {
System.out.println("数据库加载失败");
}
}
//创建数据库连接
public Connection getConnection() {
try {
conn= DriverManager.getConnection(url, dbname,pwd);
conn.setAutoCommit(true); } catch (SQLException e) {
System.out.println(e.getMessage());
System.out.println("creatConnectionError!");
}
return conn;
}
}2、在index.jsp页面调用如下:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%@ page import="java.util.*"%>
<jsp:useBean id="conn" scope="request" class="com.JDBC"/>
<%
Connection cnn = conn.getConnection();
Statement stmt=cnn.createStatement();
String query="insert into about(name) values('"+sContent+"')";
stmt.executeUpdate(query); String sql="select * from tb_userInfo";
ResultSet rs1=stmt.executeQuery(sql);
while(rs1.next())
{
String s=rs1.getString(1);
out.print(s+" <br>");
} %>谢谢!!
org.apache.jasper.compiler.DefaultErrorHandler.jspError(DefaultErrorHandler.java:40)
org.apache.jasper.compiler.ErrorDispatcher.dispatch(ErrorDispatcher.java:407)
org.apache.jasper.compiler.ErrorDispatcher.jspError(ErrorDispatcher.java:148)
org.apache.jasper.compiler.Generator$GenerateVisitor.visit(Generator.java:1178)
org.apache.jasper.compiler.Node$UseBean.accept(Node.java:1117)
org.apache.jasper.compiler.Node$Nodes.visit(Node.java:2166)
org.apache.jasper.compiler.Node$Visitor.visitBody(Node.java:2216)
org.apache.jasper.compiler.Node$Visitor.visit(Node.java:2222)
org.apache.jasper.compiler.Node$Root.accept(Node.java:457)
org.apache.jasper.compiler.Node$Nodes.visit(Node.java:2166)
org.apache.jasper.compiler.Generator.generate(Generator.java:3324)
org.apache.jasper.compiler.Compiler.generateJava(Compiler.java:199)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:296)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:277)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:265)
org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:564)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:302)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:329)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
1、JDBC类路径:src/com/JDBC.java
2、数据库路径:Database/db1.mdb
3、index.jsp路径:admin/index.jsp