wuzhong
发贴: 9
积分: 0
|
于 2007-01-17 23:03
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(" ");//在这里添加你要查找的表字段名称 }catch(SQLException e){ e.printStackTrace(); } return rs; } public static void main(String args[])throws Exception{ EmpJdbc emjdbc=new EmpJdbc(); String sql="SELLECT*FROM project"; ResultSet rs=emjdbc.executeQuery(sql); while(rs.next()){ String name=rs.getString("name"); System.out.println(name); } }
}
|