《(完整word)《Java程序设计任务驱动式教程-》程序代码.doc》由会员分享，可在线阅读，更多相关《(完整word)《Java程序设计任务驱动式教程-》程序代码.doc（4页珍藏版）》请在金锄头文库上搜索。
1、任务二十三 访问数据升级3P239程序代码package com.task23;import java.sql.Connection;import java.sql.PreparedStatement;import java.sql.ResultSet;import java.sql.Statement;import java.util.ArrayList;import java.util.List;/* * StudentDAO.java * 数据库操作DAO，查询 */public class StudentDAO public List getAllStudent() /详细代码参见23
2、.4.4 数据访问层package com.task23;/* * Student.java * 封装实体Bean */public class Student private String id ;private String name ;private int age ;private String speci ;public Student() super();public Student(String id, String name, int age, String speci) super();this.id = id;this.name = name;this.age = age;
3、this.speci = speci;public String getId() return id;public void setId(String id) this.id = id;public String getName() return name;public void setName(String name) this.name = name;public int getAge() return age;public void setAge(int age) this.age = age;public String getSpeci() return speci;public vo
4、id setSpeci(String speci) this.speci = speci;package com.task23;import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;/* * StudentDBConnection.java * 辅助类，数据库连接，资源关闭 */public class StudentDBConnection private static f
5、inal String DRIVER_CLASS = com.microsoft.jdbc.sqlserver.SQLServerDriver;private static final String DATABASE_URL = jdbc:microsoft:sqlserver:/localhost:1433;DatabaseName=welcomestudent;private static final String DATABASE_USER = sa;private static final String DATABASE_PASSWORD = sasa;/* * 建立连接 * * re
6、turn Connection */public static Connection getConnection() Connection con =null;try Class.forName(DRIVER_CLASS); catch (ClassNotFoundException ce) ce.printStackTrace();try con = DriverManager.getConnection(DATABASE_URL, DATABASE_USER,DATABASE_PASSWORD); catch (SQLException e) e.printStackTrace();ret
7、urn con;/* * 关闭连接 */public static void closeConnection(Connection con)tryif (con!=null & !con.isClosed()con.close();catch(Exception e)e.printStackTrace();/* * 关闭结果集 */public static void closeResultSet(ResultSet rs) try if (rs != null) rs.close(); catch (SQLException e) e.printStackTrace();/* * 关闭Sta
8、tement */public static void closeStatement(Statement pstmt) try if (pstmt != null) pstmt.close(); catch (SQLException e) e.printStackTrace();package com.task23;import java.util.ArrayList;import java.util.List;/* * StudentBiz.java * 业务逻辑 */public class StudentBiz public static void show(Student stude
9、nt) if (student != null) System.out.print(student.getId() + t);System.out.print(student.getName() +t);System.out.print(student.getAge() + t);System.out.println(student.getSpeci();/* * param args */public static void main(String args) StudentDAO studentDAO = new StudentDAO();Student student = null;/
10、查listList lStudent = new ArrayList();lStudent = studentDAO.getAllStudent();for (int i = 0; i lStudent.size(); i+) student = (Student) lStudent.get(i);show(student);P243应用扩展package com.task23;import java.util.List;/* * StudentDAOInterface.java * 数据库操作DAO接口，查、增、删、改 */public interface StudentDAOInterfa
11、ce public Student getStudentById(String id) ;public List getAllStudent();public int addStudent(Student student);public int deleteStudent(Student student);public int updateStudent(Student student) ;package com.task23;/* * StudentBizInterface.java * 业务逻辑接口 */public interface StudentBizInterface public void show(Student student);public void business(); public class StudentDAO implements StudentDAOInterface/实现接口代码参见23.4.4 数据访问层public class StudentBiz implements StudentBizInterfacepublic void show(Student student) public void business()
