一个相当简单但是精悍的JDBC小程序,主要学习其中的结构方式,以及异常处理.
<来自于尚学堂-马士兵讲解的JAVA学习>
import java.sql.*;
public class JDBC {
public static void main( String args[]) {
String url = "jdbc:odbc:info";
Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
conn = DriverManager.getConnection(url, "", "");
stmt = conn.createStatement();
rs = stmt.executeQuery("select * from info");
int n = 0;
while( rs.next()) {
System.out.print(++n);
System.out.println(rs.getString("name"));
}
} catch ( ClassNotFoundException e) {
System.out.println("数据库驱动程序出现错误");
} catch ( SQLException e) {
System.out.println("数据库操作错误");
} finally {
try {
if(rs != null) rs.close();
if(stmt != null) stmt.close();
if(conn != null) conn.close();
} catch( SQLException e) {
System.out.println("数据库操作错误");
}
}
}
}
public class JDBC {
public static void main( String args[]) {
String url = "jdbc:odbc:info";
Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
conn = DriverManager.getConnection(url, "", "");
stmt = conn.createStatement();
rs = stmt.executeQuery("select * from info");
int n = 0;
while( rs.next()) {
System.out.print(++n);
System.out.println(rs.getString("name"));
}
} catch ( ClassNotFoundException e) {
System.out.println("数据库驱动程序出现错误");
} catch ( SQLException e) {
System.out.println("数据库操作错误");
} finally {
try {
if(rs != null) rs.close();
if(stmt != null) stmt.close();
if(conn != null) conn.close();
} catch( SQLException e) {
System.out.println("数据库操作错误");
}
}
}
}
