这段内容涉及到了Oracle数据库的字符集测试，包括testingoracle-character-set-1, -31和-870, -871。代码示例展示了如何使用JDBC连接Oracle数据库并执行SQL查询。在Java中，使用了`oracle.jdbc.OracleDriver`驱动，通过`DriverManager.getConnection`建立连接，并执行了获取emp表所有列的查询。
异常:
testing oracle-character-set-1 against
PASSED LOSSY
testing oracle-character-set-1 against
PASSED LOSSY
testing oracle-character-set-1 against
PASSED LOSSY
testing oracle-character-set-1 against
PASSED LOSSY
testing oracle-character-set-31 against
PASSED LOSSY
testing oracle-character-set-31 against
PASSED LOSSY
testing oracle-character-set-31 against
PASSED LOSSY
testing oracle-character-set-31 against
PASSED LOSSY
testing oracle-character-set-870 against
PASSED
testing oracle-character-set-870 against
PASSED
testing oracle-character-set-870 against
PASSED
testing oracle-character-set-870 against
PASSED
testing oracle-character-set-871 against
PASSED
testing oracle-character-set-871 against
PASSED
testing oracle-character-set-871 against
PASSED
testing oracle-character-set-871 against
PASSED
源码:
import java.sql.*;
public class Db {
PreparedStatement ps=null;
Connection ct=null;
ResultSet rs=null;
Db(){
try{
Class.forName("oracle.jdbc.OracleDriver");
ct=DriverManager.getConnection("jdbc:oracle:thin:
@127.0.0.1 :1521:ORC1","scott","scott");
ps=ct.prepareStatement("select * from emp");
rs=ps.executeQuery();
while(rs.next()){
System.out.println(rs.getString(2));
}
}catch(Exception e){
e.printStackTrace();
}
}
public static void main(){
new Db();
}
条件:
jdk1.6
ojdbc6.jar
表结构:
扫一扫
435
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
