1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61
| *
* To change this template, choose Tools | Templates
* and open the template in the editor.
*/
package com.myapp.struts;
import java.util.Date;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.Statement;
import javax.naming.Context;
import javax.naming.InitialContext;
import javax.sql.DataSource;
/**
*
* @author admin
*/
public class Reket {
public String designation,requette,msgex;
public byte[] datac;
public Reket (String des,byte[] photo)
{
designation=des;
datac=photo;
requette="insert into files (name,contenu) values ('"+designation+"','"+datac+"')";
}
public void Inserer()
{
try
{
System.out.println("vvvvvvvvv");
Context context = new InitialContext();
DataSource datasource = (DataSource) context.lookup("java:comp/env/jdbc/interface");
Connection connect = datasource.getConnection();
Statement aStmt = connect.createStatement();
int aRSet = aStmt.executeUpdate(requette);
if(aRSet>0)
{
System.out.print("L'insetion est bien faite avec success");
}
else
System.out.print("L'insetion n'est pas faite ");
aStmt.close();
connect.close();
}
catch(Exception e)
{
System.out.println("yyyyyyyyy");
msgex=e.getMessage();
e.printStackTrace();
}
}
} |
Partager