摘要: 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)