英文:
How do i verify whether my code has access to table
问题
以下是您的代码翻译：
我正在学习Java，在JDBC连接方面遇到了问题。
以下是我的代码：
public class DemoPro {
public void test() {
Connection con;
Statement stmt;
ResultSet rs;
System.out.println("正在寻找连接");
try{
Class.forName("net.ucanaccess.jdbc.UcanaccessDriver");
String dburl = "jdbc:ucanaccess://E://WEB Project//SCMPayBoard//Database/SCMEmpPayment.accdb";
con = DriverManager.getConnection(dburl, "", "");
System.out.println("连接成功");
stmt = con.createStatement();
String verify = "Select * from TestTable";
stmt.executeQuery(verify);
rs = stmt.getResultSet();
System.out.println("执行查询");
while(rs.next()) {
System.out.println("结果\n\n\n");
System.out.println(rs.getString(2) + " : " + rs.getString(3));
}
System.out.println("关闭连接");
con.close();
} catch (SQLException | ClassNotFoundException ex) {
Logger.getLogger(DemoPro.class.getName()).log(Level.SEVERE, null, ex);
}
}
public static void main(String[] args) {
DemoPro dp = new DemoPro();
dp.test();
}
}
输出：
正在寻找连接
连接成功
执行查询
关闭连接
构建成功（总时间：1秒）
所有的sysout语句都在执行，但是表数据没有被获取。
我如何知道是否成功访问了表格？
我应该怎么做才能得到预期的结果？
英文:
I am learning Java getting trouble in JDBC connection.
Following is my code:
public class DemoPro {
public void test() {
Connection con;
Statement stmt;
ResultSet rs;
System.out.println("Looking for connection");
try{
Class.forName("net.ucanaccess.jdbc.UcanaccessDriver");
String dburl="jdbc:ucanaccess://E://WEB Project//SCMPayBoard//Database/SCMEmpPayment.accdb";
con=DriverManager.getConnection(dburl,"","");
System.out.println("Connection successfully");
stmt=con.createStatement();
String verify = "Select * from TestTable";
stmt.executeQuery(verify);
rs = stmt.getResultSet();
System.out.println("Executing Query");
while(rs.next())
{
System.out.println("Result/n/n/n");
System.out.println(rs.getString(2) + " : " + rs.getString(3));
}
System.out.println("Closing Connection");
con.close();
}catch (SQLException | ClassNotFoundException ex) {
Logger.getLogger(DemoPro.class.getName()).log(Level.SEVERE, null, ex);
}
}
public static void main(String[] args) {
DemoPro dp=new DemoPro();
dp.test();
}
}
Output :
Looking for connection
Connection successfully
Executing Query
Closing Connection
BUILD SUCCESSFUL (total time: 1 second)
All sysout is executing but Table data is not fetched
How do i know Table is getting access or not
What should i do getting no result as expected
专注分享java语言的经验与见解，让所有开发者获益！
评论