JAVA连接数据库
步骤
- 加载驱动
- 获取数据库连接
- 获取Statemen对象
- 操作数据库
- 获取返回结果
- 关闭对象
代码实现
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import org.junit.Test;
public class JdbcTest {
@Test
public void TestDQL() {
Connection con=null;
Statement stat=null;
ResultSet rs=null;
try {
Class.forName("oracle.jdbc.OracleDriver");
String str1="jdbc:oracle:thin:@localhost:1521:xe";
String str2="demo";
String str3="demo";
con=DriverManager.getConnection(str1, str2, str3);
stat=con.createStatement();
String str4="SELECT SNO,SNAME FROM XS ";
rs=stat.executeQuery(str4);
while(rs.next()) {
String sno=rs.getString(1);
String sname=rs.getString("sname");
System.out.println("sno="+sno+" sname="+sname);
}
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}
finally{
if(rs!=null) {
try {
rs.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
if(stat!=null) {
try {
stat.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
if(con!=null) {
try {
con.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
}
}