采用powerdesigner 9.5 设计数据库，vb 利用其ole功能开发生成代码

2004-12-28 12:12:20 111 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

TwinCAT3新手必看：5分钟搞定EtherCAT从站PDO动态配置（附电流变量添加技巧）本文为TwinCAT3新手提供了EtherCAT从站PDO动态配置的快速入门指南。文章详细解析了Process Data Object（PDO）在实时数据交换中的核心作用，并分步演示了在TwinCAT3工程中扫描从站、动态添加与映射PDO（包括接收PDO和发送PDO）的完整操作流程。重点分享了如何灵活添加并监控如电机实际电流等关键工艺变量的高级技巧，并针对不同品牌驱动器的兼容性问题提供了实用的调试心法和解决方案，帮助工程师快速上手并优化工业自动化系统。阅读详情

// 想法，
//将数据库表和字段信息导出，生成数据库表到java代码的映射
//一些字段再设置“不能为空”“email”。。。校验，生成客户端js校验代码，和服务器端每个表校验java代码.....
//生成structs相关代码
//预期目的，...
//工作正在进行中，完善之后和大家分享

//本人广州，05毕业研究生，有招人的吗，期待伯乐
// 个人求职简历 http://www.maqh.com.cn/carrot

...全文

光伏发电系统模拟及其发电预测开源python工具pvlib 本文介绍光伏发电系统模拟及其发电预测开源python工具pvlib，以及举例介绍获取辐照度方法、光伏发电预测思路。阅读详情

萝卜波

Java EE 67,535 成员 225,843 内容

+ 关注 + 加入社区

切换为时间正序

萝卜波 2004-12-28

打赏
举报

希望大家多多支持。

萝卜波 2004-12-28

打赏
举报

