See kood on mõeldud Micrososft SQL andmebaasi ühendamiseks Callable avaldusega Java abil. Callable avaldus, parameeter ja SQL Driver URL kutsuvad omaduste failist. Kui see on andmebaasiga ühendatud, siis ta arvutab kõik väärtused konkreetses veerus päringu alusel. Saate SQL-andmebaasi väljundi välja printida.
Ühendage MS SQL omandi faili ja kutsutava avaldusega
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;
avaliku klassi DBConnect {
privaatne String dbValue;
avalik String getDbValue () {
tagastab dbValue;
}
public void setDbValue (String dbValue) {
this.dbValue = dbValue;
}
avalik staatiline stringikõneStoredProc () {
InputStream sisend = null;
ResultSet rs = null;
PreparedStatement ps = null;
Connection con = null;
String tulemus = null;
proovige {
String propPath = ". \ T // omandi fail
input = uus FileInputStream (propPath);
Omadused prop = uued atribuudid ();
prop.load (sisend); // koormusfaili laadimine
// saada vara väärtus
String dbDriver = (prop.getProperty (“dbDriver”)); // draiver db.properties'ist
String dbURL = (prop.getProperty (“dbURL”));
Klass.Nimi (dbDriver);
con = DriverManager.getConnection (dbURL);
// Salvestatud protseduurikõne
String stPro = (prop.getProperty (“SPSql1”));
ps = con.prepareStatement (stPro);
ps.setEscapeProcessing (true);
ps.setQueryTimeout (90); // timeout väärtus
ps.setString (1, prop.getProperty (“VALUE1”));
ps.setString (2, prop.getProperty (“VALUE2”));
ps.setString (3, prop.getProperty (“VALUE3”));
rs = ps.executeQuery ();
rs.next ();
// Valida juhuslik väärtus DB vahemikust 1-100
int random = (int) (Math.random () * 100 + 1);
int i = 0;
samas (i <juhuslik) {
rs.next ();
i ++;
}
tulemus = (rs.getString (“rea_nimi”)); //prop.getProperty( "dbRow ”)
prop.getProperty (“dbRow”);
prop.getProperty (“väärtus2”);
} saak (IOException e) {
e.printStackTrace ();
} saak (ClassNotFoundException e) {
e.printStackTrace ();
} saak (SQLException e) {
e.printStackTrace ();
} lõpuks {
proovige {
kui (rs! = null)
input.close ();
kui (rs! = null)
rs.close ();
kui (ps! = null)
ps.close ();
kui (con! = null)
con.close ();
} saak (erand e) {
e.printStackTrace ();
}
}
tagastamise tulemus;
}
}
// klassi lõpp
// omandi fail
/*db.properties * /
dbDriver = com.microsoft.sqlserver.jdbc.SQLServerDriver
dbURL = jdbc: sqlserver: SERVER_URL; andmebaas = DB_NAME; kasutaja = USERNAME; parool = SALASÕNA
VALUE1 = aaa
VALUE2 = bbb
VALUE3 = ccc
SPSql1 = {call storeprecdurecall (?, ?, ?)}
dbRow = rea_nimi
DB_USERNAME = uname
DB_PASSWORD = parool
See konkreetne näide, andmed korduvad tabelist ja valivad tulemusest juhusliku väärtuse. Selles konkreetses näites seadsime väärtusele 100 ja väljund valib juhusliku väärtuse vahemikus 1-100 tabeli tulemusest.