JDBC（Java数据库连接）

小白学习视频（连接mysql）

Stu类：存表中记录

package cn.jdbc.entity;

import java.io.Serializable;


public class Stu implements Serializable{
	
	private String sid;
	private String sname;
	private Integer age;
	private String gender;
	

	
	public Stu() {
		super();
	}
	public Stu(String sid, String sname, Integer age, String gender) {
		super();
		this.sid = sid;
		this.sname = sname;
		this.age = age;
		this.gender = gender;
	}
	public String getSid() {
		return sid;
	}
	public void setSid(String sid) {
		this.sid = sid;
	}
	public String getSname() {
		return sname;
	}
	public void setSname(String sname) {
		this.sname = sname;
	}
	public Integer getAge() {
		return age;
	}
	public void setAge(Integer age) {
		this.age = age;
	}
	public String getGender() {
		return gender;
	}
	public void setGender(String gender) {
		this.gender = gender;
	}

}

操作数据库的 java代码

package cn.jdbc.dao;

import java.util.List;

import cn.jdbc.entity.Stu;

public interface StudentDao {
	/**
	 * 查询所有学生信息
	 * @return
	 */
	List<Stu>getUsersList();
/**
 * 根据学号和姓名获取信息
 * @param name
 * @param id
 * @return
 */
	Stu getStu(String id,String name);
	/**
	 * 模糊查询学生信息
	 * @param name
	 * @return
	 */
	List<Stu> getUserListLikeName(String name);
	
	/**
	 * 插入学生信息
	 * @param stu
	 * @return
	 */
	Boolean insert(Stu stu);
	/**
	 * 删除学生信息
	 * @param stu
	 * @return
	 */
	Boolean delete(String sname);
	/**
	 * 修改学生信息
	 */
	Boolean update(String sid,Integer Sage);
}

3. 实现StudentDao接口的实现类

package cn.jdbc.dao;

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.List;
import java.sql.*;
import com.mysql.jdbc.PreparedStatement;

import cn.jdbc.entity.Stu;

public class StudentDaoImpl extends BaseDao implements StudentDao {
	
	private final String URL="jdbc:mysql://localhost:3306/db_person";
	private final String USENAME="root";
	private final String PASSWORD="123yeszjingqi";
	private final String DRIVE="com.mysql.jdbc.Driver";
	
	public List<Stu> getUsersList() {
		Connection conn=null;
		Statement s