jobdao.java~2~

来自「对2000元以上的资产管理」· JAVA~2~ 代码 · 共 43 行

package com.cdaccp.dao;

import java.sql.Connection;
import com.util.DBAccess;
import java.sql.PreparedStatement;

/**
 * <p>Title: </p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2008</p>
 *
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */
public class JobDAO {
  public JobDAO() {
  }
  public static boolean addJob(String name){
    String sql = "insert job values (?)";
    Connection con = DBAccess.getConnection();
    PreparedStatement pst = null;
    try {
      pst = con.prepareStatement(sql);
      pst.setString(1,name);
      int i = pst.executeUpdate();
      if(i > 0){
        return true;
      }
    }
    catch (Exception ex) {
      ex.printStackTrace();
    }finally{
      DBAccess.closeStatement(pst);
      DBAccess.closeConnection(con);
    }
    return false;
  }
}