• Home
• com.github.youyinnn
• you-db-utils
• 1.3
• source code
• ADao.java

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

com.lab.dao.a.ADao Maven / Gradle / Ivy

package com.lab.dao.a;

import com.lab.model.Company;
import com.github.youyinnn.youdbutils.dao.YouDao;
import com.github.youyinnn.youdbutils.exceptions.NoneffectiveUpdateExecuteException;
import com.github.youyinnn.youdbutils.dao.SqlExecutor;

/**
 *
 * @author youyinnn
 *
 */
public class ADao extends YouDao {

    private static SqlExecutor sqlExecuteHandler = new SqlExecutor();

    public void aa() throws NoneffectiveUpdateExecuteException {
        String sql = "INSERT INTO COMPANY (ID,NAME,AGE,ADDRESS,SALARY)" +
                "VALUES (1,'paul',22,'California',30000) ;";


        String sql1 = "INSERT INTO COMPANY (ID,NAME,AGE,ADDRESS,SALARY)" +
                "VALUES (2,'Jame',21,'Norway',50000) ;";


        System.out.println(sqlExecuteHandler.executeStatementUpdate(sql));

        System.out.println(sqlExecuteHandler.executeStatementUpdate(sql1));
    }

    public void bb() throws NoneffectiveUpdateExecuteException {
        String sql = "INSERT INTO COMPANY (ID,NAME,AGE,ADDRESS,SALARY)" +
                "VALUES (2,'Jame',21,'Norway',50000) ;";

        System.out.println(sqlExecuteHandler.executeStatementUpdate(sql));
    }
}