khregist.java

来自「进销存管理系统是一个典型的数据库开发应用程序」· Java 代码 · 共 38 行

package com.mingri.info;

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

public class KhRegist {
	private KhinfoBean khinfo;
	DBResult rst = new DBResult();

	public void setKhinfo(KhinfoBean khinfo) {
		this.khinfo = khinfo;
	}

	public void regist() throws Exception {
		String reg = "insert into tb_customer values(?,?,?,?,?,?,?,?,?,?,?)";
		try {
			PreparedStatement pstmt = rst.getPreparedStatement(reg);
			// 创建一个预处理语句，然后设置他们的参数
			pstmt.setString(1, khinfo.getKhname());
			pstmt.setString(2, khinfo.getKhjc());
			pstmt.setString(3, khinfo.getAddress());
			pstmt.setString(4, khinfo.getPostcode());
			pstmt.setString(5, khinfo.getTel());
			pstmt.setString(6, khinfo.getFax());
			pstmt.setString(7, khinfo.getLxr());
			pstmt.setString(8, khinfo.getLxrtel());
			pstmt.setString(9, khinfo.getEmail());
			pstmt.setString(10, khinfo.getKhyh());
			pstmt.setString(11, khinfo.getYhzh());
			// 执行更新操作
			pstmt.executeUpdate();
		} catch (Exception e) {
			e.printStackTrace();
			throw e;
		}
	}
}