jdbc实现查询和添加

jdbc实现查询和添加

##1.1连接数据库
代码如下（示例）：

package dao;

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

public class Utils {
   
private static String DRIVER = "com.mysql.jdbc.Driver";
private static String URL = "jdbc:mysql://localhost:3306/student?characterEncoding=utf8";
private static String USERNAME = "root";
private static String PWD = "root";
public static Connection getConnection() throws ClassNotFoundException, SQLException {
   
	Connection connection = null;
	Class.forName(DRIVER);
	connection = DriverManager.getConnection(URL,USERNAME,PWD);
	return connection;
}
public static void closeAll(Connection connection,Statement statement,ResultSet resultSet) throws SQLException {
   
	
	
	if (resultSet != null) {
   
		resultSet.close();
	}
	if (statement !=null) {
   
		statement.close();
		
	}
	if(connection !=null) {
   
		connection.close();
	}
}
}

##1.2测试数据库是否连接成功

代码如下（示例）：

package dao;

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

import model.Student;

public class Test {
   
public