DBUTILS的简单的插入和修改操作

最新推荐文章于 2021-01-19 05:34:33 发布

bfxyly

最新推荐文章于 2021-01-19 05:34:33 发布

阅读量823

点赞数 1

分类专栏： J2SE 文章标签： string character sql mysql insert jdbc

本文链接：https://blog.csdn.net/bfxyly/article/details/7551317

版权

J2SE 专栏收录该内容

2 篇文章 0 订阅

订阅专栏

也可以在这里查看地址:http://micely.net/sourceCodeDetail/204

下面是代码:

package db;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

import org.apache.commons.dbutils.QueryRunner;

public class T {
	public static Connection getConnection() throws SQLException,
			InstantiationException, IllegalAccessException,
			ClassNotFoundException {
		String strDriver = "org.gjt.mm.mysql.Driver";
		String strUrl = "jdbc:mysql://localhost:3306/test";
		String strUser = "root";
		String strPass = "abc";
		Class.forName(strDriver).newInstance();
		return DriverManager.getConnection(strUrl, strUser, strPass);
	}

	public static void main(String[] args) {
		// String sql = "insert into tab(id,name)values(?,?)";
		// Object params[] = { 5, "aaa" };
		String sql = "update tab set name=? where id=?";
		Object params[] = { "xxx", 5 };
		QueryRunner runner = new QueryRunner();
		Connection conn = null;
		try {
			conn = getConnection();
			runner.update(conn, sql, params);
		} catch (SQLException e) {
			e.printStackTrace();
		} catch (InstantiationException e) {
			e.printStackTrace();
		} catch (IllegalAccessException e) {
			e.printStackTrace();
		} catch (ClassNotFoundException e) {
			e.printStackTrace();
		} finally {
			if (conn != null) {
				try {
					conn.close();
				} catch (SQLException e) {
					e.printStackTrace();
				}
			}
		}
	}
}

mysql的表

create table tab(
	id int(4),
	name varchar(8)
)engine=innodb character set=utf8;