?? zgbean.java
字號:
package zcgl;
import java.awt.*;
import java.sql.*;
import javax.swing.*;
public class ZgBean extends JPanel {
BorderLayout borderLayout1 = new BorderLayout();
private int zgId;
private String zgName;
private String zgWork;
private String zgContext;
private Connection con=null;
public ZgBean() {
}
public void setZgId(int zgId) {
this.zgId = zgId;
}
public void setZgName(String zgName) {
this.zgName = zgName;
}
public void setZgwork(String zgWork) {
this.zgWork = zgWork;
}
public void setZgContext(String zgContext) {
this.zgContext = zgContext;
}
public int getZgId() {
return zgId;
}
public String getZgName() {
return zgName;
}
public String getZgwork() {
return zgWork;
}
public String getZgContext() {
return zgContext;
}
public boolean insert(){
con = new DbCon().getConnection();
try {
PreparedStatement psmt = con.prepareStatement(
"insert into EMPLOYEE values(?,?,?,?)");
psmt.setInt(1,zgId);
psmt.setString(2,zgName);
psmt.setString(3,zgWork);
psmt.setString(4,zgContext);
psmt.executeUpdate();
return true;
} catch (Exception ex) {
return false;
}
}
public boolean del(){
con = new DbCon().getConnection();
try {
PreparedStatement psmt = con.prepareStatement(
"delete from EMPLOYEE where empno=?");
psmt.setInt(1,zgId);
psmt.executeUpdate();
return true;
} catch (Exception ex) {
return false;
}
}
public boolean modify(){
con = new DbCon().getConnection();
int Id=zgId;
try {
PreparedStatement psmt = con.prepareStatement(
"update EMPLOYEE set empno=?,ename=?,positions=?,remarks=? where empno="+Id);
psmt.setInt(1,zgId);
psmt.setString(2,zgName);
psmt.setString(3,zgWork);
psmt.setString(4,zgContext);
psmt.executeUpdate();
return true;
} catch (Exception ex) {
return false;
}
}
public boolean isNull() {
con = new DbCon().getConnection();
Statement smt = null;
try {
smt = con.createStatement();
ResultSet rs=smt.executeQuery("select * from EMPLOYEE where empno="+zgId);
if(rs.next())
return false;
} catch (SQLException ex) {
}
return true;
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -