import java.sql.*;public class oracle{
public static void main(String[] args){
java.sql.Connection conn = null;
try
{
Class.forName("oracle.jdbc.driver.OracleDriver");
conn = DriverManager.getConnection("jdbc.oracle.thin:@XXXX:1521:XXXX","XXXX","XXXX");
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("select * from sys.user$");
while(rs.next())
{
System.out.print(rs.getString(1));
}
}
catch (Exception e){
System.out.println("Error"+"---"+e.getMessage());
}
}
}=================================
上面是原码,下面是在Console看到的
=================================
testing oracle-character-set-1 against <abc>
PASSED LOSSY
testing oracle-character-set-1 against <ab?c>
PASSED LOSSY
testing oracle-character-set-1 against <XY
testing oracle-character-set-1 against <longlonglonglong...>
PASSED LOSSY
testing oracle-character-set-31 against <abc>
PASSED LOSSY
testing oracle-character-set-31 against <ab?c>
PASSED LOSSY
testing oracle-character-set-31 against <XY百度下只在CSDN看到有人碰到相同问题,但那个问题好像是0回复。
public static void main(String[] args){
java.sql.Connection conn = null;
try
{
Class.forName("oracle.jdbc.driver.OracleDriver");
conn = DriverManager.getConnection("jdbc.oracle.thin:@XXXX:1521:XXXX","XXXX","XXXX");
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("select * from sys.user$");
while(rs.next())
{
System.out.print(rs.getString(1));
}
}
catch (Exception e){
System.out.println("Error"+"---"+e.getMessage());
}
}
}=================================
上面是原码,下面是在Console看到的
=================================
testing oracle-character-set-1 against <abc>
PASSED LOSSY
testing oracle-character-set-1 against <ab?c>
PASSED LOSSY
testing oracle-character-set-1 against <XY
testing oracle-character-set-1 against <longlonglonglong...>
PASSED LOSSY
testing oracle-character-set-31 against <abc>
PASSED LOSSY
testing oracle-character-set-31 against <ab?c>
PASSED LOSSY
testing oracle-character-set-31 against <XY百度下只在CSDN看到有人碰到相同问题,但那个问题好像是0回复。
难道是错在jdbc:oracle:thin:@XXXX:1521:XXXX","XXXX","XXXX
???
类名的可能性已经排除。
=====================
0
-2127527632
189000
-1875869392
-2127527632
258
Exception in thread "main" java.lang.NullPointerException
at oracle.sql.converter.CharacterConverter12Byte.toOracleCharacterWithReplacement(CharacterConverter12Byte.java:253)
at oracle.sql.converter.CharacterConverterGB18030.main(CharacterConverterGB18030.java:1119)
?