wuzhong
发贴: 9
积分: 0
|
于 2007-01-19 14:03
可以了. import java.sql.*;
public class EmpJdbc { String dbDriver="sun.jdbc.odbc.JdbcOdbcDriver"; String url="jdbc:odbc:mydb"; Connection con=null; ResultSet rs=null; public EmpJdbc(){ try{ Class.forName(dbDriver);
}catch(ClassNotFoundException e){ e.printStackTrace(); } } public ResultSet executeQuery(String s){ rs=null; try{ con=DriverManager.getConnection(url); Statement stm=con.createStatement(); rs=stm.executeQuery("SELECT * FROM project");
}catch(SQLException e){ e.printStackTrace(); } return rs; } public static void main(String args[])throws Exception{ EmpJdbc emjdbc=new EmpJdbc(); String sql="SELECT*FROM project"; ResultSet rs=emjdbc.executeQuery(sql); while(rs.next()){ String name=rs.getString("name"); System.out.println(name);
} }
}
|