Mysql JDBC的简单实现

通过PerparedStatement进行数据库的增删改查
    

package z1;

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

public class Preparedstatement {
	private static final String URL = "jdbc:mysql://localhost:3306/test";
	private static final String USERNAME = "root";
	private static final String PWD = "0000000";

	// 创建获取用来建立于数据库进行连接的connection对象的工具方法
	public static Connection creatconnection() throws Throwable {
		// a.导入驱动，加载具体的驱动类
		Class.forName("com.mysql.jdbc.Driver");
		// b.与数据库建立连接
		Connection connection = DriverManager.getConnection(URL, USERNAME, PWD);
		// 返回connection对象
		return connection;
	}

	// 创建增加的实现
	public static void insert(int s1, String s2) throws Throwable {
		// 获取connection对象
		Connection connection = creatconnection();
		// 创建通用sql语句
		String insertsql = "insert into test values (?,?)";
		// 调用connection.preparestatement方法，获取preparestatement对象
		PreparedStatement prepareStatement = connection.prepareStatement(insertsql);
		// 更改占位符？所代表的信息
		prepareStatement.setInt(1, s1);
		prepareStatement.setString(2, s2);
		// 通过executeupdate方法进行增加，当返回值大于0时，成功
		int i = prepareStatement.executeUpdate();
		if (i > 0)
			System.out.println("增加成功");
	}

	public static void selectall() throws Throwable {
		// 获取connection对象
		Connection connection = creatconnection();
		// 创建通用sql语句
		String sql = "select * from test";
		// 调用connection.preparestatement方法，获取preparestatement对象
		PreparedStatement prepareStatement = connection.prepareStatement(sql);
		//调用executequery进行 查询，并接受返回结果
		ResultSet query = prepareStatement.executeQuery();
		//遍历输出所有结果S
		while (query.next()) {
			int id = query.getInt(1);
			String name = query.getString(2);
			System.out.println(id + "---" + name);
		}

	}

	public static void main(String[] args) throws Throwable {
		selectall();
	}
}