{
//使用带参数的 prepareStatement 使用带参数的 pstmt = conn.prepareStatement(SQL_ADD); pstmt.setString(1, sb.getStudName()); pstmt.setInt(2, sb.getStudAge()); pstmt.setString(3, sb.getStudSex()); int i = pstmt.executeUpdate(); if (i >0) { //如果有影响行 这插入成功 如果有影响行,这插入成功 如果有影响行 success = true; } } catch (SQLException e) { System.out.println("添加错误 添加错误:" + e.getMessage()); 添加错误 } finally { DBConnection.CloseDB(conn, null, pstmt, null); } return success; } public void DeleteStudent(Connection conn, int id) throws Exception { try { PreparedStatement pstmt = conn.prepareStatement(SQL_DELETE); //根据学生 ID 参数删除 根据学生 pstmt.setInt(1, id); pstmt.executeUpdate(); } catch (SQLException e) { System.out.println("添加错误 添加错误:" + e.getMessage()); 添加错误 }finally{ DBConnection.CloseDB(conn, null, pstmt, null); } } //通过 ID
查询学生信息 并存放到 Bean 中 查询学生信息,并存放到 通过 public StudentBean PrepareUpdateStudent(Connection Exception{ StudentBean sb =new StudentBean();
conn,int
id)
throws
PreparedStatement pstmt= conn.prepareStatement(SQL_GET_STUDENT); pstmt.setInt(1, id); ResultSet rs =pstmt.executeQuery(); if(rs.next()){ sb.setStudID(rs.getInt("studID")); sb.setStudName(rs.getString("studName")); sb.setStudAge(rs.getInt("studAge")); sb.setStudSex(rs.getString("studSex")); } DBConnection.CloseDB(conn, null, pstmt, rs); return sb; } //修改学生信息 修改学生信息 public void UpdateStudent(Connection conn, StudentBean sb) throws Exception { PreparedStatement pstmt = null; try { pstmt = conn.prepareStatement(SQL_UPDATE); pstmt.setString(1, sb.getStudName());
pstmt.setInt(2, sb.getStudAge()); pstmt.setString(3, sb.getStudSex()); pstmt.setInt(4, sb.getStudID()); pstmt.executeUpdate(); } catch (Exception e) { System.out.println("修改错误 修改错误:" + e.getMessage()); 修改错误 } finally { DBConnection.CloseDB(conn, null, pstmt, null); } } }
/*
在页面上显示
index.jsp
*/
<% StudentDao sd= new StudentDao(); //获取所有学生信息 获取所有学生信息 ArrayList arraylist=sd.ListStudent(DBConnection.GetConnection()); //通过 通过for循环将学生信息打印到页面上 用表格的形式显示 循环将学生信息打印到页面上,用表格的形式显示 通过 循环将学生信息打印到页面上 for(int i=0;i (i); %> <%=sb.getStudID() %> | <%=sb.getStudName() %> | <%=sb.getStudAge() %> | <%=sb.getStudSex() %> | 删除 删除 | 删除 JSP?ID=<%=SB.GETSTUDID()%>修改 修改 | 修改
<% }%>
/*
准备增加页面 preAdd.jsp
*/
/*
增加页面 add.jsp
*/
<%@ page import="com.accp.logic.StudentDao"%> <%@ page import="com.accp.db.DBConnection"%> <%@ page import="com.accp.beans.StudentBean"%> <% request.setCharacterEncoding("GBK"); StudentBean sb= new StudentBean(); StudentDao sd = new StudentDao(); St