Package com.bleujin.framework.db.rowset

Examples of com.bleujin.framework.db.rowset.WebRowSet

66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
        return writer.toString();
    }

    public String runSelectWebRowset() throws SQLException, IOException, ClassNotFoundException {

        WebRowSet webRs = null;
        webRs = new WebRowSet();
        // webRs.setCommand("select * from clob1") ;
        webRs.setCommand( "select * from emp where deptno = ?" );
        webRs.setInt( 1, 10 );

        getConnection();
        webRs.execute( conn );
        freeConnection( conn );

        // Writer writer = new FileWriter(new File("emp.xml")) ;
        Writer writer = new StringWriter();
        webRs.writeXml( writer );

        writer.flush();
        writer.close();

        return writer.toString();
View Full Code Here
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
        return writer.toString();
    }

    public void runUpdateWebRowset() throws SQLException, IOException, ClassNotFoundException {
        WebRowSet webRs = null;
        webRs = new WebRowSet();
        // webRs.setCommand("select * from clob1") ;
        webRs.setCommand( "insert into AA values(?, ?)" );
        webRs.setInt( 1, 10 );
        webRs.setString( 2, "AAA" );

        getConnection();
        webRs.execute( conn );
        freeConnection( conn );

        System.out.println( webRs );
    }
View Full Code Here
TOP

Related Classes of com.bleujin.framework.db.rowset.WebRowSet

  • com.bleujin.framework.db.RowsetExample
  • java.sql.SQLException
    • Copyright © 2018 www.massapicom. All rights reserved.
    All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.