似乎C#账户数据库出了些问题:
在数据库中,我收到如下错误信息:
错误1:找不到类型或命名空间名称“Connection”(您是否缺少使用指令或程序集引用?)
我可能做错了什么?我想连接到Accounts数据库。
代码1:
public void setCustAccounts(String custId) {
SQLConnection connect = acctsConnect();
Command statement = null;
ResultSet result = null;
String sql = "SELECT acctNo FROM Accounts Where Cid = '" + custId + "';";
try{
statement = connect.createStatement();
result = statement.executeQuery(sql);
while (result.next()){
result.getRow();
Account acct = new Account(result.getString("acctNo"));
custAccounts.add(acct);
}
}
finally {
connect.close();
}
}
代码:-
public SQLConnection acctsConnect(){
try{
Class.forName("C:\\ChattBankMDB.mdb");
}catch(ClassNotFoundException e){
Console.WriteLine("Error: " + e);
}
SQLConnection connect = null;
try{
connect = DriverManager.getConnection("C:\\ChattBankMDB.mdb");
}catch(SQLException e){
Console.WriteLine("Error: " + e);
}
return connect;
}
}
}
SqlConnection
- 在 C# 中大小写字母是有意义的! - marc_s