Kode ini adalah untuk menghubungkan basis data Micrososft SQL dengan pernyataan Callable menggunakan Java. Pernyataan callable, parameter, dan URL Driver SQL memanggil dari file properti. Setelah terhubung ke database, itu mengisi semua nilai dalam kolom tertentu berdasarkan permintaan. Anda dapat mencetak output database SQL ke file.
Hubungkan MS SQL dengan file properti dan 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;
DBConnect kelas publik {
dbValue String pribadi;
public String getDbValue () {
kembalikan dbValue;
}
setDbValue publik batal (String dbValue) {
this.dbValue = dbValue;
}
public String statis callStoredProc () {
InputStream input = null;
ResultSet rs = null;
PreparedStatement ps = null;
Koneksi con = nol;
Hasil string = nol;
coba {
String propPath = “. \ Src \ props \ db.properties”; // file properti
input = FileInputStream (propPath) baru;
Properti prop = Properti baru ();
prop.load (input); // muat file properti
// dapatkan nilai properti
String dbDriver = (prop.getProperty (“dbDriver”)); // driver dari db.properties
String dbURL = (prop.getProperty (“dbURL”));
Class.forName (dbDriver);
con = DriverManager.getConnection (dbURL);
// Panggilan prosedur tersimpan
String stPro = (prop.getProperty ("SPSql1"));
ps = con.prepareStatement (stPro);
ps.setEscapeProcessing (true);
ps.setQueryTimeout (90); // nilai batas waktu
ps.setString (1, prop.getProperty (“VALUE1”));
ps.setString (2, prop.getProperty (“VALUE2”));
ps.setString (3, prop.getProperty (“VALUE3”));
rs = ps.executeQuery ();
rs.next ();
// Pilih nilai acak dari rentang DB 1-100
int random = (int) (Math.random () * 100 +1);
int i = 0;
while (i <random) {
rs.next ();
i ++;
}
result = (rs.getString (“row_name”)); //prop.getProperty(58dbRow ”)
prop.getProperty ("dbRow");
prop.getProperty ("value2");
} catch (IOException e) {
e.printStackTrace ();
} catch (ClassNotFoundException e) {
e.printStackTrace ();
} catch (SQLException e) {
e.printStackTrace ();
} akhirnya {
coba {
if (rs! = null)
input.close ();
if (rs! = null)
rs.close ();
jika (ps! = null)
ps.close ();
if (con! = null)
con.close ();
} catch (Exception e) {
e.printStackTrace ();
}
}
hasil pengembalian;
}
}
// akhir kelas
// file properti
/*db.properties * /
dbDriver = com.microsoft.sqlserver.jdbc.SQLServerDriver
dbURL = jdbc: sqlserver: SERVER_URL; database = DB_NAME; pengguna = USERNAME; kata sandi = PASSWORD
VALUE1 = aaa
VALUE2 = bbb
VALUE3 = ccc
SPSql1 = {panggil storeprecdurecall (?, ?, ?)}
dbRow = row_name
DB_USERNAME = tidak terkenal
DB_PASSWORD = kata sandi
Contoh khusus ini, data iterasi dari tabel dan memilih nilai acak dari hasilnya. Dalam contoh khusus ini kita menetapkan ke nilai 100 dan output akan memilih nilai acak antara 1-100 oleh dari hasil tabel.