import java.sql.*;
public class ConnectDB
{
Connection connect=null;
Statement statement=null;
ResultSet result=null;
String driver="oracle.jdbc.driver.OracleDriver";
String url="jdbc:oracle:thin:@192.168.1.22:1521:orac";
String user="scott";
String password="tiger";
String sql="select sno,sname,ssex,sage,sdept from student";
public void doConnect()
{
try
{
Class.forName(driver).newInstance();
System.out.println("加载驱动成功");
connect=DriverManager.getConnection(url,user,password);
System.out.println("连接数据库成功");
statement=connect.createStatement();
result=statement.executeQuery(sql);
result.next();
System.out.println("------记录------");
System.out.println("学号"+result.getString("sno"));
System.out.println("姓名"+result.getString("sname"));
System.out.println("性别"+result.getString("ssex"));
System.out.println("年龄"+result.getInt("sage"));
System.out.println("专业"+result.getString("sdept"));
}
catch(Exception e)
{
e.printStackTrace();
}
finally
{
try
{
connect.close();
statement.close();
result.close();
}
catch(Exception e)
{}
}
} public static void main(String[] args)
{
ConnectDB aa=new ConnectDB();
aa.doConnect();
}
}
public class ConnectDB
{
Connection connect=null;
Statement statement=null;
ResultSet result=null;
String driver="oracle.jdbc.driver.OracleDriver";
String url="jdbc:oracle:thin:@192.168.1.22:1521:orac";
String user="scott";
String password="tiger";
String sql="select sno,sname,ssex,sage,sdept from student";
public void doConnect()
{
try
{
Class.forName(driver).newInstance();
System.out.println("加载驱动成功");
connect=DriverManager.getConnection(url,user,password);
System.out.println("连接数据库成功");
statement=connect.createStatement();
result=statement.executeQuery(sql);
result.next();
System.out.println("------记录------");
System.out.println("学号"+result.getString("sno"));
System.out.println("姓名"+result.getString("sname"));
System.out.println("性别"+result.getString("ssex"));
System.out.println("年龄"+result.getInt("sage"));
System.out.println("专业"+result.getString("sdept"));
}
catch(Exception e)
{
e.printStackTrace();
}
finally
{
try
{
connect.close();
statement.close();
result.close();
}
catch(Exception e)
{}
}
} public static void main(String[] args)
{
ConnectDB aa=new ConnectDB();
aa.doConnect();
}
}
解决方案 »
- 请问大侠为什么的Oracle数据库连不上?
- 高分求救!如何从ORACLE中导出成.DBF格式的文件?在线等!!!
- update 的简单写法
- 请问一下 forms builder 里面的 Frame Title 可以通过程序修改吗
- 问高手个问题,开发移动那样的客户管理系统,用sql sever,还是oracle,为什么?
- ---c# 怎么读出 和 写入 Oracle里 long 类型的字段???
- 如何只能让指定的IP地址或计算机名称登录Oracle服务器
- 请问oralce中有没有根据一个日期求得其是第几周的函数 ?
- 字符集问题啊!救命!!!!!!!!!!!!
- 请问:oracle8i中字符集和国家字符集有什么区别
- 同一语句表达的不同,引起结果的不同,急!
- Oracle数据库将表从一个库导入到另外一个库中,在线等。。。。。。
System.out.println( "------记录------ ");
System.out.println( "学号 "+result.getString( "sno "));
System.out.println( "姓名 "+result.getString( "sname "));
System.out.println( "性别 "+result.getString( "ssex "));
System.out.println( "年龄 "+result.getInt( "sage "));
System.out.println( "专业 "+result.getString( "sdept ")); }