连接access数据库

来源:互联网 发布:java 微信提现 编辑:程序博客网 时间:2024/06/05 21:08
public static void main(String[] args) {  try {   Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");     } catch (ClassNotFoundException e) {   e.printStackTrace();  }  try {   Connection conn=DriverManager.getConnection("jdbc:odbc:bookshop","","");   Statement stmt=conn.createStatement();   ResultSet rs=stmt.executeQuery("select * from user");   while(rs.next()){    System.out.println(rs.getString(1));     System.out.println(rs.getString(2));     System.out.println(rs.getString(3));     System.out.println(rs.getString(4));     System.out.println(rs.getString(5));     System.out.println(rs.getString(6));    }   conn.close();  } catch (SQLException e) {   e.printStackTrace();  } }

0 0
原创粉丝点击