用户注册



邮箱:

密码:

用户登录


邮箱:

密码:
记住登录一个月忘记密码?

发表随想


还能输入:200字

用户注册



邮箱:

密码:

用户登录


邮箱:

密码:
记住登录一个月忘记密码?

发表随想


还能输入:200字

请选择技术分类

 *如果你找不到更细的分类,可以选择上级分类
当前位置:云代码 - 技术问答 - Java

我想将下拉列表中的内容加载到数据库中,但是加不进去、求解释,求指导

 悬赏:10|提问者:云代码会员|浏览:2766
举报|2012-12-20
package com.yy.view;


import java.awt.BorderLayout;
import java.awt.Dimension;
import java.awt.Toolkit;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.SQLException;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Iterator;


import javax.swing.*;


import com.sun.org.apache.xerces.internal.impl.xpath.regex.ParseException;
import com.yy.control.ProductService;
import com.yy.date.DB_Conn;
import com.yy.entity.Product;


public class OutProductFrame extends JFrame implements ActionListener {
 
JTable showOutProduct;
JLabel jlProductNo,jlProductName,jlProductPrice,jlProductDeliveryDate,jlProducttype;
JTextField tfProductNo,tfProductName,tfProductPrice,tfProductDeliveryDate;
JButton jbaddProduct,jbdeleteProductbyno,jbupdateProduct,jbinquiresAllProduct,jbout;
JPanel  text;
Box baseBox,inputBox;
ProductService ps=new ProductService();
ArrayList<Product> products=new ArrayList<Product>() ;
JComboBox conBox;
String[] el={"水果","蔬菜"};


Object productshow[][]=new Object[20][5];
Object[] tableTitle={"商品编号","商品名称","销售价格","销售日期","商品类型"};
JScrollPane showInfor;

public OutProductFrame(){
init();
setTitle("销售管理系统");
Toolkit tool=getToolkit(); 
Dimension dim=tool.getScreenSize();
setBounds(0,0,dim.width/2,dim.height/2);
setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
setVisible(true);

}
public void init(){
this.setLayout(new BorderLayout());
showOutProduct=new JTable(productshow,tableTitle);
showInfor=new JScrollPane(showOutProduct);

jlProductNo = new JLabel("商品编号");
jlProductName = new JLabel("商品名称");
jlProductPrice = new JLabel("销售价格");
jlProductDeliveryDate = new JLabel("销售日期");
jlProducttype = new JLabel("商品类型");

tfProductNo = new JTextField(10);
tfProductName = new JTextField(10);
tfProductPrice = new JTextField(10);
tfProductDeliveryDate = new JTextField(10);
 


Box inputBox1 = Box.createHorizontalBox();
inputBox1.add(jlProductNo);
inputBox1.add(tfProductNo);
Box inputBox2 = Box.createHorizontalBox();
inputBox2.add(jlProductName);
inputBox2.add(tfProductName);
Box inputBox3 = Box.createHorizontalBox();
inputBox3.add(jlProductPrice);
inputBox3.add(tfProductPrice);
Box inputBox4 = Box.createHorizontalBox();
inputBox4.add(jlProductDeliveryDate);
inputBox4.add(tfProductDeliveryDate);
Box inputBox5 = Box.createHorizontalBox();
inputBox5.add(jlProducttype);



conBox=new JComboBox(el);
conBox.addItem("日用品");
inputBox5.add(conBox);

Box tfBox=Box.createVerticalBox();//Vertical 垂直方向上的
tfBox.add(inputBox1);
tfBox.add(inputBox2);
tfBox.add(inputBox3);
tfBox.add(inputBox4);
tfBox.add(inputBox5);

jbaddProduct=new JButton("新增");
//badd.addActionListener(this);
jbdeleteProductbyno=new JButton("删除");
//bdelete.addActionListener(this);
jbinquiresAllProduct=new JButton("查看");
//blook.addActionListener(this);
jbupdateProduct=new JButton("修改");
jbout=new JButton("退出");

Box buttonBox=Box.createHorizontalBox();  
buttonBox.add(jbaddProduct);
jbaddProduct.addActionListener(this);
buttonBox.add(jbdeleteProductbyno);
jbdeleteProductbyno.addActionListener(this);
buttonBox.add(jbupdateProduct);
jbupdateProduct.addActionListener(this);
buttonBox.add(jbinquiresAllProduct);
jbinquiresAllProduct.addActionListener(this);
buttonBox.add(jbout);
jbout.addActionListener(this);
tfBox.add(buttonBox);


baseBox=Box.createHorizontalBox();

baseBox.add(tfBox);
baseBox.add(showInfor);
//JPanel show=new JPanel();
add(baseBox,BorderLayout.WEST);
showOutProduct.repaint();
baseBox=Box.createVerticalBox();
baseBox.add(tfBox);
baseBox.add(showInfor);
add(baseBox,BorderLayout.CENTER);

jbaddProduct.addActionListener(new ActionListener(){
        public void actionPerformed(ActionEvent e) {
        Product p=new Product();
           DB_Conn dbconn1=new DB_Conn();  
        
         
           
          String   ProductNo=tfProductNo.getText();
  String ProductName=tfProductName.getText();
  String ProductPrice=tfProductPrice.getText();
  String ProductDeliveryDate=tfProductDeliveryDate.getText();
  String Producttype=tfProducttype.getText();


String sql="insert into 商品销售 values('"
+ ProductNo+"','"
+ ProductName+"','"
+ ProductPrice+"','"
+ ProductDeliveryDate+"','"
+ Producttype+"')";
System.out.println(sql);
try {
boolean flag=dbconn1.getSm().execute(sql);
if(flag)
System.out.println("success insert");

else

System.out.println("fail");
}
catch (SQLException e1) {

e1.printStackTrace();
}
}
});


baseBox=Box.createVerticalBox();
baseBox.add(tfBox);
baseBox.add(showInfor);
add(baseBox,BorderLayout.CENTER);
}
 
