23,409
社区成员




package test.java.sql;
import java.io.OutputStream;
import java.io.PrintWriter;
import java.io.Writer;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import junit.framework.TestCase;
public class DriverManagerTest extends TestCase {
/**
* @param args
* @throws ClassNotFoundException
* @throws SQLException
*/
public static void main(String[] args) {
}
public final void jdbcDriver() throws ClassNotFoundException,
SQLException {
// 设置writer可打印jdbc信息
PrintWriter writer = new PrintWriter(System.out);
DriverManager.setLogWriter(writer);
// 加载驱动
// Class.forName("oracle.jdbc.driver.OracleDriver");
// 采用系统属性方式加载驱动
System.setProperty("jdbc.drivers", "oracle.jdbc.driver.OracleDriver");
Connection conn = DriverManager.getConnection(
"jdbc:oracle:thin:@127.0.0.1:1521:cao", "user", "password");
PreparedStatement statement = conn
.prepareStatement("update acc_nbr a set a.acc_nbr_id=103 where a.acc_nbr_id=103");
System.out.println(statement.executeUpdate());
System.out.println(statement.getUpdateCount());
}
public final void testjdbcodbcDriver() throws ClassNotFoundException,
SQLException {
// 设置writer可打印jdbc信息
PrintWriter writer = new PrintWriter(System.out);
DriverManager.setLogWriter(writer);
// 加载驱动
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
// 采用系统属性方式加载驱动
Connection conn = DriverManager.getConnection("jdbc:odbc:test");
String sql = "select * from timer";
// jdbc-odbc驱动不支持sql缓存,不支持参数
// PreparedStatement statement = conn.prepareStatement(sql);
Statement statement=conn.createStatement();
ResultSet rs=statement.executeQuery(sql);
System.out.println(rs.getRow());
}
}