ConnectionName.createStatement(int type,int concurrency)
参数:Type-----决定了返回的语句在执行查询后的结果记录集,其记录指针移动方式有以下三种值:
ResultSet.TYPE_FORWORD_ONLY:结果集记录指针只能向下移动
ResultSet.Type_SCROLL_INSENSITIVE:结果集记录指针可以上下移动,但数据库内容变化时结果集不变
ResultSet.Type_SCROLL_SENSITIVE:结果集记录指针可以上下移动,当数据库内容发生变化后结果集内容同步改变
Concurrency—决定是否可以用结果记录集更新数据库中的表,有以下两种值:
ResultSet._CONCUR_READ_ONLY:结果记录集为只读,不能更新数据库表中的数据;
ResultSet.CONCUR_UPDATABLE:用结果记录集可以更新数据库表中的数据
ResultSet就是结果集,相当于把数据库中的数据存取到本地机器的缓存中。
分享到:
相关推荐
sqlStmt = sqlCon.createStatement(java.sql.ResultSet.TYPE_SCROLL_INSENSITIVE,java.sql.ResultSet.CONCUR_READ_ONLY); //准备SQL语句 strSQL = "select name,age from test"; //执行SQL语句并获取结果...
public Statement createStatement(int resultSetType, int resultSetConcurrency, int resultSetHoldability) throws SQLException { return null;} public PreparedStatement prepareStatement(String sql, int ...
sqlStmt = sqlCon.createStatement(java.sql.ResultSet.TYPE_SCROLL_INSENSITIVE, java.sql.ResultSet.CONCUR_READ_ONLY);//准备SQL语句 strSQL = "select * from Orders"; //执行SQL语句并获取结果集 sqlRst...
主要介绍了java 中createStatement()方法的实例详解的相关资料,需要的朋友可以参考下
stmt=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY); rs=stmt.executeQuery(sql); } catch(SQLException e) { e.printStackTrace(); } return rs; } /...
sqlStmt=sqlCon.createStatement(java.sql.ResultSet.TYPE_SCROLL_INSENSITIVE,java.sql.ResultSet.CONCUR_READ_ONLY); //执行SQL语句并获取结果集 String sql=null; String search=""; String ToPage=request....
Statement stmt = conn.createStatement(int resultSetType, int resultSetConcurrency); ``` 其中,resultSetType指定ResultSet的类型,可以是ResultSet.TYPE_FORWARD_ONLY、ResultSet.TYPE_SCROLL_INSENSITIVE或...
| getInt(int columnIndex) | int | 获取指定列索引的整数值 | | getLong(int columnIndex) | long | 获取指定列索引的长整数值 | JDBC 连接例题分析 在 lianjie.jsp 文件中,我们可以看到一个简单的 JDBC 连接...
Statement stmt=connection.createStatement(); ResultSet rs=stmt.executeQuery ("select * from worker"); 显示查询结果: vect.removeAllElements();//初始化向量对象 tm....
stmt=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY); rs=stmt.executeQuery(sql); } catch(SQLException e) { e.printStackTrace(); } return rs; } /...
} public void setType(int type) { this.type = type; } public String getOther_name() { return other_name; } public void setOther_name(String other_name) { this....
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE); ResultSet re=stmt.executeQuery(sql); return re; } catch(Exception e){ System.out....
sta=conn.createStatement(); //将自动提交模式转换为手动提交模式 conn.setAutoCommit(false); Iterator<Ticket> iter = list.iterator(); //循环将数据准换成SQL语句 while(iter.hasNext()){ Ticket ...
return conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE).executeQuery(sql); } catch (SQLException e) { e.printStackTrace(); return null; } finally { } } ...
public int update(String sql) throws SQLException { stat = conn.createStatement(); int i = stat.executeUpdate(sql); return i; } //查询数据库的方法 public ResultSet getResultSet(String sql) ...
st=con.createStatement(); String sql="insert into dept(name) values('gaoyajun')"; int i=st.executeUpdate(sql); con.commit(); System.out.println(i); }catch(Exception e){
List list=(List) conn.createStatement().executeQuery("select name from tbl_manager where B_id='1'"); ManagerDTO m=(ManagerDTO) list.get(0); System.out.println("aaaaaaa"+m.getName()); } // 单表...
.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE); this.getResourcesList().add(statement); return statement; } catch (Exception ex) { System.out.println("Error in ...
st = conn.createStatement(); } public SqlMapClient getSqlMapClient() throws Exception{ Reader reader = Resources.getResourceAsReader("SqlMapConfig.xml"); SqlMapClient sqlMapper = ...
Statement sm = cn.createStatement(ResultSet.TYPE_SCROLL_ENSITIVE, ResultSet.CONCUR_READ_ONLY); 2>.创建PreparedStatement时指定参数 PreparedStatemet ps = cn.prepareStatement(sql,ResultSet.TYPE_...