?? tcardmodle.java
字號:
package zichan;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
/**
* <p>Title: </p>
*
* <p>Description: </p>
*
* <p>Copyright: Copyright (c) 2006</p>
*
* <p>Company: </p>
*
* @author not attributable
* @version 1.0
*/
public class TCardModle {
public TCardModle() {
try {
jbInit();
} catch (Exception ex) {
ex.printStackTrace();
}
}
String sql;
Connection conn;
Card cad;
public TCardModle(Card ps) {
cad=ps;
conn=(new DBConnt()).getConnection();
}
void CleanCard(){
cad.jtfAssetId.setText("");
cad.jtfAssetName.setText("");
cad.jtfCateId.setText("");
cad.jtfEmpno.setText("");
cad.jtfIsreturn.setText("");
cad.jtfModelp.setText("");
cad.jtfPrice.setText("");
cad.jtfPurchaseDate.setText("");
cad.jtfRemarks.setText("");
cad.jtfRetdate.setText("");
cad.jtfStatus.setText("");
cad.jtfSubCateId.setText("");
cad.jtfUseby.setText("");
cad.jtfUsedate.setText("");
}
public void selAssetId(String id){
if(conn==null){
System.out.println("找不到驅動程序");
}
CleanCard();
try{
sql="select a.assetid,rtrim(a.asset_name),a.cateid,a.subcateid,rtrim(a.model),a.price,a.purchase_date,a.status,a.useby,rtrim(a.remarks),b.empno,b.usedate,b.retdate,b.isreturn from asset a LEFT OUTER JOIN lend b on (a.assetid=b.assetid) where a.assetid = "+Integer.parseInt(id);
Statement sta=conn.createStatement();
ResultSet rs=sta.executeQuery(sql);
if(rs.next()){
cad.jtfAssetId.setText(rs.getString(1));
cad.jtfAssetName.setText(rs.getString(2));
cad.jtfCateId.setText(rs.getString(3));
cad.jtfSubCateId.setText(rs.getString(4));
cad.jtfModelp.setText(rs.getString(5));
cad.jtfPrice.setText(rs.getString(6));
cad.jtfPurchaseDate.setText(rs.getString(7));
cad.jtfStatus.setText(rs.getString(8));
cad.jtfUseby.setText(rs.getString(9));
cad.jtfRemarks.setText(rs.getString(10));
cad.jtfEmpno.setText(rs.getString(11));
cad.jtfUsedate.setText(rs.getString(12));
cad.jtfRetdate.setText(rs.getString(13));
cad.jtfIsreturn.setText(rs.getString(14));
}
rs.close();
sta.close();
}catch(SQLException c){
System.out.println(c);
}
}
public void selAssetName(String name){
if(conn==null){
conn=(new DBConnt()).getConnection();
}
CleanCard();
try{
sql="select a.assetid,rtrim(a.asset_name),a.cateid,a.subcateid,rtrim(a.model),a.price,a.purchase_date,a.status,a.useby,rtrim(a.remarks),b.empno,b.usedate,b.retdate,b.isreturn from asset a LEFT OUTER JOIN lend b on (a.assetid=b.assetid) where a.asset_name = '"+name+"'" ;
Statement sta=conn.createStatement();
ResultSet rs=sta.executeQuery(sql);
if(rs.next()){
cad.jtfAssetId.setText(rs.getString(1));
cad.jtfAssetName.setText(rs.getString(2));
cad.jtfCateId.setText(rs.getString(3));
cad.jtfSubCateId.setText(rs.getString(4));
cad.jtfModelp.setText(rs.getString(5));
cad.jtfPrice.setText(rs.getString(6));
cad.jtfPurchaseDate.setText(rs.getString(7));
cad.jtfStatus.setText(rs.getString(8));
cad.jtfUseby.setText(rs.getString(9));
cad.jtfRemarks.setText(rs.getString(10));
cad.jtfEmpno.setText(rs.getString(11));
cad.jtfUsedate.setText(rs.getString(12));
cad.jtfRetdate.setText(rs.getString(13));
cad.jtfIsreturn.setText(rs.getString(14));
}
rs.close();
sta.close();
}catch(SQLException a){
System.out.println(a);
}
}
private void jbInit() throws Exception {
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -