黑猴子的家:JDBC -> PreparedStateme
2019-03-01 本文已影响0人
黑猴子的家
1、检查是否继承了AutoCloseable类
2、改写代码
package com.yinggu.demo3;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.util.Scanner;
import org.junit.Test;
import com.yinggu.utils.JDBCUtils;
* 使用PreparedStatement实现增删改查
*
* @author:黑猴子的家
* @博客 :https://www.jianshu.com/u/37fd8e2dff4c
public class TestPreparedStatement {
Scanner input = new Scanner(System.in);
@Test
public void testInsert() {
System.out.println("请输入考生的详细信息");
System.out.print("Type:");
int type = input.nextInt();
System.out.print("IDCard:");
String idCard = input.next();
System.out.print("ExamCard:");
String examCard = input.next();
System.out.print("StudentName:");
String studentName = input.next();
System.out.print("location:");
String location = input.next();
System.out.print("Grade:");
int grade = input.nextInt();
// ------------------------以下为连接数据库的步骤-------------------
try (
// 1.获取连接
Connection connection = JDBCUtils.getConnection();
// 2.访问数据库,执行操作
PreparedStatement statement = connection.prepareStatement(
"insert into examstudent values(null,?,?,?,?,?,?)");
)
{
statement.setInt(1, type);
statement.setString(2, idCard);
statement.setString(3, examCard);
statement.setString(4, studentName);
statement.setString(5, location);
statement.setInt(6, grade);
int update = statement.executeUpdate();
System.out.println(update > 0 ? "success" : "failure");
} catch (Exception e) {
e.printStackTrace();
}
}
}