【正确答案】示例代码如下:
import java.sql.*;
public class Test{
public Connection getConnection(){
Connection conn=null;
String driver="oracle.jdbc.driver.OracleDriver";
String url="";
String name="user";
String psw="password";
try{
Class.forName(driver);
conn=DriverManager.getConnection(url,name,psw);
}catch(ClassNotFoundException e){
e.printStackTrace();
}catch(SQLException e){
e.printStackTrace();
}
return conn;
}
public void selectFromOracle(){
Connection conn=null;
PreparedStatement pstat=null;
ResultSet rs=null;
try{
conn=getConnection();
String sql="select name,score from Student where name=?";
pstat=conn.prepareStatement(sql);
pstat.setString(1,"James");
rs=pstat.executeQuery();
while(rs.next()){
System.out.println(rs.getString("name")+1","+rs.getInt("score"));;
}
}catch(SQLException e){
e.printStackTrace();
}finally{
if(rs!=null)
try{
rs.close();
}catch(SQLException e){
e.printStackTrace();
}
if(pstat!=null)
try{
pstat.close();
)catch(SQLException e){
e.printStackTrace();
}
if(conn!=null)
try{
conn.close();
}catch(SQLException e){
e.printStackTrace();
}
}
}
}
【答案解析】