查人人中国名人网华文教学概论:java access
来源：百度文库 编辑：查人人中国名人网 时间：2024/04/27 23:56:06
请告诉我下面的代码的解释：
package cn.ncepu;
import java.sql.*;
class Select {
static public void main(String[] args) {
try {
String url = "jdbc:odbc:mySDN";
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection conn = DriverManager.getConnection(url, "", "");
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("SELECT * FROM Table1");
System.out.println("开始获得纪录...");
while (rs.next()) {
System.out.println(rs.getString(1) + " " + rs.getString(2) + " " + rs.getString(3));
}
System.out.println("结束！");
stmt.close();
conn.close();
}
catch (Exception ex) {
ex.printStackTrace();
}
}
}
package cn.ncepu;
import java.sql.*;
class Select {
static public void main(String[] args) {
try {
String url = "jdbc:odbc:mySDN";
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection conn = DriverManager.getConnection(url, "", "");
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("SELECT * FROM Table1");
System.out.println("开始获得纪录...");
while (rs.next()) {
System.out.println(rs.getString(1) + " " + rs.getString(2) + " " + rs.getString(3));
}
System.out.println("结束！");
stmt.close();
conn.close();
}
catch (Exception ex) {
ex.printStackTrace();
}
}
}
此段代码为用类Select获取数据库中的纪录
package cn.ncepu; //定义包
import java.sql.*; //导入java包
class Select { //定义类
static public void main(String[] args) {
try {
//链接数据库
String url = \"jdbc:odbc:mySDN\";
Class.forName(\"sun.jdbc.odbc.JdbcOdbcDriver\");
Connection conn = DriverManager.getConnection(url, \"\", \"\");
Statement stmt = conn.createStatement();
//定义数据集
ResultSet rs = stmt.executeQuery(\"SELECT * FROM Table1\");
System.out.println(\"开始获得纪录...\");
while (rs.next()) {
//循环输出数据集
System.out.println(rs.getString(1) + \" \" + rs.getString(2) + \" \" + rs.getString(3));
}
System.out.println(\"结束！\");
stmt.close();
//关闭数据链接
conn.close();
}
//报错
catch (Exception ex) {
ex.printStackTrace();
}
}
}