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 62 63 64 65 66 67 68 69 70 71 72 73
| package example;
import com.opensymphony.xwork2.ActionSupport;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
public class Acceuil extends ActionSupport
{
public static String description;
public static String logo;
private String nomDocument;
private String descriptionDocument;
private String logoEntreprise;
public String titre = null;
public void setNomDocument(String nomDocument)
{
this.nomDocument=nomDocument;
}
public String getNomDocument()
{
return nomDocument;
}
public void setDescriptionDocument(String descriptionDocument)
{
this.descriptionDocument=descriptionDocument;
}
public String getDescriptionDocument()
{
return descriptionDocument;
}
public void setLogoEntreprise(String logoEntreprise)
{
this.logoEntreprise=logoEntreprise;
}
public String getLogoEntreprise()
{
return logoEntreprise;
}
public String execute() throws Exception
{
Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
String connectionString= null;
try
{
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
try
{
connectionString ="jdbc:sqlserver://CSS;database=Bilan Prospectif;user=wael;password=09111985";}
catch (Exception e)
{
System.out.println(e.getMessage());
e.printStackTrace();
}
conn = DriverManager.getConnection(connectionString);
stmt = conn.createStatement();
rs = stmt.executeQuery("SELECT DESIGNATION_CAPITAL FROM CAPITAL where ID_CAPITAL=11");
while (rs.next())
{
titre=((rs.getString("DESIGNATION_CAPITAL")));
}
}
catch (Exception e)
{
System.out.println(e.getMessage());
e.printStackTrace();
}
return SUCCESS;
}
} |
Partager