updatestudentaction.java~2~

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

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 addStudent(Student student) {
       PreparedStatement pstmt = null;
       String str = "";
       try {
           if (conn == null) {
               this.setConn();
           }
           pstmt = conn.prepareStatement("insert into student values(?,?,?,?)");
           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;
   }


}