学生表用MySQL增删改查_Java用类实现对Student数据表(Mysql)的操作（增删改查）

Java连接mysql数据库利用了mysql-JDBC的jar包，查询操作用的是executeQuery()方法，除了查询操作外的增删改都是用executeUpdate()方法实现。

代码：

Student类

package test;

public class Student {

private int id;

private String name;

private int age;

public Student(int id, String name, int age) {

super();

this.id = id;

this.name = name;

this.age = age;

}

public int getId() {

return id;

}

public void setId(int id) {

this.id = id;

}

public String getName() {

return name;

}

public void setName(String name) {

this.name = name;

}

public int getAge() {

return age;

}

public void setAge(int age) {

this.age = age;

}

@Override

public String toString() {

return "Student [id=" + id + ", name=" + name + ", age=" + age + "]";

}

}

Sql类：

package test;

import java.util.ArrayList;

import java.util.List;

import java.util.Scanner;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.SQLException;

public class Sql {

Connection con;

public Connection getConn() throws SQLException, ClassNotFoundException {

Class.forName("com.mysql.jdbc.Driver&