//已经完成生成代码例
package com.cainfo.test;
import java.sql.*;
import java.util.*;
import javax.servlet.http.*;
import org.apache.log4j.logger;
public class Customer
{
private static Logger logger = Logger.getLogger(db.Customer);

private double CUSNUM;
private int CUSNAME;
private String CUSADDR;
private String CUSACT;
private String CUSTEL;
private String CUSFAX;

//*************************************************
public void setCUSNUM(double CUSNUM)
{
this.CUSNUM = CUSNUM;
}

public double getCUSNUM() { return this.CUSNUM;}

//*************************************************
public void setCUSNAME(int CUSNAME)
{
this.CUSNAME = CUSNAME;
}

public int getCUSNAME() { return this.CUSNAME;}

//*************************************************
public void setCUSADDR(String CUSADDR)
{
this.CUSADDR = CUSADDR;
}

public String getCUSADDR() { return this.CUSADDR;}

//*************************************************
public void setCUSACT(String CUSACT)
{
this.CUSACT = CUSACT;
}

public String getCUSACT() { return this.CUSACT;}

//*************************************************
public void setCUSTEL(String CUSTEL)
{
this.CUSTEL = CUSTEL;
}

public String getCUSTEL() { return this.CUSTEL;}

//*************************************************
public void setCUSFAX(String CUSFAX)
{
this.CUSFAX = CUSFAX;
}

public String getCUSFAX() { return this.CUSFAX;}
public void setFieldValue(String fieldName,string value)
{
if(fieldName.equals("CUSNUM") && value != null && value.trim().length()>=1) { setCUSNUM(Double.parseDouble(value)); return; }
if(fieldName.equals("CUSNAME") && value != null && value.trim().length()>=1) { setCUSNAME(Integer.parseInt(value)); return; }
if(fieldName.equals("CUSADDR") && value != null) { setCUSADDR(value); return; }
if(fieldName.equals("CUSACT") && value != null) { setCUSACT(value); return; }
if(fieldName.equals("CUSTEL") && value != null) { setCUSTEL(value); return; }
if(fieldName.equals("CUSFAX") && value != null) { setCUSFAX(value); return; }
}

public String getFieldValue(String fieldName)
{
if(fieldName.equals("CUSNUM")) return ""+ getCUSNUM();
if(fieldName.equals("CUSNAME")) return ""+ getCUSNAME();
if(fieldName.equals("CUSADDR")) return ""+ getCUSADDR();
if(fieldName.equals("CUSACT")) return ""+ getCUSACT();
if(fieldName.equals("CUSTEL")) return ""+ getCUSTEL();
if(fieldName.equals("CUSFAX")) return ""+ getCUSFAX();
}

private PreparedStatement pstmt;
private Statement stmt;
private String condition = "";

public void appendCondition(String cond)
{
if(condition.equals(")) condition = " where " + cond;
else condition+= " and " + cond ;
}

public cleareCondition() { condition = "" ;}
private void sqlClose(PreparedStatement st)
{
try{ if(st!=null) st.close();} catch(Exception ignore){ }
}
private void sqlClose(Statement st)
{
try{ if(st!=null) st.close();} catch(Exception ignore){ }
}
private void sqlClose(ResultSet rs)
{
try{ if(rs!=null) rs.close();} catch(Exception ignore){ }
}
public void sqlClose(Connection con)
{
try{ if(st!=null) con.close();} catch(Exception ignore){ }
}

public void setTableValue(HttpServletRequest request)
{
String value = null;
value = request.getParameter("CUSNUM");
if(value!=null && value.trim().length()>=1) setCUSNUM(Double.parseDouble(value));
value = request.getParameter("CUSNAME");
if(value!=null && value.trim().length()>=1) setCUSNAME(Integer.parseInt(value));
value = request.getParameter("CUSADDR");
if(value!=null) setCUSADDR(value);
value = request.getParameter("CUSACT");
if(value!=null) setCUSACT(value);
value = request.getParameter("CUSTEL");
if(value!=null) setCUSTEL(value);
value = request.getParameter("CUSFAX");
if(value!=null) setCUSFAX(value);
}

public void insert(Connection connection) throws Exception
{
try {
pstmt = connection.prepareStatement( "INSERT INTO Customer(" +
"CUSNUM,"+
"CUSNAME,"+
"CUSADDR,"+
"CUSACT,"+
"CUSTEL,"+
"CUSFAX"+
") values(?,?,?,?,?,?)");
pstmt.setDouble( 1, CUSNUM);
pstmt.setInt( 2, CUSNAME);
pstmt.setString( 3, CUSADDR);
pstmt.setString( 4, CUSACT);
pstmt.setString( 5, CUSTEL);
pstmt.setString( 6, CUSFAX);
pstmt.execute( );
} catch (SQLException e) {
logger.warn("insert()失败! ",e);
throw e;
} finally { sqlClose(pstmt);}
}

public void update(Connection connection) throws Exception
{
try {
pstmt = connection.prepareStatement( "update Customerset " +
"CUSNUM= ?,"+
"CUSNAME= ?,"+
"CUSADDR= ?,"+
"CUSACT= ?,"+
"CUSTEL= ?,"+
"CUSFAX= ?" +
" " + condition);
pstmt.setDouble( 1, CUSNUM);
pstmt.setInt( 2, CUSNAME);
pstmt.setString( 3, CUSADDR);
pstmt.setString( 4, CUSACT);
pstmt.setString( 5, CUSTEL);
pstmt.setString( 6, CUSFAX);
} catch (SQLException e) {
logger.warn("insert()失败! ",e);
throw e;
} finally { sqlClose(pstmt);}
}
public ArrayList query(Connection connection) throws Exception
{
ArrayList alist = new ArrayList();
ResultSet rs = null;
try {
stmt=connection.createStatement();
String strSQL="SELECT * FROM Customer " + condition;
rs = stmt.executeQuery(strSQL);
while(rs.next()){
Customer obj=new Customer();
obj.setCUSNUM(rs.getdouble("CUSNUM"));
obj.setCUSNAME(rs.getint("CUSNAME"));
obj.setCUSADDR(rs.getString("CUSADDR"));
obj.setCUSACT(rs.getString("CUSACT"));
obj.setCUSTEL(rs.getString("CUSTEL"));
obj.setCUSFAX(rs.getString("CUSFAX"));
alist.add(obj)
}
}catch(SQLException e){
logger.warn("query()失败! ",e);
alist = null;
throw e;
}finally{
sqlClose(rs);
sqlClose(stmt);
}

return alist;
}

}
//-----Generate Database to java code by carrot zsu-----//

sgdb 2004-12-28

打赏
举报

支持一下

采用powerdesigner 9.5 设计数据库，vb 利用其ole功能开发生成代码

相关推荐