?? jtcyzlinsert.java
字號:
package community.zhgl;
import java.sql.*;
import community.DBConnectionManager;
import community.dbutil;
public class jtcyzlinsert {
public int select(String hzno){
String sql="select jtcyno from jtcyb where hzno='"+hzno+"'";
Statement stmt;
ResultSet rs;
int count=0;
Connection con=DBConnectionManager.getConnection();
try {
stmt=con.createStatement();
rs=stmt.executeQuery(sql);
while(rs.next()) count=count+1;
} catch (SQLException e) {
e.printStackTrace();
}
dbutil.close(con);
return count;
}
public boolean insert(zhglbean bean) {
Connection con = DBConnectionManager.getConnection();
String sql = "insert into jtcyb(cyname,cysex,cycompany,cyworkphone,cyworkaddr,cymobile,jtcyno,hzno,jtgx) values(?,?,?,?,?,?,?,?,?)";
PreparedStatement pstmt = null;
int count = 0;
try {
pstmt = con.prepareStatement(sql);
pstmt.setString(1, bean.getCyname());
pstmt.setString(2, bean.getCysex());
pstmt.setString(3, bean.getCycompany());
pstmt.setString(4, bean.getCyworkphone());
pstmt.setString(5, bean.getCyworkaddr());
pstmt.setString(6, bean.getCymobile());
pstmt.setString(7, bean.getJtcyno());
pstmt.setString(8, bean.getHzno());
pstmt.setString(9, bean.getJtgx());
count = pstmt.executeUpdate();
dbutil.close(pstmt);
} catch (SQLException e) {
e.printStackTrace();
} finally {
dbutil.close(con);
}
if (count < 1)return false;
return true;
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -