package com.conn; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.util.ArrayList; import java.util.Iterator; import java.util.List; import javax.management.openmbean.OpenMBeanAttributeInfoSupport; public class SqlTest { public void ins_shop(shops shop) throws SQLException { String sqlString="insert into tb_goods values("+shop.getGoodId()+","+'"'+shop.getGoodName()+'"'+","+shop.getNum()+","+shop.getPrice()+")"; Connection conn =JBconnection.getcon(); PreparedStatement ps =conn.prepareStatement(sqlString); int rSet= ps.executeUpdate(); } public void delete_shop(int id) throws SQLException { String sqlString="delete from tb_goods where goodId="+id; Connection conn =JBconnection.getcon(); PreparedStatement ps =conn.prepareStatement(sqlString); int rSet= ps.executeUpdate(); JBconnection.close(null, ps, conn); } public static ArrayList query() throws SQLException { String sqlString="select * from tb_goods "; Connection conn =JBconnection.getcon(); PreparedStatement ps =conn.prepareStatement(sqlString); ResultSet rSet= ps.executeQuery(); ArrayList stus=new ArrayList<>(); while (rSet.next()) { int id=rSet.getInt("goodId"); String name=rSet.getString("goodName"); int num=rSet.getInt("num"); Double price=rSet.getDouble("price"); shops stu= new shops(id, name, num, price); stus.add(stu); } JBconnection.close(rSet, ps, conn); return stus; } public static void main(String[] args) throws SQLException { SqlTest sqlTest=new SqlTest(); ArrayList all = sqlTest.query(); Object[][] data=new Object[all.size()][4]; for (int i = 0; i < all.size(); i++) { data[i][0]=all.get(i).getGoodId(); data[i][1]=1; } shops shops=new shops(20, "小米", 10, 4000); try { sqlTest.ins_shop(shops); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } }