📄 kehuchoice.java
字号:
import java.awt.*;
import java.awt.event.*;
import java.util.*;
import java.sql.*;
import javax.swing.*;
import javax.swing.table.*;
import javax.swing.border.*;
public class KehuChoice extends JFrame implements ActionListener,ItemListener{
private DefaultTableModel philosophers;
private JTable table;
private JScrollPane jspn;
private JTextField t1,t2,t3,t4;
private JButton xianshi,dayin;
private Choice yewuyuanChoice;
private Container con=null;
private Font font;
private String name,truename;
private JCheckBox yewuyuan,lianxiren,qiandingren,dianhua,chuanzhen,dizhi;
private JRadioButton quanbu,yiding;
public KehuChoice(String name,String truename){
super("客户查询详单");
this.name=name;
this.truename=truename;
int iii=(int)(Toolkit.getDefaultToolkit().getScreenSize().getWidth());
font=new java.awt.Font("宋体",Font.PLAIN,14);
Box box1=Box.createHorizontalBox(); //盒子
t1=new JTextField(10);
t2=new JTextField(10);
t3=new JTextField(10);
t4=new JTextField(10);
xianshi=new JButton("显示查询结果");
xianshi.addActionListener(this);
quanbu=new JRadioButton("全部客户");
yiding=new JRadioButton("已定合同");
yewuyuanChoice=new Choice();
dayin=new JButton(" 打 印 ");
dayin.setFont(font);
dayin.addActionListener(this);
box1.add(yewuyuanChoice);
box1.add(t1);
box1.add(t2);
box1.add(t3);
box1.add(t4);
box1.add(quanbu);
box1.add(yiding);
box1.add(dayin);
Box box2=Box.createHorizontalBox();
yewuyuan=new JCheckBox("业 务 员");
lianxiren=new JCheckBox("联 系 人");
dianhua=new JCheckBox("联系电话");
chuanzhen=new JCheckBox(" 传 真 ");
dizhi=new JCheckBox("联系地址");
box2.add(yewuyuan);
box2.add(lianxiren);
box2.add(dianhua);
box2.add(chuanzhen);
box2.add(dizhi);
box2.add(xianshi);
Box boxH=Box.createVerticalBox();
boxH.add(box1);
boxH.setBorder(new TitledBorder("1.选择客户"));
boxH.add(Box.createVerticalGlue());
Box boxW=Box.createVerticalBox();
boxW.add(box2);
boxW.setBorder(new TitledBorder("2.选择显示内容"));
boxW.add(Box.createVerticalGlue());
Box boxN=Box.createVerticalBox();
boxN.setFont(font);
boxN.add(boxH);
boxW.setFont(font);
boxN.add(boxW);
boxN.add(Box.createVerticalGlue());
quanbu.setFont(font);
yiding.setFont(font);
t1.setFont(font);
t2.setFont(font);
t3.setFont(font);
t4.setFont(font);
yewuyuan.setFont(font);
lianxiren.setFont(font);
dianhua.setFont(font);
chuanzhen.setFont(font);
dizhi.setFont(font);
xianshi.setFont(font);
quanbu.setSelected(true);
quanbu.addItemListener(this);
yiding.addItemListener(this);
yewuyuanChoice.add("全部业务员");
ResultSet resSet;
Connection dbConn;
Statement stat;
try {
Class.forName(Yewu.forName);
dbConn=DriverManager.getConnection(Yewu.jdbc);
stat=dbConn.createStatement();
resSet=stat.executeQuery("select distinct truename from zhuceTable where truename!='' ");
StringVector vec=new StringVector();
while(resSet.next()){
vec.add(resSet.getString("truename"));
}
for(int i=0;i<vec.size();i++){
yewuyuanChoice.add(vec.get(i));
}
stat.close();
dbConn.close();
}catch(Exception ex){
System.out.println(ex);
}
JPanel pp=new JPanel();
pp.add(boxN);
con=getContentPane();
con.validate();
con.setLayout(new BorderLayout());
con.add(pp,BorderLayout.NORTH);
if(iii==800){
font=new java.awt.Font("宋体",Font.PLAIN,12);
setBounds(80,70,650,400);
}else{
setBounds(140,80,800,600);
}
setVisible( true );
this.addWindowListener(new WindowAdapter(){
public void WindowClosing(WindowEvent e){
System.exit(0);
}
});
}
public void actionPerformed(ActionEvent e){
if(e.getSource()==xianshi){
if(t1.getText().trim().length()==0&&(t2.getText().trim().length()>0||t3.getText().trim().length()>0||t4.getText().trim().length()>0)){
JOptionPane.showMessageDialog(null,"请从第1个输入框开始依次填写");
}else if(t1.getText().trim().length()!=0&&t2.getText().trim().length()==0&&(t3.getText().trim().length()>0||t4.getText().trim().length()>0)){
JOptionPane.showMessageDialog(null,"请从第1个输入框开始依次填写");
}else if(t1.getText().trim().length()!=0&&t2.getText().trim().length()!=0&&t3.getText().trim().length()==0&&t4.getText().trim().length()>0){
JOptionPane.showMessageDialog(null,"请从第1个输入框开始依次填写");
}else{
StringBuffer buf=new StringBuffer();
buf=buf.append("select distinct top 50 ");
//sql3="select distinct truename,name,tel,sheng,shi,xian from zhuceTable where truename='"+truename+"' and name!='master' and name!='root'";
philosophers = new DefaultTableModel();
StringVector vec=new StringVector();
vec.add("序号");
if(yewuyuan.isSelected()){
vec.add("业 务 员");
if(yiding.isSelected()){
buf=buf.append("yewuTab.yewuname,");
}else{
buf=buf.append("yewuname,");
}
}
if(lianxiren.isSelected()){
vec.add("联 系 人");
buf=buf.append("lianxiname,");
}
if(dianhua.isSelected()){
vec.add("联系电话");
buf=buf.append("dianhua,");
}
if(chuanzhen.isSelected()){
vec.add(" 传 真 ");
buf=buf.append("chuanzhen,");
}
if(dizhi.isSelected()){
vec.add("联系地址");
buf=buf.append("dizhi,");
}
vec.add("客户名称");
if(name.equals("master")||name.equals("root")){
StringBuffer buffer=new StringBuffer();
if(t1.getText().trim().length()>0){
buffer.append("kehuname like '%"+t1.getText().trim()+"%'");
}
if(t2.getText().trim().length()>0){
buffer.append("or kehuname like '%"+t2.getText().trim()+"%'");
}
if(t3.getText().trim().length()>0){
buffer.append("or kehuname like '%"+t3.getText().trim()+"%'");
}
if(t4.getText().trim().length()>0){
buffer.append("or kehuname like '%"+t4.getText().trim()+"%'");
}
buffer.append(" ");
if(t1.getText().trim().length()>0){
if(yewuyuanChoice.getSelectedItem()=="全部业务员"){
if(quanbu.isSelected()){
buf=buf.append("kehuname from yewuTab where ").append(buffer.toString().trim());
}else if(yiding.isSelected()){
buf=buf.append("yewuTab.kehuname from yewuTab join hetongTable on yewuTab.kehuname=hetongTable.kehuname where ").append(buffer.toString().trim());
}
}else{
buf=buf.append("kehuname from yewuTab where yewuname='").append(yewuyuanChoice.getSelectedItem()).append("' and ( ").append(buffer.toString().trim()).append(" )");
}
}else{
if(yewuyuanChoice.getSelectedItem()=="全部业务员"){
if(quanbu.isSelected()){
buf=buf.append("kehuname from yewuTab");
}else if(yiding.isSelected()){
buf=buf.append("yewuTab.kehuname from yewuTab join hetongTable on yewuTab.kehuname=hetongTable.kehuname ");
}
}else{
buf=buf.append("kehuname from yewuTab where yewuname='").append(yewuyuanChoice.getSelectedItem()).append("'");
}
}
}else{
buf=buf.append("kehuname from yewuTab where yewuname='").append(truename).append("'");
}
philosophers = new DefaultTableModel(); //创建0行
for(int i=0;i<vec.size();i++){
philosophers.addColumn(vec.get(i));
}
ResultSet resSet;
Connection dbConn;
Statement stat;
String sql3=buf.toString();
try {
Class.forName(Yewu.forName);
dbConn=DriverManager.getConnection(Yewu.jdbc);
stat=dbConn.createStatement();
resSet=stat.executeQuery(sql3);
int m=1;
Vector vec1=new Vector();
while(resSet.next()){
Vector vec2=new Vector();
vec2.add(m++);
for(int i=1;i<vec.size();i++){
vec2.add((resSet.getObject(i)).toString());//0
}
vec1.add(vec2);
}
if(m>1){
for(int i=0;i<vec1.size();i++){
philosophers.addRow(((Vector)vec1.get(i)).toArray());
}
}else{
JOptionPane.showMessageDialog(null,"没有此客户的合同信息");
}
stat.close();
dbConn.close();
}catch(Exception ex){
System.out.println(ex);
}
table = new JTable( philosophers );
table.setFont(font);
if(jspn!=null){
con.remove(jspn);
}
jspn=new JScrollPane(table);
JLabel labelto=new JLabel("由于打印功能里设定了分页,此处仅显示前50条记录供参考");
con.add(jspn,BorderLayout.CENTER);
con.add(labelto,BorderLayout.SOUTH);
con.validate();
}
}
}
public void itemStateChanged(ItemEvent e){ //选择事件
if(e.getSource()==quanbu&&quanbu.isSelected()){
yiding.setSelected(false);
}
if(e.getSource()==yiding&&yiding.isSelected()){
quanbu.setSelected(false);
}
}
}⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -