17,377
社区成员
发帖
与我相关
我的任务
分享
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.Statement;
import java.sql.ResultSet;
public class Test
{
public static void main(String[] args)
{
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con = DriverManager.getConnection("jdbc::odbc:mine", "scott", "tiger");
Statement sm = con.createStatement();
ResultSet rs = sm.executeQuery("select * from emp");
while(rs.next())
{
System.out.println("用户名" + rs.getString(2));
}
}
catch(Exception ex)
{
ex.printStackTrace();
}
}
}
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
public class Test
{
public static void main(String[] args)
{
try
{
//加载驱动
Class.forName("oracle.jdbc.driver.OracleDriver");
//得到连接
Connection ct = DriverManager.getConnection("jdbc:oracle:thin:@127.0.0.1:1521:TEST", "scott", "tiger");
//从下面开始和sql server一样
Statement sm = ct.createStatement();
ResultSet rs = sm.executeQuery("select * from emp");
while(rs.next())
{
System.out.println("用户名" + rs.getString(2));
}
}
catch(Exception ex)
{
ex.printStackTrace();
}
}
}