HttpServletRequest request.getRealpath("");
解决方案 »
- 哪位大牛来给讲讲发布一个网站的详细流程
- java nio请求命令处理
- 想学java,问一些问题,请指教。
- 关于登录的问题
- ajax请求strcut2下的action,action没有运行
- 文本输入框的小问题。。。送分问题哟。
- 谁知道rbeacon是个什么东西?
- 在服务端显示sun.Jdbc.Odbc.JdbcOdbcDriver no suitable driver是怎么回事?
- 关于JSP的图例,毕业答辩用的.给100分
- 关于request.getSession().setAttribute()失效后获取值为空的问题
- 在BEAN中如何取得WEB项目的名称?
- Bean的问题,走过路过的来瞧瞧看看拉
Connection odbcConn;
Statement odbcStmt;
ResultSet odbcRs; Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
odbcConn=DriverManager.getConnection("jdbc:odbc:DRIVER={Microsoft Access Driver (*.mdb)};DBQ=F:\\Db_ColligateStatistic\\ColligateStatistic.mdb;","admin","");
odbcStmt=odbcConn.createStatement();
public Connect() {
super();
try {
dbURL = "jdbc:odbc:customer";
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance();
DriverManager.setLoginTimeout(10);
conn = DriverManager.getConnection(dbURL);
} catch (Exception e) {
System.err.println(e);
e.printStackTrace();
}
}
public static java.sql.Connection getConnection() {
if (conn!= null) {
return (new Connect()).conn;
}
if (conn == null) {
1="Sorry, configure file is wrong!";
}
return conn;
}
//////这样不加[]在表的外面也可以读到数据.///////////////ACCESS数据库+java
///////////////////////////////////////////////////////package football;
import java.sql.*;
import java.io.*;
public class DbConnection { Connection conn = null;
Statement stmt = null;
ResultSet rset = null; private String sDBDriver = "sun.jdbc.odbc.JdbcOdbcDriver";
private String sConnStr = "jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=league.mdb"; public DbConnection() {
}
public void connectionOpen()
{
try {
Class.forName(sDBDriver);
}
catch (java.lang.ClassNotFoundException e) {
System.err.println(e.getMessage());
}
} //executeQuery and executeUpdate public ResultSet executeQuery(String query) throws SQLException{
conn = DriverManager.getConnection(sConnStr);
stmt = conn.createStatement();
rset = stmt.executeQuery(query);
return rset;
} public void executeUpdate(String query) throws SQLException{
stmt = conn.createStatement();
stmt.executeUpdate(query);
if(stmt != null) stmt.close();
} public void close() throws SQLException{
if(conn != null) conn.close();
if(rset != null) rset.close();
if(stmt != null) stmt.close();
} protected void finalize() throws Throwable{
close();
}
}