🚀 go-pugleaf

Class.forName(jdbcDriver).newInstance(); //load driver
Connection  dbConn = DriverManager.getConnection(dbURL); //connect
String sql = "insert into infor(ID,PASS) values(?,?)";
PreparedStatement prepare=dbConn.prepareCall(sql);
prepare.clearParameters();
prepare.setInt(1,200004);
prepare.setString(2,"456");
int result =prepare.executeUpdate();

ʡȥ��catch()

sun��sample code��:

con = DriverManager.getConnection(url, "myLogin", "myPassword");
            con.setAutoCommit(false);

            stmt = con.createStatement();  

            stmt.addBatch("INSERT INTO COFFEES " + 
                 "VALUES('Amaretto', 49, 9.99, 0, 0)");
            stmt.addBatch("INSERT INTO COFFEES " +
                "VALUES('Hazelnut', 49, 9.99, 0, 0)");
            stmt.addBatch("INSERT INTO COFFEES " +
                "VALUES('Amaretto_decaf', 49, 10.99, 0, 0)");
            stmt.addBatch("INSERT INTO COFFEES " +
                "VALUES('Hazelnut_decaf', 49, 10.99, 0, 0)");

            int [] updateCounts = stmt.executeBatch();
            con.commit();
            con.setAutoCommit(true);

�
�� �� huxiaoqing (YouYou) �Ĵ������ᵽ: ��
: ��ƪ�����������
: �� �� apollow (apollo) �Ĵ������ᵽ: ��
: : ����executeUpdate ����insert����Ȼ����û�з���exception,����ݿ⻹��û�и��£�
: : ����������
: : ���У���sun��JDBC Technology Code Samples�￴������addBatch �� commit������
: : insert�ģ���֪�����ҵķ�����ʲô���
: : лл


--
/configure
make
make install

�� ��Դ:��Ʈ��ˮ�Ƽ� Freecity.dhs.org��[FROM: apollow]