companydao.java~1~

销售管理系统 随着我国国民经济的持续发展

package com.dao;

import com.tool.JDBConnection;
import com.domain.CompanyVO;
import java.sql.*;

//本公司表的操作
public class CompanyDao {
  private JDBConnection connection = null;
  public CompanyDao() {
    connection = new JDBConnection();
    this.connection.creatConnection(); //利用构造方法调用类中的对象对数据库创建连接
  }

//公司表的内容的查询
  public CompanyVO selectCompany() {
    CompanyVO company = new CompanyVO();
    String sql = "select * from tb_company";
    ResultSet rs = connection.executeQuery(sql);
      while (rs.next()) {}
    return company;
  }

}