资源描述:
《jdbc向数据库中插入数据.docx》由会员上传分享,免费在线阅读,更多相关内容在工程资料-天天文库。
1、jdbc向数据库中插入数据使用jdbc链接mysql数据库,并实现数据的批量插入publicbooleaninsertFrom(Personper){booleanflag=false;Connectionconn=null;conn=JdbcCon.jdbcConMysql();PreparedStatementps=null;Stringsql="insertintoperson(name,birthday,sex)values(?,?,?)";try{ps=conn.prepareStatement(sql);ps.setString(1,per.getName());ps.setD
2、ate(2,per.getBirthday());ps.setInt(3,per.getSex());inti=ps.executeUpdate();if(i!=0){flag=true;}}catch(SQLExceptione){e.printStackTrace();}finally{JdbcCon.closeAll(null,ps,conn);}returnflag;}publicbooleanupdateFrom(intid,intsex,Stringname){booleanflag=false;Connectionconn=null;conn=JdbcCon.jdbcConM
3、ysql();Stringsql="updatepersonsetsex=?,name=?whereid=?";PreparedStatementps=null;try{ps=conn.prepareStatement(sql);ps.setInt(1,sex);ps.setString(2,name);ps.setInt(3,id);inti=ps.executeUpdate();if(i!=0){flag=true;}}catch(SQLExceptione){e.printStackTrace();}finally{JdbcCon.closeAll(null,ps,conn);}re
4、turnflag;}publicbooleandeleteFrom(intid){booleanflag=false;Connectionconn=null;conn=JdbcCon.jdbcConMysql();PreparedStatementps=null;Stringsql="deletefrompersonwhereid=?";try{ps=conn.prepareStatement(sql);ps.setInt(1,id);inti=ps.executeUpdate();if(i!=0){flag=true;}}catch(SQLExceptione){e.printStack
5、Trace();}finally{JdbcCon.closeAll(null,ps,conn);}returnflag;}publicPersonselectFrom(Stringname,intid){Personper=null;Connectionconn=null;conn=JdbcCon.jdbcConMysql();Stringsql="select*frompersonwhereid=?andname=?";PreparedStatementps=null;ResultSetrs=null;try{ps=conn.prepareStatement(sql);ps.setInt
6、(1,id);ps.setString(2,name);rs=ps.executeQuery();while(rs.next()){per=newPerson();per.setBirthday(rs.getDate("birthday"));per.setId(rs.getInt("id"));per.setName(rs.getString("name"));per.setSex(rs.getInt("sex"));}}catch(SQLExceptione){e.printStackTrace();}finally{JdbcCon.closeAll(rs,ps,conn);}retu
7、rnper;}Oracle数据库:publicbooleaninsertStu(Stustu){booleanflag=false;Connectionconn=null;Statementst=null;StringBuildersql=newStringBuilder();sql.append("insertintostu(id,stu_num,stu_name)values(seq_stu_id.nextval,'