Ta koda je namenjena povezavi Micrososft SQL baze podatkov s stavkom Callable z uporabo Java. Callable stavek, parameter in URL gonilnika SQL kličejo iz datoteke lastnosti. Ko se poveže z bazo podatkov, zapolni vse vrednosti v določenem stolpcu glede na poizvedbo. Izpis podatkovne baze SQL lahko natisnete v datoteko.
Povežite MS SQL s datoteko lastnosti in Callable Statement
import java.util.Properties; import java.util.Random; import java.io.FileInputStream; import java.io.IOException; import java.io.InputStream; import java.sql.DriverManager; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException;
import java.util.Properties; import java.util.Random; import java.io.FileInputStream; import java.io.IOException; import java.io.InputStream; import java.sql.DriverManager; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException;
import java.util.Properties; import java.util.Random; import java.io.FileInputStream; import java.io.IOException; import java.io.InputStream; import java.sql.DriverManager; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException;
import java.util.Properties; import java.util.Random; import java.io.FileInputStream; import java.io.IOException; import java.io.InputStream; import java.sql.DriverManager; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException;
import java.util.Properties; import java.util.Random; import java.io.FileInputStream; import java.io.IOException; import java.io.InputStream; import java.sql.DriverManager; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException;
import java.util.Properties; import java.util.Random; import java.io.FileInputStream; import java.io.IOException; import java.io.InputStream; import java.sql.DriverManager; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException;
import java.util.Properties; import java.util.Random; import java.io.FileInputStream; import java.io.IOException; import java.io.InputStream; import java.sql.DriverManager; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException;
import java.util.Properties; import java.util.Random; import java.io.FileInputStream; import java.io.IOException; import java.io.InputStream; import java.sql.DriverManager; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException;
import java.util.Properties; import java.util.Random; import java.io.FileInputStream; import java.io.IOException; import java.io.InputStream; import java.sql.DriverManager; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException;
import java.util.Properties; import java.util.Random; import java.io.FileInputStream; import java.io.IOException; import java.io.InputStream; import java.sql.DriverManager; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException;
javni razred DBConnect {
zasebni niz dbValue;
public String getDbValue () {
vrne dbValue;
}
public void setDbValue (niz dbValue) {
this.dbValue = dbValue;
}
javni statični String callStoredProc () {
InputStream input = null;
ResultSet rs = null;
PreparedStatement ps = null;
Povezava con = null;
Rezultat niza = null;
poskusi {
String propPath = “. \ T // lastnost datoteke
input = new FileInputStream (propPath);
Lastnosti prop = novo Lastnosti ();
prop.load (vhod); // naloži datoteko lastnosti
// dobimo vrednost lastnosti
Niz dbDriver = (prop.getProperty (“dbDriver”)); // gonilnik iz db.properties
Niz dbURL = (prop.getProperty (“dbURL”));
Class.forName (dbDriver);
con = DriverManager.getConnection (dbURL);
// Klic shranjenega postopka
Niz stPro = (prop.getProperty (“SPSql1”));
ps = con.prepareStatement (stPro);
ps.setEscapeProcessing (true);
ps.setQueryTimeout (90); // vrednost prekinitve
ps.setString (1, prop.getProperty (“VALUE1”));
ps.setString (2, prop.getProperty (“VALUE2”));
ps.setString (3, prop.getProperty (“VALUE3”));
rs = ps.executeQuery ();
rs.next ();
// Izberemo naključno vrednost iz območja DB od 1-100
int random = (int) (Math.random () * 100 + 1);
int i = 0;
medtem ko (i <naključno) {
rs.next ();
i ++;
}
result = (rs.getString (“ime-vrstice”)); //prop.getProperty(´dbRow “)
prop.getProperty (“dbRow”);
prop.getProperty (“value2”);
} catch (IOException e) {
e.printStackTrace ();
} catch (ClassNotFoundException e) {
e.printStackTrace ();
} catch (SQLException e) {
e.printStackTrace ();
} končno {
poskusi {
če (rs! = null)
input.close ();
če (rs! = null)
rs.close ();
če (ps! = null)
ps.close ();
če (con! = null)
con.close ();
} catch (Exception e) {
e.printStackTrace ();
}
}
rezultat vrnitve;
}
}
// konec razreda
// lastnost datoteke
/*db.properties * /
dbDriver = com.microsoft.sqlserver.jdbc.SQLServerDriver
dbURL = jdbc: sqlserver: SERVER_URL; baza podatkov = DB_NAME; uporabnik = USERNAME; geslo = Geslo
VALUE1 = aaa
VALUE2 = bbb
VALUE3 = ccc
SPSql1 = {pokliči shranite predklic (?, ?, ?)}
dbRow = ime-vrstice
DB_USERNAME = uname
DB_PASSWORD = geslo
V tem primeru se podatki ponovijo iz tabele in iz rezultata izberejo naključno vrednost. V tem posebnem primeru nastavimo na vrednost 100 in izhod bo izbral naključno vrednost med 1-100 od rezultata tabele.