jdbc-odbc驱动加载成功
数据库连接成功
Exception in thread "main" java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] 参数不足,期待是 1。
at sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source)
at sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source)
at sun.jdbc.odbc.JdbcOdbc.SQLExecDirect(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcStatement.execute(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcStatement.executeQuery(Unknown Source)
at FoundDemoAccess.main(FoundDemoAccess.java:14)import java.sql.*;
public class FoundDemoAccess
{
public static void main(String[] args) throws Exception
{
String url = "jdbc:odbc:studentsAccess";
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
System.out.println("jdbc-odbc驱动加载成功");
Connection conn = DriverManager.getConnection(url, "", "");
System.out.println("数据库连接成功");
Statement stmt = conn.createStatement();
String sql = "select 编号, 学号, 姓名, 性别, 班级 from studentbase";
ResultSet rs = stmt.executeQuery(sql);
while(rs.next())
{
System.out.println(rs.getString(1) + " " + rs.getString(2) + " " + rs.getString(3) + " " + rs.getString(4));
}
rs.close();
conn.close();
}
}
数据库连接成功
Exception in thread "main" java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] 参数不足,期待是 1。
at sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source)
at sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source)
at sun.jdbc.odbc.JdbcOdbc.SQLExecDirect(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcStatement.execute(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcStatement.executeQuery(Unknown Source)
at FoundDemoAccess.main(FoundDemoAccess.java:14)import java.sql.*;
public class FoundDemoAccess
{
public static void main(String[] args) throws Exception
{
String url = "jdbc:odbc:studentsAccess";
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
System.out.println("jdbc-odbc驱动加载成功");
Connection conn = DriverManager.getConnection(url, "", "");
System.out.println("数据库连接成功");
Statement stmt = conn.createStatement();
String sql = "select 编号, 学号, 姓名, 性别, 班级 from studentbase";
ResultSet rs = stmt.executeQuery(sql);
while(rs.next())
{
System.out.println(rs.getString(1) + " " + rs.getString(2) + " " + rs.getString(3) + " " + rs.getString(4));
}
rs.close();
conn.close();
}
}
解决方案 »
- 关于使用二维数组输出和字符串问题
- linux-C实现SSLSocket服务端, 可以在客户端端用JSSE实现SSLSocket通讯吗
- 紧急求助:怎样清空JList里面的数据?
- javascript dom 能否转换成 java dom?具体正文……
- 请问如何将Date类型转换成字符串的YYYY-MM-DD
- 关于jdbc连接SQLSever
- 如何将double和float转化为byte型,并将byte型转化为double和float型
- 简单问题,难读书上印错了吗?在线等,
- java中如何调com组件?在线送分。
- 有工具把C++代码变成JAVA代码吗?
- 一个关于文本域的问题
- 关于 快速傅立叶变换的问题
pro.put("user","");
pro.put("password","");
Driver myDriver = (Driver)Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance();
Connection myConn=myDriver.connect("jdbc:odbc:DataSource",pro);试试行不行.