Вход на сайт
Datenbankabfrage mit Java
73
NEW 12.02.04 14:18
Priwet wsem!
Ja nowichok w Java i dolzhen koe-chto sdelat:
Na SQL-Servere est tabliza. Ja dolzhen umet wybirat s tablizy dannye, ne ispolzuja SELECT.... naprimer prosto dannye so stroki X i stolbza Y.
Podskazhite pozhaluista, kak eto sdelat?
spasibooooo
Ja nowichok w Java i dolzhen koe-chto sdelat:
Na SQL-Servere est tabliza. Ja dolzhen umet wybirat s tablizy dannye, ne ispolzuja SELECT.... naprimer prosto dannye so stroki X i stolbza Y.
Podskazhite pozhaluista, kak eto sdelat?
spasibooooo
NEW 12.02.04 15:41
в ответ FranziScanner 12.02.04 14:18
Class.forName("<driverName>",0);
Connection con = DriverManager.
getConnection("<connectURL>","<username>","<pw>",0);
Statement stmt = con.createStatement(,0);
ResultSet rs = stmt.executeQuery("select Y from X where....",0);
In java geht's nicht anders.
Connection con = DriverManager.
getConnection("<connectURL>","<username>","<pw>",0);
Statement stmt = con.createStatement(,0);
ResultSet rs = stmt.executeQuery("select Y from X where....",0);
In java geht's nicht anders.
NEW 12.02.04 20:30
в ответ FranziScanner 12.02.04 15:46
......
Statement befehl = null;
Connection verbindung = null;
int i;
try {
verbindng=DriverManager.getConnection(URL,benutzername,passwort,0);
befehl=verbindung.createStatement(,0);
}
catch(Exception e)
{
..........}
try{
ResultSet res;
res=befehl.executeQuery("select * from table",0);
while(res.next())
{
if(i>12){
System.out.println(res.getString("Row_name"),0);
.........
i++;
}else{
//..nothing
}
verbindung.close(,0);
}
catch(Exception e){
e.printStackTrace(,0);
}
Statement befehl = null;
Connection verbindung = null;
int i;
try {
verbindng=DriverManager.getConnection(URL,benutzername,passwort,0);
befehl=verbindung.createStatement(,0);
}
catch(Exception e)
{
..........}
try{
ResultSet res;
res=befehl.executeQuery("select * from table",0);
while(res.next())
{
if(i>12){
System.out.println(res.getString("Row_name"),0);
.........
i++;
}else{
//..nothing
}
verbindung.close(,0);
}
catch(Exception e){
e.printStackTrace(,0);
}