/*Java连接oracle数据库*/
你自己先建一个名叫soft的数据库,在建一个student的数据库表
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import com.soft.dto.StudentDTO;
//DAO封装的是对数据库的操作
public class StudentDAO
{
//getAll()方法得到数据库中的所有数据
public List getAll()
{
Connection conn=null;
List<StudentDTO> students=new ArrayList<StudentDTO>();
try {
/*加载oracle数据库驱动*/
Class.forName("oracle.jdbc.driver.OracleDriver");
/*获得数据库的连接*/
conn=DriverManager.getConnection("jdbc:oracle:@localhost:1521:soft","root","1234");
/*预处理语句*/
PreparedStatement ps=conn.prepareStatement("select stuid,stuname,stuage from student");
/*得到结果集*/
ResultSet rs=ps.executeQuery();
while(rs.next())
{
StudentDTO dto=new StudentDTO();
dto.setStuid(rs.getInt("stuid"));
dto.setStuname(rs.getString("stuname"));
dto.setStuage(rs.getInt("stuage"));
students.add(dto);
}
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally
{
if(conn!=null)
{
try {
conn.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
return students;
}
//main方法测试
public static void main(String[] args)
{
List<StudentDTO> students=new StudentDAO().getAll();
for(StudentDTO dto:students)
{
System.out.println(dto.getStuid()+":"+dto.getStuname()+":"+dto.getStuage());
}
}
◆◆
评论读取中....
请登录后再发表评论!
◆◆
修改失败,请稍后尝试