1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35
|
import java.sql.*;
public class LoadJdbcOdbcDriver {
public static void main(String[] args) {
Connection con = null;
try {
// Load the JDBC-ODBC bridge driver
Class.forName("oracle.jdbc.driver.OracleDriver");
String url = "jdbc:oracle:thin:@192.168.0.181:1521:XE";
con = DriverManager.getConnection(url, "men", "men");
Statement stmt = con
.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
ResultSet.CONCUR_READ_ONLY);
ResultSet srs = stmt
.executeQuery("SELECT * FROM profil");
String requete=new String ( "insert into `pays` values ('001','ZA','人材募集','Japon');".getBytes(), "UTF-8" );
srs = stmt.executeQuery(requete);
while (srs.next()) {
int name = srs.getInt(1);
String price_ = srs.getString(2);
String price2_ = srs.getString(3);
//String price=new String ( price_.getBytes(), "UTF-8" );
//String price=new String ( price_.getBytes(), "UTF-8" );
System.out.println(name + " " + price_+ " "+ price2_);
}
} catch (Exception e) {
System.err.println("Exception: " + e.getMessage());
}
}
} |
Partager