Denne koden er å koble Micrososft SQL-database med Callable statement ved hjelp av Java. Callable statement, parameter og SQL Driver URL ringer fra egenskapsfilen. Når den er koblet til databasen, fyller den alle verdier i en bestemt kolonne basert på spørringen. Du kan skrive ut SQL-databaseutgang til en fil.
Koble MS SQL med eiendomsfil og 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;
offentlig klasse DBConnect {
privat streng dbValue;
offentlig String getDbValue () {
returnere dbValue;
}
offentlig tomgang setDbValue (String dbValue) {
this.dbValue = dbValue;
}
offentlig statisk String callStoredProc () {
InputStream input = null;
ResultSet rs = null;
PreparedStatement ps = null;
Tilkobling con = null;
Stringresultat = null;
prøv {
String propPath = ". \ Src \ props \ db.properties"; // eiendomsfil
input = ny FileInputStream (propPath);
Egenskaper prop = nye egenskaper ();
prop.load (input); // laste eiendomsfilen
// få eiendomsverdien
String dbDriver = (prop.getProperty ("dbDriver")); // driver fra db.properties
String dbURL = (prop.getProperty ("dbURL"));
Class.forName (dbDriver);
con = DriverManager.getConnection (dbURL);
// Lagret prosedyreanrop
String stPro = (prop.getProperty ("SPSql1"));
ps = con.prepareStatement (stPro);
ps.setEscapeProcessing (true);
ps.setQueryTimeout (90); // timeout verdi
ps.setString (1, prop.getProperty ("VALUE1"));
ps.setString (2, prop.getProperty ("VALUE2"));
ps.setString (3, prop.getProperty ("VALUE3"));
rs = ps.executeQuery ();
rs.next ();
// Velg tilfeldig verdi fra DB-området 1-100
int tilfeldig = (int) (Math.random () * 100 + 1);
int i = 0;
mens (jeg <tilfeldig) {
rs.next ();
i ++;
}
result = (rs.getString ("row_name")); //prop.getProperty("dbRow”)
prop.getProperty ( “dbRow”);
prop.getProperty ( “verdi2”);
} fangst (IOException e) {
e.printStackTrace ();
} fangst (ClassNotFoundException e) {
e.printStackTrace ();
} fangst (SQLException e) {
e.printStackTrace ();
} endelig {
prøv {
hvis (rs! = null)
input.close ();
hvis (rs! = null)
rs.close ();
hvis (ps! = null)
ps.close ();
hvis (con! = null)
con.close ();
} fangst (unntak e) {
e.printStackTrace ();
}
}
returresultat;
}
}
// slutten av klassen
// eiendomsfil
/ * db.properties * /
dbDriver = com.microsoft.sqlserver.jdbc.SQLServerDriver
dbURL = jdbc: SQLServer: SERVER_URL; database = DB_NAME, user = BRUKERNAVN, password = PASSORD
VALUE1 = aaa
VALUE2 = bbb
VALUE3 = ccc
SPSql1 = {call storeprecdurecall (?, ?, ?)}
dbRow = ROW_NAME
DB_USERNAME = uname
Db = passord
Dette bestemte eksempelet, dataene er iterating fra bordet og plukker en tilfeldig verdi fra resultatet. I dette spesielle eksempel settes vi til en verdi 100, og utgangen vil velge en tilfeldig verdi mellom 1-100 av tabellresultatet.