java连接jsp教程,Java JDBC连接的一个例子-JSP教程,Java技巧及代码

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";

}

}