updatestudentaction.java~5~

来自「java(Swing) access做的成绩管理系统」· JAVA~5~ 代码 · 共 57 行

package edu.xscj.action;

import java.sql.Connection;
import edu.xscj.conn.ConnectDataBase;
import edu.xscj.bean.Student;
import java.sql.PreparedStatement;

public class UpdateStudentAction {
    Connection conn = null;

    public UpdateStudentAction() {
        if (conn == null) {
            conn = ConnectDataBase.getConn();
        }
    }

    public void setConn() {
        if (conn == null) {
            conn = ConnectDataBase.getConn();
        }
    }

    public String updateStudent(Student student) {
        PreparedStatement pstmt = null;
        String str = "";
        try {
            if (conn == null) {
                this.setConn();
            }
            pstmt = conn.prepareStatement(
                    "update student set  stuName=?,stuSex=?,stuBirthday=? where stuNo=?)");
            pstmt.setString(1, student.getStuNo());
            pstmt.setString(2, student.getStuName());
            pstmt.setString(3, student.getStuSex());
            pstmt.setDate(4, student.getStuBirthday());
            pstmt.execute();
            str = "sucess";
        } catch (Exception ex) {
            str = "failer";
        } finally {
            try {
                if (pstmt != null) {
                    pstmt.close();
                }
                if (conn != null) {
                    conn.close();
                }
            } catch (Exception e) {
                e.printStackTrace();
            }
        }
        return str;
    }


}