How to update a field

answered 2009-04-13 10:24:20 +0800

iantsai
2755 ● 1

What kind of fields you want update?

answered 2009-04-13 11:20:09 +0800

robertpic71
1275 ● 1

How do you access you database? Plain JDBC with or w/o beans, hibernate?

Note: You can create a standard-CRUD with Zeta-Forms (a part of ZK Studio). This creates the bean, DAO and a standard GUI using JPA, Hibernate and Spring.

For a simple plain JDBC-Demo check out the JDBC example from like demo >> here <<<

/Robert

answered 2009-04-13 11:58:26 +0800

robertpic71
1275 ● 1

>> How do you access you database? Plain JDBC with or w/o beans, JPA/hibernate?

Please answer, for better help.

>> case of multiple
How should your program work?
1.) List all records of of file the user select the edit-record?
2.) The user enter an unique key and gets the editform?

However for plain-JDBC (in a webapplication) you perform an SQL like this:
update file set fielda=?, fieldb=? where uniquekey=?key

/Robert

answered 2009-04-14 01:35:22 +0800

iantsai
2755 ● 1

I think you should give some example first, and how to change DB schema's column in SQL Query is not what ZK focused.

answered 2009-04-15 08:36:16 +0800

terrytornado
9393 ● 3 ● 7 ● 16
http://www.oxitec.de/

@din

have a look at this thread and study the code. In it are a DialogWindow too
that handles all CRUD for two textboxes.
this

What you can see is:
-------------------------------
1. Listbox with Itemrenderer and sorting columns(comparator)
2. Event Handling in java code.
2.1 doubleClick on row opens a dialogWindow (remarked SingleRowClick or IconClick opens Dialog)
3. overhanded parameters from ListPage to DialogPage.
4. CRUD operations in the dialogWindow with readonly/edit modus.

The data comes from a table by a ServiceDAO. You must fill it by your own.

I have updated the sources (zk 3.5.2).

whishes Stephan
PS: Help to prevent the global warming by writing cool software.