基于java的可二次开发二个非常简单的mysqljava增删改查功能例子.zip

package com.sam.bean; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.Statement; import java.util.ArrayList; import java.util.List; public class Saile { private int sailid; private String startTime; private String endTime; private String sailName; private String sumsail; private String finishsail; private String leftsail; public Saile(int sailid, String startTime, String endTime, String sailName, String sumsail, String finishsail, String leftsail) { super(); this.sailid = sailid; this.startTime = startTime; this.endTime = endTime; this.sailName = sailName; this.sumsail = sumsail; this.finishsail = finishsail; this.leftsail = leftsail; } public Saile() { super(); this.startTime = ""; this.endTime = ""; this.sailName = ""; this.sumsail = ""; this.finishsail = ""; this.leftsail = ""; } /** * 查询的方法 * @param conn * @return * @throws Exception */ public static List<Saile> find(Connection conn,Saile n)throws Exception { List<Saile> listmeal=new ArrayList<Saile>();//创建一个新的集合 String strSql="select * from saile where 1=1 "; if(n.getSailName().length()>0){ strSql=strSql+"and sailName='"+n.getSailName()+"' "; } if(n.getSumsail().length()>0){ strSql=strSql+"and sumsail='"+n.getSumsail()+"' "; } if(n.getStartTime().length()>0){ strSql=strSql+"and startTime like '%"+n.getStartTime()+"%' "; } if(n.getEndTime().length()>0){ strSql=strSql+"and endTime like '%"+n.getEndTime()+"%' "; } if(n.getFinishsail().length()>0){ strSql=strSql+"and finishsail='"+n.getFinishsail()+"' "; } if(n.getLeftsail().length()>0){ strSql=strSql+"and leftsail='"+n.getLeftsail()+"' "; } Statement stmt =DB.createStmt(conn); ResultSet rs = null; rs = DB.executeQuery(stmt, strSql);//执行这个sql语句;增删改用executeUpdate，查询用executeQuery try { while(rs.next()){//遍历 Saile ns=new Saile(); ns.setSailid(Integer.parseInt(rs.getString("sailid"))); ns.setEndTime(rs.getString("endTime")); ns.setFinishsail(rs.getString("finishsail")); ns.setLeftsail(rs.getString("leftsail")); ns.setSailName(rs.getString("sailName")); ns.setStartTime(rs.getString("startTime")); ns.setSumsail(rs.getString("sumsail")); listmeal.add(ns);//将这个对象添加到集合中 } } finally{ DB.close(rs); DB.close(stmt); } return listmeal;//返回这个集合 } /** * 修改的方法 * @param conn * @param m * @throws Exception */ public static void update(Connection conn,Saile n)throws Exception { PreparedStatement stmt = null; String strSql = "update saile set sailName='"+n.getSailName()+"',sumsail='"+n.getSumsail()+"',finishsail='"+n.getFinishsail()+"',leftsail='"+n.getLeftsail()+"',startTime='"+n.getStartTime()+"',endTime='"+n.getEndTime()+"' where sailid='"+n.getSailid()+"'";//将传来的id丢进去 stmt = conn.prepareStatement(strSql); try { stmt.executeUpdate();//执行这个sql语句;增删改用executeUpdate，查询用executeQuery } catch (Exception e) {} } /** * 添加的方法 * @param conn * @param m * @throws Exception */ public static void add(Connection conn,Saile n)throws Exception { PreparedStatement stmt = null; String strSql = "insert into saile(sailName,sumsail,finishsail,leftsail,startTime,endTime) values('"+n.getSailName()+"','"+n.getSumsail()+"','"+n.getFinishsail()+"','"+n.getLeftsail()+"','"+n.getStartTime()+"','"+n.getEndTime()+"')";//取对象里面的值丢进去 stmt = conn.prepareStatement(strSql); try { stmt.executeUpdate();//执行添加语句，和查询的不一样；增删改用executeUpdate，查询用executeQuery } catch (Exception e) {} } /** * 删除的方法 * @param conn * @param m * @throws Exception */ public static void del(Connection conn,int id)throws Exception { PreparedStatement stmt = null; String strSql = "delete from saile where SailID = '"+id+"'";//将传来的id丢进去 stmt = conn.prepareStatement(strSql); try { stmt.executeUpdate();//执行这个sql语句;增删改用executeUpdate，查询用executeQuery } catch (Exception e) {} } public int getSailid() { return sailid; } public void setSailid(int sailid) { this.sailid = sailid; } public String getStartTime() { return startTime; } public void setStartTime(String startTime) { this.startTime = startTime; } public String getEndTime() { return endTime; } public void setEndTime(String endTime) { this.endTime = endTime; } public String getSailName() { return sailName; } public void setSailName(String sailName) { this.sailName = sailName; } public String getSumsail() { return sumsail; } public void setSumsail(String sumsail) { this.sumsail = sumsail; } public String getFinishsail() { return finishsail; } public void setFinishsail(String finishsail) { this.finishsail = finishsail; } public String getLeftsail() { return leftsail; } public void setLeftsail(String leftsail) { this.leftsail = leftsail; } }