dbase.java

来自「是一个综合开发程序,可以做为系统研究人员的参考」· Java 代码 · 共 34 行

import java.sql.*;
public class dbase{
    static {
        try{
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            System.out.println("success loading...");
        }
        catch(Exception e){
            System.out.println("Error loading...");
            e.printStackTrace();
        }
    }
    public static void main(String[] args){
        System.out.println("  我的同学录:\n");
        try{
            Connection con=DriverManager.getConnection("jdbc:odbc:mysoft","dba","sql");
            Statement state=con.createStatement();
            ResultSet result=state.executeQuery("SELECT id,name,sex,address,phoths FROM address");
            while(result.next()){
                String id=result.getString(1);
                String name=result.getString(2);
                String sex=result.getString(3);
                String address=result.getString(4);
                String phoths=result.getString(5);
                System.out.println(id+"  "+name+"  "+sex+"  "+address+"  "+phoths);
            }
            System.out.println("Data Base Preview Success....");
            con.close();
        }
        catch(SQLException e){
            e.printStackTrace();
        }
    }
}