JDBC增删改查以及封装数据

JDBC增删改查以及封装数据

我太爱我的java张春凤老师了，张春凤老师永远滴女神！

下面是我的mysql信息：
我的mysql为5.5版本，老东西了见谅哈！mysql版本不同，connection连接的内容也不一样，这个需要注意！还有就是注意端口号，账号密码，sql语句要正确填写哦！！！

下面是jdbc的增删改部分：

package will.delete.test;

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

//增删改
public class TestZSG {

	public static void main(String[] args) {
		Statement statement = null;
		Connection connection = null;
		try {
			Class.forName("com.mysql.jdbc.Driver");
			String sql = "UPDATE academy_info SET academy_name = '狐闹' WHERE id = 3";
			connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/zua_stuablity?characterEncoding=utf8",
					"root", "wdc123");
			statement = connection.createStatement();
			int count = statement.executeUpdate(sql);
			System.out.println(count);
			if (count > 0) {
				System.out.println("ok");
			} else {
				System.out.println("no");
			}
		} catch (ClassNotFoundException e) {
			e.printStackTrace();
		} catch (SQLException e) {
			e.printStackTrace();
		} finally {
			if (statement != null) {
				try {
					statement.close();
				} catch (SQLException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				}
			}
			if (connection != null) {
				try {
					connection.close();
				} catch (SQLException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				}
			}
		}

	}
}

下面是普通的jdbc的查看部分：

package will.delete.test;

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

public class TestCha {

	public static void main(String[] args) {
		Connection connection = null;
		Statement statement = null;
		ResultSet resultSet = null;
		try {
			Class.forName("com.mysql.jdbc.Driver");
			connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/zua_stuablity?characterEncoding=utf8",
					"root", "wdc123");
			String sql = "SELECT * FROM academy_info";
			statement = connection.createStatement();
			resultSet = statement.executeQuery(sql);
			while (resultSet.next()) {
				int id = resultSet.getInt("id");
				String name = resultSet.getString("academy_name");
				Date time = resultSet.getDate("create_time");
				int flag = resultSet.getInt("delete_flag");
				System.out.println(id + "#" + name + "#" + time + "#" + flag);
			}
		} catch (ClassNotFoundException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} finally {
			if (resultSet != null) {
				try {
					resultSet.close();
				} catch (SQLException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				}

			}
			if (statement != null) {
				try {
					statement.close();
				} catch (SQLException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				}

			}
			if (connection != null) {
				try {
					connection.close();
				} catch (SQLException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				}

			}
		}

	}

}

下面是list封装对象的jdbc的查看部分：

1.平平无奇的getter setter tostring方法

package cn.itcast.demoList;

import java.util.Date;

//封装academy_info表数据的JavaBean
public class academy_info {
	private int id;
	private String academy_name;
	private Date create_time;
	private int delete_flag;

	public int getId() {
		return id;
	}

	public void setId(int id) {
		this.id = id;
	}

	public String getAcademy_name() {
		return academy_name;
	}

	public void setAcademy_name(String academy_name) {
		this.academy_name = academy_name;
	}

	public Date getCreate_time() {
		return create_time;
	}

	public void setCreate_time(Date create_time) {
		this.create_time = create_time;
	}

	public int getDelete_flag() {
		return delete_flag;
	}

	public void setDelete_flag(int delete_flag) {
		this.delete_flag = delete_flag;
	}

	@Override
	public String toString() {
		return "academy_info [id=" + id + ", academy_name=" + academy_name + ", create_time=" + create_time
				+ ", delete_flag=" + delete_flag + "]";
	}

}

2.list的细节操作

package cn.itcast.demoList;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class Test {

	public static void main(String[] args) {
		List<academy_info> list = new Test().findall();
		System.out.println(list);
		System.out.println(list.size());
	}

	public List<academy_info> findall() {
		Connection connection = null;
		Statement statement = null;
		ResultSet resultSet = null;
		List<academy_info> list = null;
		try {
			Class.forName("com.mysql.jdbc.Driver");
			connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/zua_stuablity?characterEncoding=utf8",
					"root", "wdc123");
			String sql = "SELECT * FROM academy_info";
			statement = connection.createStatement();
			resultSet = statement.executeQuery(sql);
			academy_info aInfo = null;
			list = new ArrayList<academy_info>();
			while (resultSet.next()) {
				int id = resultSet.getInt("id");
				String name = resultSet.getString("academy_name");
				Date time = resultSet.getDate("create_time");
				int flag = resultSet.getInt("delete_flag");
				aInfo = new academy_info();
				aInfo.setId(id);
				aInfo.setAcademy_name(name);
				aInfo.setCreate_time(time);
				aInfo.setDelete_flag(flag);

				list.add(aInfo);
			}
		} catch (ClassNotFoundException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} finally {
			try {
				resultSet.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
			try {
				statement.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
			try {
				connection.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
		return list;
	}
}

jdbc冲刺！