import java.sql.*;
public class Dao {
public static void main(String[] args) {
String url;
String S_id;
String S_name;
String S_add;
Connection con;
Statement sql = null;
ResultSet rs;
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
//直接加载了sun公司提供的jdbc-odbc bridge驱动程序。由驱动程序负责向drivermanager登记
} catch (Exception e1) {
System.out.println(e1.toString());
System.out.println("no1");
}
try {
url="jdbc:odbc:student";
con = DriverManager.getConnection(url);
//使用最简单的建立连接方法,除了数据 源名外没有给出任何附加信息。
// con = DriverManager.getConnection("jdbc:odbc:student", "", "");
//第二种方法,可以给出用户名和密码
//DriverManager用来处理装载驱动程序并且为创建新的数据库连接提供劫持;
System.out.println("连接成功");
DatabaseMetaData dbma=con.getMetaData();//得到数据库基本信息
System.out.println(dbma.getURL());
System.out.println(dbma.getUserName());
System.out.println(dbma.isReadOnly());
sql = con.createStatement();
//Statement在一个给定的连接中作为sql执行声明的容器;它包含了两个重要的子类型:
rs = sql.executeQuery("SELECT S_id,S_name,S_add FROM student where s_id=1");
while (rs.next()) {
S_id = rs.getString("S_id");
S_name = rs.getString("S_name");
S_add = rs.getString("S_add");
System.out.println(S_id);
System.out.println(S_name);
System.out.println(S_add);
}
} catch (Exception e2) {
System.out.println(e2.toString());
System.out.println("no2");
}
try {
sql.close();
} catch (SQLException e) {
System.out.println("no3");
}
}
}