62,634
社区成员




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;
}
}
<%@ 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>");
}
%>
谢谢!!