Thread: add image to database using java

You know how you connect to a server?

--- Update ---

And who database you will used?

--- Update ---

I think when you see this code you have a ide how you can do the :-)

import java.sql.*;
public class Databasekommunikation
{
public static void main(String[] arg) throws Exception
{
Class.forName("oracle.jdbc.driver.OracleDriver");
System.out.println("Driver indlæst");

Connection forb = DriverManager.getConnection(
"jdbcracle:thin:@ora.javabog.dk:1521:student","jacob"," jacob");
System.out.println("Forbindelse oprettet");

Statement stmt = forb.createStatement();

try { stmt.executeUpdate("drop table KUNDER"); } catch (Exception e) {}

stmt.executeUpdate("create table KUNDER (NAVN varchar(32), KREDIT number)");
System.out.println("Tabel oprettet");

stmt.executeUpdate("insert into KUNDER values('Jacob', -1799)");

stmt.executeUpdate("insert into KUNDER(NAVN,KREDIT) values('Brian', 0)");

String navn = "Hans";
double kredit = 500;
stmt.executeUpdate(
"insert into KUNDER(NAVN,KREDIT) values('"+navn+"', "+kredit+")");

ResultSet rs = stmt.executeQuery("select NAME, CREDIT from KUNDER");
while (rs.next())
{
name = rs.getString("NAME");
kredit = rs.getDouble("KREDIT");
System.out.println(navn+" "+kredit);
}
}
}


Driver indlæst
Forbindelse oprettet
Tabel oprettet
Jacob -1799.0
Brian 0.0
Hans 500.0

Example how you can send things to you database. Here was the database MySql :-)

Hope you can now. Or write here... You shall not see on they words you not understand just look on the programming.