Java窗体开结合Oracle数据库访问.docVIP

思路： 划分程序的层次： 三层架构：dao+vo构成数据访问层—》service构成逻辑处理层—》gui构成图形界面展示层，并分包 导入数据库类库 jdbc/lib/ojdbc14.jar 编程，单人或团队均可，互相调用干扰小 从数据库方向开始开发，dao+vo，需要完成CIUD， package com.cissst.dao; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import java.util.ArrayList; import java.util.Scanner; import com.cissst.vo.Student; public class StudentDao { private String url = jdbc:oracle:thin:@127.0.0.1:1521:ORCL; private String user = ; private String password = ; private Connection conn = null; private Statement stmt = null; private ResultSet rs = null; public StudentDao(){ Scanner scan = new Scanner(System.in); System.out.println(请输入用户名：); user = scan.next(); System.out.println(请输入密码：); password = scan.next(); } public StudentDao(String user, String password){ this.user = user; this.password = password; } public Connection getConnection(){ try { Class.forName(oracle.jdbc.driver.OracleDriver); conn = DriverManager.getConnection(url,user,password); } catch (ClassNotFoundException e) { System.out.println(驱动程序未加载); } catch (SQLException e) { System.out.println(数据库连接失败); } return conn; } public boolean insertStudent(Student s){ boolean success = false; String sql = INSERT INTO　student (sid,sname,age,attendtime) VALUES (?,?,?,?); try { PreparedStatement pstm = conn.prepareStatement(sql); pstm.setInt(1, s.getSid()); pstm.setString(2, s.getSname()); pstm.setInt(3, s.getAge()); pstm.setDate(4, s.getAttendTime()); int result = pstm.executeUpdate(); if (result0){ success = true; } pstm.close(); } catch (SQLException e) { e.printStackTrace(); } return success; } public boolean updateStudent(Student s){ boolean success = false; String sql = UPDATE　student SET sid = ?, sname = ?, age = ?, attendTime = ? WHERE sid = ?; try { PreparedStatement pstm = c