求一个连接到Access 的带窗口操作的原码..... 我现在想开发JAVA连接到ACCESS的程序.不知道谁有这方面的代码.让你学习下.... 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 此回复为自动发出,仅用于显示而已,并无任何其他特殊作用楼主【sure2003】截止到2008-07-17 15:46:39的历史汇总数据(不包括此帖):发帖的总数量:248 发帖的总分数:10473 每贴平均分数:42 回帖的总数量:212 得分贴总数量:6 回帖的得分率:2% 结贴的总数量:245 结贴的总分数:10363 无满意结贴数:2 无满意结贴分:50 未结的帖子数:3 未结的总分数:110 结贴的百分比:98.79 % 结分的百分比:98.95 % 无满意结贴率:0.82 % 无满意结分率:0.48 % 值得尊敬 /** * 获取Access连接 * @param mdbPath 数据库路径 * @return Access连接 */ public static Connection getAccessConnection(String mdbPath) { Connection con = null; try { String url = "jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=" + mdbPath; Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); con = DriverManager.getConnection(url); } catch(Exception e) { e.printStackTrace(); } return con; } 用Java 就不要用Access 了! /* * FileName: MsAccessDbTest.java * UpdateTime: 2008-07-18 * Author: SageZk */import java.sql.*;//import javax.sql.*;public class MsAccessDbTest { public static final String DB_DRIVER = "sun.jdbc.odbc.JdbcOdbcDriver"; public static final String DB_CONSTR = "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=<path>"; public static Connection getDbConnection(String path) { if (path == null || path.trim().length() == 0) return null; Connection conn = null; try { Class.forName(DB_DRIVER); conn = DriverManager.getConnection(DB_CONSTR.replaceFirst("<path>", path)); } catch (Exception e) { e.printStackTrace(); } return conn; } public static void close(ResultSet rs) { if (rs == null) return; try { rs.close(); } catch (SQLException e) { e.printStackTrace(); } } public static void close(Statement stat) { if (stat == null) return; try { stat.close(); } catch (SQLException e) { e.printStackTrace(); } } public static void close(Connection conn) { if (conn == null) return; try { conn.close(); } catch (SQLException e) { e.printStackTrace(); } } public static void main(String[] args) { final String PATH = "D:/SunJava/Test_MsAccessDb/MsAccessDbTest.mdb"; Connection conn = null; Statement stat = null; ResultSet rs = null; try { conn = getDbConnection(PATH); if (conn == null) return; stat = conn.createStatement(); boolean su = stat.executeUpdate("INSERT INTO tbltest (colun, colpw) VALUES ('testun', 'testpw')") == 1; System.out.println("Insert sql statement execute success ? " + su); rs = stat.executeQuery("SELECT * FROM tbltest"); System.out.println("i\tcolun\t\tcolpw"); System.out.println("=================================="); for (int i = 1; rs.next(); i++) { System.out.print(i + ".\t"); System.out.print(rs.getString(2) + "\t\t"); System.out.print(rs.getString(3) + "\n"); } } catch (SQLException e) { e.printStackTrace(); } catch (Exception e) { e.printStackTrace(); } finally { close(rs); close(stat); close(conn); } }}窗口自己写 java的学习 内部类问题 给JPanel中的控件赋值 请教关于流程图的数据模型 for(;;i++)这样写怎么理解 数组引用问题 初学JAVA,该往哪个方向走?? Map.Entry求解! 请教:如何在swing的控件(如按钮)上自己绘制图形 java 中能不能调用windows的媒体播发器,如果可以,如何调用???? 关于异常,多谢 关于类与类关系问题
楼主【sure2003】截止到2008-07-17 15:46:39的历史汇总数据(不包括此帖):
发帖的总数量:248 发帖的总分数:10473 每贴平均分数:42
回帖的总数量:212 得分贴总数量:6 回帖的得分率:2%
结贴的总数量:245 结贴的总分数:10363
无满意结贴数:2 无满意结贴分:50
未结的帖子数:3 未结的总分数:110
结贴的百分比:98.79 % 结分的百分比:98.95 %
无满意结贴率:0.82 % 无满意结分率:0.48 %
值得尊敬
/**
* 获取Access连接
* @param mdbPath 数据库路径
* @return Access连接
*/
public static Connection getAccessConnection(String mdbPath)
{
Connection con = null; try
{
String url = "jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=" + mdbPath;
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con = DriverManager.getConnection(url);
}
catch(Exception e)
{
e.printStackTrace();
} return con;
}
* FileName: MsAccessDbTest.java
* UpdateTime: 2008-07-18
* Author: SageZk
*/import java.sql.*;
//import javax.sql.*;public class MsAccessDbTest { public static final String DB_DRIVER = "sun.jdbc.odbc.JdbcOdbcDriver";
public static final String DB_CONSTR = "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=<path>"; public static Connection getDbConnection(String path) {
if (path == null || path.trim().length() == 0) return null;
Connection conn = null;
try {
Class.forName(DB_DRIVER);
conn = DriverManager.getConnection(DB_CONSTR.replaceFirst("<path>", path));
} catch (Exception e) {
e.printStackTrace();
}
return conn;
} public static void close(ResultSet rs) {
if (rs == null) return;
try {
rs.close();
} catch (SQLException e) {
e.printStackTrace();
}
} public static void close(Statement stat) {
if (stat == null) return;
try {
stat.close();
} catch (SQLException e) {
e.printStackTrace();
}
} public static void close(Connection conn) {
if (conn == null) return;
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
} public static void main(String[] args) {
final String PATH = "D:/SunJava/Test_MsAccessDb/MsAccessDbTest.mdb";
Connection conn = null;
Statement stat = null;
ResultSet rs = null;
try {
conn = getDbConnection(PATH);
if (conn == null) return;
stat = conn.createStatement();
boolean su = stat.executeUpdate("INSERT INTO tbltest (colun, colpw) VALUES ('testun', 'testpw')") == 1;
System.out.println("Insert sql statement execute success ? " + su);
rs = stat.executeQuery("SELECT * FROM tbltest");
System.out.println("i\tcolun\t\tcolpw");
System.out.println("==================================");
for (int i = 1; rs.next(); i++) {
System.out.print(i + ".\t");
System.out.print(rs.getString(2) + "\t\t");
System.out.print(rs.getString(3) + "\n");
}
} catch (SQLException e) {
e.printStackTrace();
} catch (Exception e) {
e.printStackTrace();
} finally {
close(rs);
close(stat);
close(conn);
}
}}
窗口自己写