managerdao.java~5~

来自「《struts应用开发完全手册》中的源代码及安装指导」· JAVA~5~ 代码 · 共 29 行

package com.dao;

import com.actionForm.ManagerForm;
import java.sql.ResultSet;

public class ManagerDao {
    private JDBConnection connection = null;
    public ManagerDao() {
        connection = new JDBConnection();
    }
//==============================================================================
    public void insertManager(ManagerForm form) {
        String sql = "insert into tb_manager values ('" + form.getAccount() +
                     "','" + form.getPassword() + "','" + form.getName() +
                     "','" + form.getAge() + "','" +
                     form.getSex() + "')";
        System.out.println("sql="+sql);
        connection.executeUpdate(sql);
        connection.closeConnection();
    }
    public ManagerForm selectOne(String account){
    ManagerForm form=null;
    String sql="select * from tb_manager where account='"+account+"'";
    ResultSet rs=connection.executeQuery(sql);
    while(rs.next()){
    
    }
    }
}