?? imanufacturer.java
字號:
package good;
import java.sql.ResultSet;
import java.util.Vector;
public class Imanufacturer {
/**
* @param args
*/
private String manufName;
//private String goodName;
private String manufPhonenumber;
private String manufAddress;
public String getManufAddress() {
return manufAddress;
}
public void setManufAddress(String manufAddress) {
this.manufAddress = manufAddress;
}
public String getManufName() {
return manufName;
}
public void setManufName(String manufName) {
this.manufName = manufName;
}
public String getManufPhonenumber() {
return manufPhonenumber;
}
public void setManufPhonenumber(String manufPhonenumber) {
this.manufPhonenumber = manufPhonenumber;
}
public boolean ImanufacturerAdd()
{
DataConn storCon = new DataConn();
String addSql = null;
storCon.dataConnDerectForMySql();
addSql="Insert into Imanufacturer(imanufname,imanufphonenumber,imanufAddress) values('"+manufName
+"','"+manufPhonenumber+"','"+manufAddress+"')";
storCon.executeDerectUpdate(addSql);
return true;
}
public Vector GetAllSupplyName() {
String quy;
String temp;
int i = 0;
DataConn storCon = new DataConn();
Vector list = new Vector();
storCon.dataConnDerectForMySql();
ResultSet rs = null;
quy = "select imanufname from Imanufacturer";
try {
rs = storCon.executeDerectQuery(quy);
while (rs.next()) {
temp=rs.getString(1);
System.out.println(temp);
list.add(temp==null? "":temp.trim());
}
} catch (Exception e) {
e.printStackTrace();
}
return list;
}
public boolean checkExist(String text) {
String quy;
DataConn storCon = new DataConn();
ResultSet rs = null;
storCon.dataConnDerectForMySql();
quy = "select * from Imanufacturer where imanufname='" + text + "'";
try {
rs = storCon.executeDerectQuery(quy);
if (rs.next()) {
return false;
} else {
return true;
}
} catch (Exception e) {
e.printStackTrace();
return false;
}
}
public boolean checkData() {
String quy;
DataConn storCon = new DataConn();
ResultSet rs = null;
storCon.dataConnDerectForMySql();
quy = "select * from Imanufacturer where imanufname='" + this.getManufName() + "'";
try {
rs = storCon.executeDerectQuery(quy);
if (rs.next()) {
return false;
} else {
return true;
}
} catch (Exception e) {
e.printStackTrace();
return false;
}
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -