import java.net.url;
import java.sql.*;
public class javaoracle {
public javaoracle() {
}
public static void main(string[] args){
try
{
try{
class.forname("oracle.jdbc.driver.oracledriver");
}
catch(java.lang.classnotfoundexception e)
{
system.err.print(e.getmessage());
}
string url="jdbc:oracle:thin:@server:1521:sdcdb";
connection conn=drivermanager.getconnection(url,"test","test");
statement stmt=conn.createstatement();
resultset rs=stmt.executequery("select score from my");
while(rs.next())
{
system.out.println(rs.getstring(1));
}
conn.close();
}
catch(sqlexception ex)
{
while(ex!=null)
{system.out.println(ex.getsqlstate());
}
}
}
}
///
在try{}中: Class.forName("oracle.jdbc.driver.OracleDriver");
//将OracleDriver载入JVM对象池
抛出:ClassNotFoundException
3.连接数据库: Connection con=DriverManager.getConnection("jdbc:oracle:thin:ordertemp/ordetemp@localhost:1521:GY");
数据库类型标识符: jdbc:odbc:thin
登陆用户名: ordertemp
登陆密码: ordertemp
数据库服务器IP地址:localhost (或者用127.0.0.1,如果是网络,则为URL)
数据虚拟端口号: 1521 (oracle默认端口号) //(sqlserver默认端口号1433)
数据库SID: GY
抛出:SQLException
4.创建Statement对象(PreparedStatement也可以)
Statement stm=con.createStatement();
PreparedStatement psm=con.prepareStatement(String sql);
5.执行相关SQL查询语句及获得结果。
6.结束之后,必须使用: stm.close();