import java.lang.*;
import java.util.*;
import java.sql.*;

public class cn1
{

public static void main(string args[])
{
string s="顾强";
string s1="ab";
string drv=null;
connection conn=null;
statement stmt=null;
resultset rs=null;
int rowcount=0;


properties p = new properties();


try
{
//注册数据库驱动程序为oracle驱动
class.forname("oracle.jdbc.driver.oracledriver");
}
catch (java.lang.classnotfoundexception e)
{
//这样写是为了方便调试程序，出错打印mydb()就知道在什么地方出错了
system.err.println("mydb(): " + e.getmessage());
}

try
{
conn = drivermanager.getconnection(
"jdbc:oracle:thin:@127.0.0.1:1521:orc8i", "java", "88888888");
}
catch (sqlexception ex)
{
system.err.println("conn:"+ex.getmessage());
}

if (conn!=null)
system.out.println("connection successful");
else
system.out.println("connection failure");

try
{
stmt=conn.createstatement();

}
catch (sqlexception ex)
{
system.err.println("createstatement();"+ex.getmessage());

}

try
{
rs=stmt.executequery("select * from userdata");

}
catch (sqlexception ex)
{
system.err.println("stmt.excutequery();"+ex.getmessage());

}

try
{
while (rs.next())
{

system.out.println("username: "+ rs.getstring(1));
system.out.println("password: "+rs.getstring(2));
system.out.println("email: " +rs.getstring(3));

}

}
catch (sqlexception ex)
{
system.err.println("a error is failure" +ex.getmessage());

}


//test1();
p=system.getproperties();

//p.list(system.out);
drv=p.getproperty("java.class.path");
//system.out.println("driver="+drv);



}


public static void test1()
{
cn2 cn2obj = new cn2();
printclassname(cn2obj);
}

public static void printclassname(object obj)
{
system.out.println("the class of " + obj +
" is " + obj.getclass().getname());
}


}

class cn2
{

public void test()
{
system.out.println("11111111111");

}

public string tostring()
{
return "1111";
}

}