发布时间: 2012-07-01 13:15:00 作者: rapoo
java连接mysql示例代码package com.qiyi.datatools;import java.sql.Connection;import java.sql.DriverManager;import java.sql.PreparedStatement;import java.sql.ResultSet;import java.util.ArrayList;import junit.framework.TestCase;import org.junit.After;import org.junit.Before;import org.junit.Test;public class TableVoHelper extends TestCase {@Testpublic void testOp() throws Exception {pstmt = con.prepareStatement("delete from tableB");pstmt.execute();pstmt = con.prepareStatement("select * from tableA ");rs = pstmt.executeQuery();ArrayList<TableVo> tVoList = new ArrayList<TableVo>();while (rs.next()) {TableVo tVo = new TableVo();tVo.setId(rs.getInt(1));tVoList.add(tVo);}pstmt = con.prepareStatement("insert into tableB(id)values (?)");for (TableVo tVo : tVoList) {pstmt.setInt(1, tVo.getId());pstmt.execute();}}@Beforepublic void setUp() throws Exception {String CLASSNAME = "com.mysql.jdbc.Driver";String URL = "jdbc:mysql://localhost:3306/fiona";String UNAME = "root";String PWD = "root";Class.forName(CLASSNAME);con = DriverManager.getConnection(URL, UNAME, PWD);}@Afterpublic void tearDown() throws Exception {if (rs != null) {rs.close();}if (pstmt != null) {pstmt.close();}if (con != null) {con.close();}}Connection con = null;PreparedStatement pstmt = null;ResultSet rs = null;class TableVo {public int getId() {return id;}public void setId(int id) {this.id = id;}private int id;}}
mysql 5.6中sql语句统计每个目录的具体
MySQL删除重复数据行只保存一条
Mysql容易存储过程入门示例与Java调用
MySQL双主机双Master提案测试
MySQL增添数据文件
MySQL截取字符串函数步骤
绿色mysql下载地址
mysql设立访问权限
从Oracle迁移到Mysql事先必须知道的50
Mysql主从形式搭建