gysregist.java

来自「企业进销存管理系统 主要包括：基础信息管理、库存管理、商品销售、查询统计、往来管」· Java 代码 · 共 39 行

package com.mingri.info;

import com.mingri.dbconn.DBResult;
import java.sql.*;

public class GysRegist
{
  private GysinfoBean gysinfo;
  DBResult rst=new DBResult();
  public void setGysinfo(GysinfoBean gysinfo)
  {
    this.gysinfo=gysinfo;
  }
  public void regist()throws Exception
  {
    String sql="insert into tb_supplier values(?,?,?,?,?,?,?,?,?,?)";
    try
    {
      PreparedStatement pstmt=rst.getPreparedStatement(sql);
      pstmt.setString(1,gysinfo.getGysname());
      pstmt.setString(2,gysinfo.getJc());
      pstmt.setString(3,gysinfo.getAddress());
      pstmt.setString(4,gysinfo.getPostcode());
      pstmt.setString(5,gysinfo.getTel());
      pstmt.setString(6,gysinfo.getFax());
      pstmt.setString(7,gysinfo.getLxr());
      pstmt.setString(8,gysinfo.getLxrtel());
      pstmt.setString(9,gysinfo.getKhyh());
      pstmt.setString(10,gysinfo.getEamil());
      pstmt.executeUpdate();
    }
    catch(Exception e)
    {
      e.printStackTrace();
      throw e;
    }
  }
}