一个使用JAVA通过ODBC访问数据库的小例子
<P>package conndb;<BR>import java.sql.DriverManager;<BR>import java.sql.Connection;<BR>import java.sql.Statement;<BR>import java.sql.ResultSet;<BR>import java.sql.*;</P><P>public class conndb {<BR>public static void main(String[] args) {<BR>try {<BR> Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");<BR> Connection con = DriverManager.getConnection("jdbc:odbc:feidb");<BR> Statement stm = con.createStatement();</P>
<P>//增加<BR> //stm.executeUpdate("insert into userinfo(name,qq) values ('xufei','50074584')");<BR>//查询 </P>
<P> ResultSet rs = stm.executeQuery("select * from userinfo order by id desc");<BR> int total =rs.getMetaData().getColumnCount();<BR> for (int k=1;k<=total;k++){<BR> String colname = rs.getMetaData().getColumnName(k);<BR> int type=rs.getMetaData().getColumnType(k);<BR> System.out.println(colname+","+type+","+rs.getMetaData().getColumnClassName(k));<BR> }<BR>//while (rs.next()) {<BR>//int id = rs.getInt("id");<BR>//String name = rs.getString("name");<BR>//String qq = rs.getString("qq");<BR>//System.out.println(id + " , " + name + " , " + qq);<BR>//}</P>
<P>}<BR>catch (SQLException ex) {<BR>}<BR>catch (ClassNotFoundException ex) {<BR>}<BR>}<BR>}<BR></P>
楼主你太有才了......
楼主你太有才了......http://www.domain.cn/club/images/default/sigline.gif
古之立大事者，不惟有超世之才，亦必有坚忍不拔之志。---魔兽剑圣异界纵横
小游戏 极品家丁 龙蛇演义 恶魔法则 飞升之后 异界枪神 凡人修仙传 魔兽领主 超级农民 成人小游戏 极品公子
页:
[1]