insertdata.java

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

package dbconnect;

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

import java.io.BufferedReader;
import java.io.IOException;
import java.io.InputStreamReader;

public class InsertData {

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

		String sqlString;
		String name, limit_time, number;

		DbConnect dbcon=new DbConnect();
		dbcon.connect();

			name = getInput("请输入考试名称：");
			limit_time = getInput("请输入时间限制：");
			number = getInput("请输入题量：");
			/*
			 * sqlString="insert into testpaper values('" + name + "','" +
			 * limit_time + "','" + number + "')";
			 * stmt.executeUpdate(sqlString);
			 */
			sqlString = "insert into test_paper values(?,?,?)";
			ps = (dbcon.getConnction()).prepareStatement(sqlString);
			ps.setString(1, name);
			ps.setString(2, limit_time);
			ps.setString(3, number);
			ps.executeUpdate();
			System.out.println("插入成功!");
			if (dbcon.getConnction() == null) {
				System.out.println("数据库连接失败");
			} else
				System.out.println("数据库连接成功");
		dbcon.disconnect();
		}

	public static String getInput(String msg) {
		String result = null;
		try {
			// 创建用户输入流
			BufferedReader in = new BufferedReader(new InputStreamReader(
					System.in));
			System.out.print(msg);
			result = in.readLine();
		} catch (IOException e) {
			e.printStackTrace();
		}
		return result;
	}

}