Javaµ÷ÓÃSybase´æ´¢¹ý³Ì
ÕªÖÁSybase¹ÙÍø:
The caller( ) method calls the stored procedure inoutproc:
create proc inoutproc @id int, @newname varchar(50), @newhome Address,
@oldname varchar(50) output, @oldhome Address output as
select @oldname = name, @oldhome = home from xmp where id=@id
update xmp set name=@newname, home = @newhome where id=@id
This procedure has three input parameters (@id, @newname, and @newhome) and two output parameters (@oldname and @oldhome). caller( ) sets the name and home columns of the row of table xmp with the ID value of @id to the values @newname and @newhome, and returns the former values of those columns in the output parameters @oldname and @oldhome.
The inoutproc procedure illustrates how to supply input and output parameters in a JDBC call.
caller( ) executes the following call statement, which prepares the call statement:
CallableStatement cs = con.prepareCall("{call inoutproc (?, ?, ?, ?, ?)}");
All of the parameters of the call are specified as parameter markers (?).
caller( ) supplies values for the input parameters using JDBC setInt( ), setString( ), and setObject( ) methods that were used in the doSQL( ), updatAction( ), and selecter( ) methods:
cs.setInt(1, id);
cs.setString(2, newName);
cs.setObject(3, newHome);
These set methods are not suitable for the output parameters. Before executing the call statement, caller( ) specifies the datatypes expected of the output parameters using the JDBC registerOutParameter( ) method:
cs.registerOutParameter(4, java.sql.Types.VARCHAR);
cs.registerOutParameter(5, java.sql.Types.JAVA_OBJECT);
caller( ) then executes the call statement and obtains the output values using the same getString( ) and getObject( ) methods that the selecter( ) method used:
int res = cs.executeUpdate();
String oldName = cs.getString(4);
Address oldHome = (Address)cs.getObject(5);
ÉèÖÃÊä³öΪjava.sql.Types.JAVA_OBJECTÀàÐͺ󣬿ÉÒÔǿת³ÉÈ
Ïà¹ØÎĵµ£º
ʲôÊÇÒì³££¿
Òì³££¨exception£©Ó¦¸ÃÊÇÒ쳣ʼþ£¨exceptional event£©µÄËõд¡£
Òì³£¶¨Ò壺Òì³£ÊÇÒ»¸öÔÚ³ÌÐòÖ´ÐÐÆÚ¼ä·¢ÉúµÄʼþ£¬ËüÖжÏÕýÔÚÖ´ÐеijÌÐòµÄÕý³£µÄÖ¸ÁîÁ÷¡£
µ±ÔÚÒ»¸ö·½·¨Öз¢Éú´íÎóµÄʱºò£¬Õâ¸ö·½·¨´´½¨Ò»¸ö¶ÔÏ󣬲¢ÇÒ°ÑËü´«µÝ¸øÔËÐÐʱϵͳ¡£Õâ¸ö¶ÔÏó±»½Ð×öÒì³£¶ÔÏó£¬Ëü°üº¬ÁËÓйشíÎóµÄÐÅÏ¢£¬ÕâЩÐÅÏ¢°üÀ¨´í ......
public class Demo
{
static int i=1;
static
{
i++;
}
public Demo()
{
......
1.java
Java´úÂë
package com;
public class LoginDemo {
public String validate(String username,String password){
&nb ......
1.j2ee
http://0444.xue8xue8.com/computer/program/java/j2eeshuren/00.wmv
http://0444.xue8xue8.com/computer/program/java/j2eeshuren/01.wmv
http://0444.xue8xue8.com/computer/program/java/j2eeshuren/02.wmv
http://0444.xue8xue8.com/computer/program/java/j2eeshuren/03.wmv
http://0444.xue8xue8.com/c ......
£¨Ò»£©java ¾²Ì¬´úÂë¿é ¾²Ì¬·½·¨Çø±ð
Ò»°ãÇé¿öÏÂ,Èç¹ûÓÐЩ´úÂë±ØÐëÔÚÏîÄ¿Æô¶¯µÄʱºò¾ÍÖ´ÐеÄʱºò,ÐèҪʹÓþ²Ì¬´úÂë¿é,ÕâÖÖ´úÂëÊÇÖ÷¶¯Ö´ÐеÄ;ÐèÒªÔÚÏîÄ¿Æô¶¯µÄʱºò¾Í³õʼ»¯,ÔÚ²»´´½¨¶ÔÏ ......