dongyan6235 2009-03-16 20:51
浏览 70
已采纳

在Java中使用SQL包java.sql

during a lecture my professor gave examples of several actions involving databases and the java.sql package. These examples were supposed to be uploaded online in a pdf file, but for some reason the names of all functions and class names aren't displaying with my pdf reader.

I would like to know the equilavents of the following PHP functions in Java:

mysql_connect
mysql_query
mysql_fetch_row
mysql_fetch_assoc
mysql_close

Thanks!

  • 写回答

3条回答 默认 最新

  • duan117890 2009-03-16 20:55
    关注

    If you consult the Java API docs appropriate for the version you're using (I'm using JDK 1.5, so it's http://java.sun.com/j2se/1.5.0/docs/api/) and click on java.sql, you can see all the classes for Java JDBC access.

    Basically, you create a new Connection to a database with DriverManager, and do a query with Connection.prepareStatement, PreparedStatement.execute() and PreparedStatement.executeQuery() and loop through the resultant ResultSet with ResultSet.next() and pull the results out with ResultSet.getXXXXX.

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(2条)

报告相同问题?