packagecom.upc;importjava.sql.*;importjava.util.*;publicclasslianjie{StringDriver="sun.jdbc.odbc.JdbcOdbcDriver";Stringurl="jdbc:odbc:DRIVER={MicrosoftAccessDriver(*.mdb,...
package com.upc;import java.sql.*;import java.util.*;public class lianjie {String Driver="sun.jdbc.odbc.JdbcOdbcDriver";String url = "jdbc:odbc:DRIVER={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=D:/daohanggongcheng/daohang/WebRoot/数据库.mdb";//String url="jdbc:odbc:mydb";String username=null;String password=null;public static void main(String[] args) {// TODO Auto-generated method stub lianjie jdbc = new lianjie();} public lianjie(){ try { Class.forName(Driver).newInstance();// 1. 注册驱动 Connection con = DriverManager.getConnection(url,username,password);// 2. 获得与数据库的连接 String sql="SELECT * FROM users where age=15"; Statement stmt=con.createStatement(); ResultSet result=stmt.executeQuery(sql); while(result.next()){//行 String s1=result.getString(1);//列 // s2=result.getString(3); //list1.add(s1); //list2.add(s2); } }catch(Exception ex){ System.out.print(ex); } }}求大神指点哪里有错
展开