// Path: DB_and_virustotal_submission/MalwareAnalysisDBProject/src/com/progetto_sicurezza/dbconfig/DBConfiguration.java
// public class DBConfiguration
// {
// 	public static final String DB_URL = "jdbc:mysql://localhost:3306/malware_data_collection";
// 	public static final String USERNAME ="root";
// 	public static final String PASSWORD = "";
// }
// 
// Path: DB_and_virustotal_submission/MalwareAnalysisDBProject/src/com/progetto_sicurezza/model/ScanPostTrans.java
// public class ScanPostTrans
// {
// 	private Integer id;
// 	private Integer idMalware;
// 	private Integer idAntiMalware;
// 	private String scanResultIsMalicious;
// 	private Boolean dissAndReass;
// 	private Boolean repacking;
// 	private Boolean callIndirection;
// 	private Boolean changingPackage;
// 	private Boolean changingClassname;
// 	private Boolean dataEncoding;
// 	private Boolean junkNop;
// 	private Boolean junkNopUncJump;
// 	private Boolean junkRandomGarbage;
// 	private Boolean signatureRewriting;
// 	private Boolean codeReorder;
// 	private String amSignatureUpdateId;
// 
// 
// 	public String getAmSignatureUpdateId() {
// 		return amSignatureUpdateId;
// 	}
// 	public void setAmSignatureUpdateId(String amSignatureUpdateId) {
// 		this.amSignatureUpdateId = amSignatureUpdateId;
// 	}
// 	public Boolean isCodeReorder() {
// 		return codeReorder;
// 	}
// 	public void setCodeReorder(boolean codeReorder) {
// 		this.codeReorder = codeReorder;
// 	}
// 
// 	public Integer getIdMalware() {
// 		return idMalware;
// 	}
// 	public void setIdMalware(int idMalware) {
// 		this.idMalware = idMalware;
// 	}
// 	public Integer getIdAntiMalware() {
// 		return idAntiMalware;
// 	}
// 	public void setIdAntiMalware(int idAntiMalware) {
// 		this.idAntiMalware = idAntiMalware;
// 	}
// 	public String getScanResultIsMalicious() {
// 		return scanResultIsMalicious;
// 	}
// 	public void setScanResultIsMalicious(String isMaliciousPreTransf) {
// 		this.scanResultIsMalicious = isMaliciousPreTransf;
// 	}
// 	public Integer getId() {
// 		return id;
// 	}
// 	public void setId(int id) {
// 		this.id = id;
// 	}
// 	public Boolean isDissAndReass() {
// 		return dissAndReass;
// 	}
// 	public void setDissAndReass(boolean dissAndReass) {
// 		this.dissAndReass = dissAndReass;
// 	}
// 	public Boolean isRepacking() {
// 		return repacking;
// 	}
// 	public void setRepacking(boolean repacking) {
// 		this.repacking = repacking;
// 	}
// 	public Boolean isCallIndirection() {
// 		return callIndirection;
// 	}
// 	public void setCallIndirection(boolean callIndirection) {
// 		this.callIndirection = callIndirection;
// 	}
// 	public Boolean isChangingPackage() {
// 		return changingPackage;
// 	}
// 	public void setChangingPackage(boolean changingPackage) {
// 		this.changingPackage = changingPackage;
// 	}
// 	public Boolean isChangingClassname() {
// 		return changingClassname;
// 	}
// 	public void setChangingClassname(boolean changingClassname) {
// 		this.changingClassname = changingClassname;
// 	}
// 	public Boolean isDataEncoding() {
// 		return dataEncoding;
// 	}
// 	public void setDataEncoding(boolean dataEncoding) {
// 		this.dataEncoding = dataEncoding;
// 	}
// 	public Boolean isJunkNop() {
// 		return junkNop;
// 	}
// 	public void setJunkNop(boolean junkNop) {
// 		this.junkNop = junkNop;
// 	}
// 	public Boolean isJunkNopUncJump() {
// 		return junkNopUncJump;
// 	}
// 	public void setJunkNopUncJump(boolean junkNopUncJump) {
// 		this.junkNopUncJump = junkNopUncJump;
// 	}
// 	public Boolean isJunkRandomGarbage() {
// 		return junkRandomGarbage;
// 	}
// 	public void setJunkRandomGarbage(boolean junkRandomGarbage) {
// 		this.junkRandomGarbage = junkRandomGarbage;
// 	}
// 	public Boolean isSignatureRewriting() {
// 		return signatureRewriting;
// 	}
// 	public void setSignatureRewriting(boolean updateSignature) {
// 		this.signatureRewriting = updateSignature;
// 	}
// }


import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import com.progetto_sicurezza.dbconfig.DBConfiguration;
import com.progetto_sicurezza.model.ScanPostTrans;
package com.progetto_sicurezza.dao;



