PostgreSQL Converse 将数据库表直接生成 java bean 和 HTML From

软件使用方法

[root@linux tmp]# ./pgsql.py
Please enter a table: system_log
[root@linux tmp]#

查看生成的 Java Bean

[root@linux tmp]# ls
Groups.java  Oa.meeting.java  pgsql.py  Role.java  System_log.java  Users.java  workfile.java
[root@linux tmp]# cat System_log.java |more
package netkiller.ebusiness;

import java.sql.*;
import java.util.*;
import netkiller.database.*;
import netkiller.security.*;
public class System_log{

    private String status = null;
    private String description = null;
    private String ip = null;
    private String oid = null;
    private String login_date = null;
    private String id = null;
    private String uid = null;

    public System_log(){
    }

    public void setStatus(String value){
        this.status = value;
    }
    public String getStatus(){
        return this.status;
    }
    public void setDescription(String value){
        this.description = value;
    }
    public String getDescription(){
        return this.description;
    }
    public void setIp(String value){
        this.ip = value;
    }
    public String getIp(){
        return this.ip;
    }
    public void setOid(String value){
        this.oid = value;
    }
    public String getOid(){
        return this.oid;
--More--

配置方法

import pg
import string
db = pg.DB(dbname='netkiller', host='127.0.0.1', user='netkiller',passwd='chen')