?? parameterdao.java
字號:
package com.dao;
import com.core.ConnDB;
import com.actionForm.ParameterForm;
import java.sql.ResultSet;
public class ParameterDAO {
ConnDB conn=null;
public ParameterDAO() {
conn=new ConnDB();
}
public ParameterForm query(){
ParameterForm libraryForm1=null;
String sql = "select * from tb_parameter where id=1";
ResultSet rs =conn.executeQuery(sql);
try {
while (rs.next()) {
libraryForm1 = new ParameterForm();
libraryForm1.setId(Integer.valueOf(rs.getString(1)));
libraryForm1.setCost(rs.getInt(2));
libraryForm1.setValidity(rs.getInt(3));
}
} catch (Exception ex) {
}
conn.close();
return libraryForm1;
}
public int update(ParameterForm parameterForm){
String sql="UPDATE tb_parameter SET cost="+parameterForm.getCost()+",validity="+parameterForm.getValidity()+" where id=1";
int ret=conn.executeUpdate(sql);
System.out.println("修改參數設置信息時的SQL:"+sql);
conn.close();
return ret;
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -