?? customer.java
字號:
package bookingsystem;
import java.sql.Statement;
import java.sql.ResultSet;
import java.sql.Connection;
import java.sql.SQLException;
import java.sql.PreparedStatement;
/**
* <p>Title: </p>
*
* <p>Description: </p>
*
* <p>Copyright: Copyright (c) 2007</p>
*
* <p>Company: </p>
*
* @author not attributable
* @version 1.0
*/
public class Customer {
private int cno;
private String cname;
private String phone;
Connection cn = ConnectionDB.getCon();
Statement st = null;
ResultSet rs = null;
Customer(int cno)
{
try {
existCustomerByCno(cno);
} catch (SQLException ex) {
ex.printStackTrace();
}
}
public Customer(String name,String phone) throws SQLException {
this.cname = name;
this.phone = phone;
ResultSet rs1 = existCustomerByCname();
if(rs==null)
{
addNewCustomer();
existCustomerByCname();
}
}
public ResultSet existCustomerByCname() throws SQLException {
ResultSet rs0 = null;
String sql = "select CNO,CNAME,PHONE" +" "+
"FROM CUSTOMER where CNAME = '" + this.cname +"' AND PHONE = '"+this.phone+"'" ;
st =cn.createStatement();
rs0 = st.executeQuery(sql);
while(rs0.next())
{
this.cno = rs0.getInt("CNO");
}
return rs0;
}
public ResultSet existCustomerByCno(int cno) throws SQLException {
String sql = "select CNO,CNAME,PHONE" +" "+
"FROM CUSTOMER where CNO = " + cno ;
st =cn.createStatement();
rs = st.executeQuery(sql);
while(rs.next())
{
this.cno = rs.getInt("CNO");
this.cname = rs.getString("CNAME");
this.phone = rs.getString("phone");
}
return rs;
}
public void addNewCustomer() throws SQLException {
String insertSql = "INSERT INTO CUSTOMER (CNAME,PHONE) VALUES ('"+this.cname+"','"+this.phone+"')";
PreparedStatement ps = cn.prepareStatement(insertSql);
ps.executeUpdate();
}
public int getCno()
{
return this.cno;
}
public String getcname()
{
return cname;
}
public String getphone()
{
return phone;
}
public void setname(String name)
{
this.cname = cname;
}
public void setphone(String phone)
{
this.phone = phone;
}
}
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -