编写数据库常用的增、删、改、查代码(1)。

/*
 * To change this license header, choose License Headers in Project Properties.
 * To change this template file, choose Tools | Templates
 * and open the template in the editor.
 */
package com.s.dao.iml;


import com.s.bean.Manager;
import com.s.dao.sysManager;
import com.s.util.DBConnection;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;
import java.util.logging.Level;
import java.util.logging.Logger;


/**
 *
 * @author Administrator
 */
public class sysManagerimp implements sysManager {


    Connection conn = null;
    Statement stm = null;
    PreparedStatement pst = null;
    List<Manager> list = null;
    ResultSet rs = null;
    String sql = "select * from t_manager";


    public List<Manager> findManagerAll() {


        try {
            conn = DBConnection.getConnection();
            stm = conn.createStatement();
            rs = stm.executeQuery(sql);
            list = new ArrayList<Manager>();
            while (rs.next()) {
                Manager m = new Manager();
                m.setId(rs.getInt(1));
                m.setUsername(rs.getString(2));
                m.setPassword(rs.getString(3));
                list.add(m);
            }
        } catch (SQLException ex) {
            Logger.getLogger(sysManagerimp.class.getName()).log(Level.SEVERE, null, ex);
        } finally {
//            DBConnection.closeResultSet(rs);
//            DBConnection.closeStatement(stm);
//            DBConnection.closeConn(conn);
        }
        return list;
    }


    @Override
    public int addManager(String username, String password) {
        int row = 0;
        try {
            conn = DBConnection.getConnection();
            String sql1 = "  insert into t_manager (sysaccount,Syspassword) values (?,?)";
            pst = conn.prepareStatement(sql1);
            pst.setString(1, username);
            pst.setString(2, password);
            row = pst.executeUpdate();


        } catch (SQLException ex) {
            Logger.getLogger(sysManagerimp.class.getName()).log(Level.SEVERE, null, ex);
        }finally {
            DBConnection.closeResultSet(rs);
            DBConnection.closeStatement(stm);
            DBConnection.closeConn(conn);
        }


        return row;
    }


}