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