// JDBC // CallableStatement cs = null; try { cs = conn.preparecall("{call DUMMY_PROC(?,?)}"); cs.setstring(1, "This is a test"); cs.registeroutparame

Size: px

Start display at page:

Download "// JDBC // CallableStatement cs = null; try { cs = conn.preparecall("{call DUMMY_PROC(?,?)}"); cs.setstring(1, "This is a test"); cs.registeroutparame"

ひとおすみい
4 years ago
Views:

$// JDBC // CallableStatement cs = null; try { cs = conn.preparecall("{call DUMMY_PROC(?,?$

1 // JDBC // CallableStatement cs = null; try { cs = conn.preparecall("{call DUMMY_PROC(?,?)"); cs.setstring(1, "This is a test"); cs.registeroutparameter(2, Types.VARCHAR); cs.executequery();

2 // String returnstr = cs.getstring(2); catch (SQLException ex){ name="createemp", procedurename="create_emp", parameters = mode= ParameterMode.IN, type=string.class, mode = ParameterMode.IN, type=string.class, name="last") ) // StoredProcedureQuery qry = em.createstoredprocedurequery("createemp"); qry.setparameter("first", "JOSH"); qry.setparameter("last","juneau"); qry.execute(); String qry = "select "; CreateConnection. loadproperties(); issueslist = new ArrayList(); try (Connection conn = CreateConnection. getconnection(); Statement stmt = conn. createstatement(); ResultSet rs = stmt. executequery(qry);) {

3 stmt.setfetchsize(300); while (rs.next())... catch (SQLException e) { // public List<DukeIssues> findallconfigurefetchsize( String fetchsize){ Query qry = em.createquery( "select object(o) from DukeIssues o"); qry.sethint( "eclipselink.jdbc_fetch_size", fetchsize); return qry.getresultlist(); asadmin create-jdbc-connection-pool \ --datasourceclassname \ oracle.jdbc.pool.oracledatasource \ --restype javax.sql.datasource \ --property user=dbuser:password=dbpassword:url= "jdbc:oracle\:thin\:@localhost\:1521\:mydb" \ jdbc_conn-pool asadmin create-jdbc-connection-pool \

4 --connectionpoolid myjdbc_oracle-pool jdbc/resource ConnectionPoolDataSource cpds = (ConnectionPoolDataSource) initialctx.lookup(jndiname); PooledConnection pooledconn = ConnectionPoolDataSource.getConnection(); Connection conn = pooledconn.getconnection();

5 RowSetFactory factory; try { // RowSetFactory factory = RowSetProvider.newFactory(); // CachedRowSet crs = factory.createcachedrowset(); // CachedRowSet // // crs.setusername(username); // crs.setpassword(password); // crs.seturl(jdbc_url); // crs.setcommand("select id, request_date, "+ "priority, description from duke_issues"); // int[] keys = {1; crs.setkeycolumns(keys); // crs.execute(conn); // // while (crs.next()) { // catch (SQLException ex) { ex.printstacktrace(); public List<DukeIssues> queryissues(string assignedto) { String qry = "SELECT ID, REQUEST_DATE, PRIORITY, DESCRIPTION " + "FROM DUKE_ISSUES " + "WHERE assigned_to =?"; List<DukeIssues> issuelist = new ArrayList(); try (Connection conn = CreateConnection.getConnection(); PreparedStatement stmt = conn.preparestatement(qry))

6 { stmt.setstring(1, assignedto); try (ResultSet rs = stmt.executequery();) { while (rs.next()) { int id = rs.getint("id"); java.util.date requestdate = rs.getdate("request_date"); int priority = rs.getint("priority"); String description = rs.getstring("description"); DukeIssues issue = new DukeIssues(); issue.setid(id); issue.setrequestdate(requestdate); issue.setpriority(priority); issue.setdescription(description); issuelist.add(issue); catch (SQLException e) { e.printstacktrace(); return issuelist; String insstmt1 = "insert into duke_issues (id, request_date," + "priority, description) values " + "(908472, ' ',0,'QUERY NOT WORKING')"; String insstmt2 = "insert

7 into duke_issues " + "(id, request_date, priority, description) values " + "(908473, ' ',0,'RESULTS NOT POSTING')"; String updstmt = "insert duke_issues " + "set status =? where assigned_to =?"; try (Connection conn = getconnection(); Statement stmt = conn.createstatement();) { conn.setautocommit(false); // // stmt.addbatch(insstmt1); stmt.addbatch(insstmt2); stmt.addbatch(updstmt); int[] count = stmt.executebatch(); conn.commit(); conn.setautocommit(true); catch (SQLException e) { // <persistence-unit>... <property name="eclipselink.jdbc.batch-writing" value="jdbc"/> <property name="eclipselink.jdbc.batch-writing. size" value="1000"/>... </persistence-unit>

tkk0408nari

tkk0408nari SQLStatement Class Sql Database SQL Structured Query Language( ) ISO JIS http://www.techscore.com/tech/sql/02_02.html Database sql Perl Java SQL ( ) create table tu_data ( id integer not null, -- id aid