 public void listInit(){
Iterator it=products.iterator();
int i=0;
while(it.hasNext()){
Product p=(Product)it.next();
productshow[i][0]=p.getProductNo();
productshow[i][1]=p.getProductName();
productshow[i][2]=p.getProductPrice();  
productshow[i][3]=p.getProductDeliveryDate();
productshow[i][4]=p.getProducttype();
i++;
}

}
public void actionPerformed(ActionEvent e) {
 
 
if(e.getSource()==jbaddProduct){

Product p=new Product();
 
p.setProductNo(Integer.parseInt(tfProductNo.getText()));  
p.setProductName(tfProductName.getText());  
p.setProductPrice(Float.parseFloat(tfProductPrice.getText()));
SimpleDateFormat sdf=new SimpleDateFormat("yyyy-MM-dd");  
 
try {
p.setProductDeliveryDate(sdf.parse(tfProductDeliveryDate.getText()));
} catch (java.text.ParseException e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
}  

String Producttype=tfProducttype.getText();
p.setProducttype(Producttype);
products.add(p);
listInit();
showOutProduct.repaint();
}

if(e.getSource()==jbdeleteProductbyno){
int productNo=Integer.parseInt(tfProductNo.getText());
Iterator it=products.iterator();
while (it.hasNext()){
Product s=(Product)it.next();
if(ps.getProducts()==products){
products.remove(ps);
break;
}
}
listInit();
int size=products.size();
productshow[size][0]=null;
productshow[size][1]=null;
productshow[size][2]=null;
productshow[size][3]=null;
productshow[size][4]=null;
showOutProduct.repaint();
}
if(e.getSource()==jbout){
this.dispose();
}

   }


}
}

package com.yy.date;


import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;


public class DB_Conn {
private String driverName="com.microsoft.sqlserver.jdbc.SQLServerDriver";
private String userName="sa";
private String userPwd="123";
private String dbName="HrSys";
private String url="jdbc:sqlserver://localhost:1433;DatabaseName=HrSys";
private Connection Conn=null;
public Statement Sm=null;
public  DB_Conn(){
try {
Class.forName(driverName);
Conn=DriverManager.getConnection(url, userName, userPwd);
Sm=Conn.createStatement();
System.out.println("Success");
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}

}
public Connection getConn() {
return Conn;
}
public void setConn(Connection conn) {
Conn = conn;
}
public Statement getSm() {
return Sm;
}
public void setSm(Statement sm) {
this.Sm = sm;
}
public void DB_close(){
try {
Conn.close();
Sm.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}

}


}


我来回答

所有回答
举报|(2)|(0)2012-12-20
		conBox.addItemListener(new ItemListener() {
			public void itemStateChanged(ItemEvent evt) {
				if (evt.getStateChange() == ItemEvent.SELECTED) {
					try {
						String s = evt.getItem().toString();// 选中的值

						JOptionPane.showMessageDialog(null, "你选中了" + s);
					} catch (Exception e) {

					}
				}
			}

		});
然后把字符串s存入数据库
举报|(1)|(0)2012-12-20
你是指获取选中的内容吧?

楼上正解!
举报|(0)|(0)2012-12-26
楼上正解+1
举报|(0)|(0)2017-04-18
??
#5542
举报|(0)|(0)2018-12-25
222
举报|(0)|(0)2019-07-30
111
举报|(0)|(0)2020-12-26
安抚啊额
举报|(0)|(0)2022-02-06
1

相关提问