摘要:
import java.net.URLDecoder;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class ResultSetLike {
/**
* 取得相对路径的Connection
* @return
*/
public static Connection getConnection(){
Connection conn=null;
try{
String path="";
Class theClass = ResultSetLike.class;
//System.out.println(ConnTest2.class.getResourceAsStream("db.mdb"));
阅读全文
posted @ 2010-09-02 16:11
叮当小马
阅读(338)
评论(0)
推荐(0)
摘要:
import java.net.URLDecoder;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class PrepareStatementTest {
/**
* 取得相对路径的Connection
* @return
*/
public static Connection getConnection(){
Connection conn=null;
try{
String path="";
Class theClass = PrepareStatementTest.class;
//System.out.println(ConnTes 阅读全文
posted @ 2010-09-02 16:08
叮当小马
阅读(338)
评论(0)
推荐(0)
摘要:
/**
* 取得相对路径的Connection
* @return
*/
public static Connection getConnection(){
Connection conn=null;
try{
String path="";
Class theClass = ConnTest2.class;
//System.out.println(ConnTest2.class.getResourceAsStream("db.mdb"));
java.net.URL u= theClass.getResource("db.mdb");
String ChinesePath = URLDecoder.decode(u.getPath().substring(1,u.getPath().length()).replaceAll("%20", " "),"UTF-8");
//System.out.prin 阅读全文
posted @ 2010-09-02 16:05
叮当小马
阅读(334)
评论(0)
推荐(0)
摘要:
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class ConnAccessTest {
Connection con;
String DBDriver = "sun.jdbc.odbc.JdbcOdbcDriver";
String ConnStr = "jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=E:/workspace/Java从入门到精通/src/第20章数据库操作/db.mdb";
//String ConnStr = "jdbc:odbc:Driver={MicroSoft Access Driver (*.mdb)};DBQ=E:/workspace/db.mdb";
Conne 阅读全文
posted @ 2010-09-02 15:57
叮当小马
阅读(356)
评论(0)
推荐(0)