62,614
社区成员
发帖
与我相关
我的任务
分享
public void editPointConfig(Point point,int id){
try {
String str=new String(point.getName().getBytes("iso-8859-1"),"gbk");
con = AccessUtil.getConn();
String sql = "update point set gnum ='"+point.getGnum()+"',name = '"+str+"',znum = '"+point.getZnum()+"',sid = '"+point.getSid()+"',communicationType = '"+point.getCommunicationType()+"',com = '"+point.getCom()+"',port = '"+point.getPort()+"' where id = "+id+"";
System.out.println(sql);
Statement statement = con.createStatement();
statement.executeUpdate(sql);
} catch (Exception ex) {
java.util.logging.Logger.getLogger(AeccDao.class.getName()).log(Level.SEVERE, null, ex);
}finally{
close();
}
}
private static final String URL = "jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=d:\\data.mdb";