javaswing开发好关系软件进销存数据库代码.doc

package com.kehuglxt.swing1;import java.sql.Connection;import java.sql.DriverManager;import java.sql.PreparedStatement;import java.sql.ResultSet;import java.util.ArrayList;import java.util.List;public class Jinxiaocunjdbc Connection conn = null;public Connection getconn() try Class.forName(com.mysql.jdbc.Driver);String url = jdbc:mysql:/127.0.0.1:3306/kuhuguangxi;String useName = root;String password = admin;conn = DriverManager.getConnection(url, useName, password); catch (Exception e) / TODO: handle exceptione.printStackTrace();return conn;public List getBeanjxc() / 集合List list = new ArrayList();/ 操作数据库conn = getconn();try / sql语句String sql = select * from jinxiaocun;PreparedStatement staement2 = conn.prepareStatement(sql);/ 执行sql语句ResultSet set = staement2.executeQuery();/ while 和 for 循环的区别是 for循环知道大小 while 不知到 while 有下一条就取出来System.out.println(set.next();while (set.next() / javabean 目录Beanjxc Beanjxc1 = new Beanjxc();Beanjxc1.setId(set.getString(1);Beanjxc1.setShanpinmc(set.getString(2);Beanjxc1.setShanpinlb(set.getString(3);Beanjxc1.setGungexh(set.getString(4);Beanjxc1.setDanwei(set.getString(5);Beanjxc1.setChenbendj(set.getFloat(6);Beanjxc1.setXiaoshoudj(set.getFloat(7);Beanjxc1.setBeizhu(set.getString(8);Beanjxc1.setKuncunsx(set.getInt(9);Beanjxc1.setKuncunxx(set.getInt(10);Beanjxc1.setKuncunshulian(set.getInt(11);Beanjxc1.setTichen(set.getFloat(12);list.add(Beanjxc1);/ 关闭流set.close();conn.close();staement2.close(); catch (Exception e) / TODO: handle exceptione.printStackTrace();return list;public void Beanjxc(Beanjxc beanjxc) conn = getconn();try String sql = insert into jbxxbiao values(?,?,?,?,?,?,?,?,?);/ 专门负责sql语句PreparedStatement staement = conn.prepareStatement(sql);staement.setString(1, beanjxc.getId();staement.setString(2, beanjxc.getShanpinmc();staement.setString(3, beanjxc.getShanpinlb();staement.setString(4, beanjxc.getGungexh();staement.setString(5, beanjxc.getDanwei();staement.setFloat(6, beanjxc.getChenbendj();staement.setFloat(7, beanjxc.getXiaoshoudj();staement.setString(8, beanjxc.getBeizhu();staement.setInt(9, beanjxc.getKuncunsx();staement.setInt(10, beanjxc.getKuncunxx();staement.setInt(11, beanjxc.getKuncunshulian();staement.setFloat(12, beanjxc.getTichen();/ 执行sql语句sta