JDBC-CURD

1.准备mysq架包：mysql5.1.7

修改、添加、删除：executeUpdate
查询：executeQuery

2.乱码：jdbc.jdbcUrl=jdbc:mysql:///ssm?useUnicode=true&characterEncoding=utf-8
入门代码

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
//入门代码
public class jdbc {
   
	public static void main(String[] args) throws Exception {
   
		// 注册驱动
		Class.forName("com.mysql.jdbc.Driver");
		// 连接数据库对象
		Connection connection = DriverManager.getConnection(
				"jdbc:mysql://localhost:3306/testdb", "test", "123456");
		// 定义sql语句
		String sql = "select * from user";
		// 获取执行sql的对象Statement
		Statement stmt = connection.createStatement();
		// 执行sql
		ResultSet executeQuery = stmt.executeQuery(sql);
		
		while (executeQuery.next()) {
   
		String a = executeQuery.getString(1);
		System.out.println(a);
		System.out.println("======");
	     System.out.println(executeQuery.getString("username"));
	     String b = executeQuery.getString("password");
	     System.out.println(b);
		}
		// 释放资源
		stmt.close();
		connection.close();

	}
}

查询：

public class select {
   
	public static void main(String[] args) {
   
		Connection conn = null;
		Statement stmt = null;
		ResultSet rs = null;
		// 注册驱动
		try {
   
			Class.forName("com.mysql.jdbc.Driver");
			// 获取Connection对象
			conn = DriverManager.getConnection("jdbc:mysql:///test", "root",
					"123456");
			// 定义sql
			String sql = "select * from admin";
			// 获取执行sql对象
			stmt = conn.createStatement();
			// 执行sql
			rs