behitek

import java.io.FileInputStream;
import java.io.FileOutputStream;
import java.io.IOException;
import java.io.InputStream;
import java.util.Iterator;

import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;

behitek

Hiếu Nguyễn

behitek

/*
 * 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 test;

import java.awt.*;
import java.awt.event.*;
import javax.swing.*;

behitek

Cập nhật số lượng sách khi thay đổi trên tb_CTPN

1

ALTER TRIGGER [dbo].[tg_DeleteCTPN]
   ON  [dbo].[tb_CTPN]
   For delete
AS 
BEGIN
	Declare @soLuong int

behitek

Xuất jTable sang file Excel

Hàm thực thi đọc dữ liệu từ jTable vào file Excel

public static void toExcel(JTable table, File file) throws IOException {
        String sheetName = "Sheet1";//name of sheet
        HSSFWorkbook wb = new HSSFWorkbook();
        HSSFSheet sheet = wb.createSheet(sheetName);
        TableModel model = table.getModel();
        //Get colum name
 HSSFRow row = sheet.createRow(0);

behitek

public class PlaySchoolClock {

    public static void main(String[] args) {
        new PlaySchoolClock();
    }

    public PlaySchoolClock() {
        EventQueue.invokeLater(new Runnable() {
            @Override
            public void run() {

behitek

#include <stdio.h>
#include <string.h>

void nhap(char c[]){
	char ch;
	int i = 0;
	do{
		scanf("%c",&ch);
		if(ch != 'k'){
			c[i] = ch;

behitek

#include <stdio.h>
#include <conio.h>


void nhapMang (int a[],int n){
	for(int i = 0;i < n;i++){
		scanf("%d",&a[i]);
	}
}

behitek

/*
 * 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 bookstore.DAL;

import bookstore.Entity.NhaXuatBan;
import java.sql.PreparedStatement;
import java.sql.ResultSet;

behitek

package learn;
import java.sql.*;
import java.util.logging.Level;
import java.util.logging.Logger;
import javax.swing.JOptionPane;

public class mySqlConnect{
    
    protected Connection con = null;
    protected Statement stm = null;