?? client.java
字號:
package good;
import java.sql.ResultSet;
import java.util.Vector;
public class Client {
/**
* @param args
*/
private String clientName;
private String clientNumber;
private String clientAddress;
//private String goodPrice;
public String getClientName() {
return clientName;
}
public void setClientName(String clientName) {
this.clientName = clientName;
}
public String getClientNumber() {
return clientNumber;
}
public void setClientNumber(String clientNumber) {
this.clientNumber = clientNumber;
}
public String getClientAddress() {
return clientAddress;
}
public void setClientAddress(String clientAddress) {
this.clientAddress = clientAddress;
}
//public String getGoodPrice() {
//return goodPrice;
//}
// public void setGoodPrice(String goodPrice) {
// this.goodPrice = goodPrice;
//}
public boolean clientAdd()
{
DataConn storCon = new DataConn();
String addSql = null;
storCon.dataConnDerectForMySql();
System.out.println(clientName);
addSql="Insert into client(clientName,clientNumber,clientAddress) values('"+clientName
+"','"+clientNumber+"','"+clientAddress+"')";
System.out.println(addSql);
storCon.executeDerectUpdate(addSql);
return true;
}
public boolean clientModi()
{
DataConn storCon = new DataConn();
String addSql = null;
storCon.dataConnDerectForMySql();
addSql="update client set clientNumber='"+clientNumber+"',clientAddress='"+clientAddress+
"' where clientName='"+clientName+"'";
storCon.executeDerectUpdate(addSql);
return true;
}
public Vector GetAllclientName() {
String quy;
String temp;
int i = 0;
DataConn storCon = new DataConn();
Vector list = new Vector();
storCon.dataConnDerectForMySql();
ResultSet rs = null;
quy = "select clientname from client order by clientName";
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 void resultData() {
String quy;
DataConn storCon = new DataConn();
String addSql = null;
ResultSet rs = null;
storCon.dataConnDerectForMySql();
quy = "select * from client where clientName='" + this.getClientName()+"'" ;
try {
rs = storCon.executeDerectQuery(quy);
if (rs.next()) {
//this.setClientName(rs.getString("clientName"));
this.setClientNumber(rs.getString("clientnumber"));
this.setClientAddress(rs.getString("clientaddress"));
} else {
}
rs.close();
} catch (Exception e) {
e.printStackTrace();
}
}
public boolean checkData() {
String quy;
DataConn storCon = new DataConn();
ResultSet rs = null;
storCon.dataConnDerectForMySql();
quy = "select * from client where clientname='" + this.getClientName() + "'";
try {
rs = storCon.executeDerectQuery(quy);
if (rs.next()) {
return false;
} else {
return true;
}
} catch (Exception e) {
e.printStackTrace();
return false;
}
}
private void clientName(String string) {
// TODO Auto-generated method stub
}
public boolean checkExist(String name) {
String quy;
DataConn storCon = new DataConn();
ResultSet rs = null;
storCon.dataConnDerectForMySql();
quy = "select * from client where clientname='" + name + "'";
try {
rs = storCon.executeDerectQuery(quy);
if (rs.next()) {
return false;
} else {
return true;
}
} catch (Exception e) {
e.printStackTrace();
return false;
}
}
}
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -