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

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 exception e.printStackTrace(); } return conn; } public ListBeanjxc getBeanjxc() { // 集合 ListBeanjxc list = new ArrayListBeanjxc(); // 操作数据库 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 exception e.printStackTrace(); } return list; } public void Beanjxc(Beanjxc beanjxc) { conn = getconn(); try { String sql = insert into jbxxbiao values(?,?,?,?,?,?,?,?,?); // 专门负责sql语句 PreparedStatement staement = conn.prepareStatement