public class ScanPostTransDao
{
	/*
	 * scanPost: tutti i campi di scanPost possono essere null tranne:
	 * idAntiMalware,idMalware,CallIndirection,ChangingClassname, 
	 * ChangingPackage, CodeReorder ,DataEncoding ,
	 * DissAndReass,isJunkNop,JunkNopUncJump,
	 * JunkRandomGarbage,scan.isRepacking,canResultIsMalicious
	 * canResultIsMalicious in set {"T","F"}
	 * 
	 */
// Path: DB_and_virustotal_submission/MalwareAnalysisDBProject/src/com/progetto_sicurezza/dbconfig/DBConfiguration.java
// public class DBConfiguration
// {
// 	public static final String DB_URL = "jdbc:mysql://localhost:3306/malware_data_collection";
// 	public static final String USERNAME ="root";
// 	public static final String PASSWORD = "";
// }
// 
// Path: DB_and_virustotal_submission/MalwareAnalysisDBProject/src/com/progetto_sicurezza/model/ScanPostTrans.java
// public class ScanPostTrans
// {
// 	private Integer id;
// 	private Integer idMalware;
// 	private Integer idAntiMalware;
// 	private String scanResultIsMalicious;
// 	private Boolean dissAndReass;
// 	private Boolean repacking;
// 	private Boolean callIndirection;
// 	private Boolean changingPackage;
// 	private Boolean changingClassname;
// 	private Boolean dataEncoding;
// 	private Boolean junkNop;
// 	private Boolean junkNopUncJump;
// 	private Boolean junkRandomGarbage;
// 	private Boolean signatureRewriting;
// 	private Boolean codeReorder;
// 	private String amSignatureUpdateId;
// 
// 
// 	public String getAmSignatureUpdateId() {
// 		return amSignatureUpdateId;
// 	}
// 	public void setAmSignatureUpdateId(String amSignatureUpdateId) {
// 		this.amSignatureUpdateId = amSignatureUpdateId;
// 	}
// 	public Boolean isCodeReorder() {
// 		return codeReorder;
// 	}
// 	public void setCodeReorder(boolean codeReorder) {
// 		this.codeReorder = codeReorder;
// 	}
// 
// 	public Integer getIdMalware() {
// 		return idMalware;
// 	}
// 	public void setIdMalware(int idMalware) {
// 		this.idMalware = idMalware;
// 	}
// 	public Integer getIdAntiMalware() {
// 		return idAntiMalware;
// 	}
// 	public void setIdAntiMalware(int idAntiMalware) {
// 		this.idAntiMalware = idAntiMalware;
// 	}
// 	public String getScanResultIsMalicious() {
// 		return scanResultIsMalicious;
// 	}
// 	public void setScanResultIsMalicious(String isMaliciousPreTransf) {
// 		this.scanResultIsMalicious = isMaliciousPreTransf;
// 	}
// 	public Integer getId() {
// 		return id;
// 	}
// 	public void setId(int id) {
// 		this.id = id;
// 	}
// 	public Boolean isDissAndReass() {
// 		return dissAndReass;
// 	}
// 	public void setDissAndReass(boolean dissAndReass) {
// 		this.dissAndReass = dissAndReass;
// 	}
// 	public Boolean isRepacking() {
// 		return repacking;
// 	}
// 	public void setRepacking(boolean repacking) {
// 		this.repacking = repacking;
// 	}
// 	public Boolean isCallIndirection() {
// 		return callIndirection;
// 	}
// 	public void setCallIndirection(boolean callIndirection) {
// 		this.callIndirection = callIndirection;
// 	}
// 	public Boolean isChangingPackage() {
// 		return changingPackage;
// 	}
// 	public void setChangingPackage(boolean changingPackage) {
// 		this.changingPackage = changingPackage;
// 	}
// 	public Boolean isChangingClassname() {
// 		return changingClassname;
// 	}
// 	public void setChangingClassname(boolean changingClassname) {
// 		this.changingClassname = changingClassname;
// 	}
// 	public Boolean isDataEncoding() {
// 		return dataEncoding;
// 	}
// 	public void setDataEncoding(boolean dataEncoding) {
// 		this.dataEncoding = dataEncoding;
// 	}
// 	public Boolean isJunkNop() {
// 		return junkNop;
// 	}
// 	public void setJunkNop(boolean junkNop) {
// 		this.junkNop = junkNop;
// 	}
// 	public Boolean isJunkNopUncJump() {
// 		return junkNopUncJump;
// 	}
// 	public void setJunkNopUncJump(boolean junkNopUncJump) {
// 		this.junkNopUncJump = junkNopUncJump;
// 	}
// 	public Boolean isJunkRandomGarbage() {
// 		return junkRandomGarbage;
// 	}
// 	public void setJunkRandomGarbage(boolean junkRandomGarbage) {
// 		this.junkRandomGarbage = junkRandomGarbage;
// 	}
// 	public Boolean isSignatureRewriting() {
// 		return signatureRewriting;
// 	}
// 	public void setSignatureRewriting(boolean updateSignature) {
// 		this.signatureRewriting = updateSignature;
// 	}
// }


// Path: DB_and_virustotal_submission/MalwareAnalysisDBProject/src/com/progetto_sicurezza/dao/ScanPostTransDao.java
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import com.progetto_sicurezza.dbconfig.DBConfiguration;
import com.progetto_sicurezza.model.ScanPostTrans;

package com.progetto_sicurezza.dao;



public class ScanPostTransDao
{
	/*
	 * scanPost: tutti i campi di scanPost possono essere null tranne:
	 * idAntiMalware,idMalware,CallIndirection,ChangingClassname, 
	 * ChangingPackage, CodeReorder ,DataEncoding ,
	 * DissAndReass,isJunkNop,JunkNopUncJump,
	 * JunkRandomGarbage,scan.isRepacking,canResultIsMalicious
	 * canResultIsMalicious in set {"T","F"}
	 * 
	 */
	public int insert(ScanPostTrans scanPost) throws SQLException