updatedata.java

来自「远程电子考试系统」· Java 代码 · 共 41 行

package dbconnect;

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

public class UpdateData {

	/**
	 * @param args
	 * @throws SQLException
	 */
	public static void main(String[] args) throws SQLException {
		// TODO 自动生成方法存根
		// Statement stmt;

		// String sqlString;
		int k;

		DbConnect dbcon=new DbConnect();
		dbcon.connect();
			PreparedStatement ps = (dbcon.getConnction())
					.prepareStatement("update test_paper set limit_time=? where test_name=?");

			ps.setString(1, "7");
			ps.setString(2, "java 知识测试");
			ps.executeUpdate();
			System.out.println("更新成功!");
			k = ps.executeUpdate();
			System.out.println("修改了" + k + "条记录");

			ps.close();

		dbcon.disconnect();
		}
	}