}
if(stmt != null){
stmt.close();
}
if(conn != null){
conn.close();
}
} catch (SQLException e) {
e.printStackTrace();
}
}
/**
* 读取属性文件中的信息
*
* @param key
* @return
*/
private static String getValue(String key) {
// 资源包绑定
ResourceBundle bundle = ResourceBundle.getBundle("jdbc");
return bundle.getString(key);
}
public static void main(String[] args) {
System.out.println(getValue("jdbc.driver"));
System.out.println(getConnection());
}
}
StudentDao.java
我的代码还没有补全,使用的Statement
语句
package homework;
import java.sql.Connection;
import java.sql.Date;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;
/**
* @author StarsOne
* @date Create in 2019/4/24 0024 22:24
* @description
*/
class StudentDao {
/**
* 添加一个
* @param student
*/
public void save(Student student) {
String name = student.getName();
int num = student.getNum();
Connection connection = null;
Statement statement = null;
try {
connection = JdbcUtil.getConnection();
statement = connection.createStatement();
//拼接SQL语句,把数据插入到数据库中
statement.execute("insert into STUDENT value(" + num + "," + name + ") ");
} catch (SQLException e) {
e.printStackTrace();
} finally {
JdbcUtil.close(connection, statement, null);
}
}
public void update(Student student) {
}
/**
* 删除指定编号的学生
* @param num
*/
public void delete(Integer num) {
Connection connection = null;
Statement statement = null;
try {
connection = JdbcUtil.getConnection();
statement = connection.createStatement();
//拼接SQL语句,把数据插入到数据库中
boolean flag = statement.execute("delete from STUDENT where num = " + num);
if (flag) {
System.out.println("删除成功!");
} else {
System.out.println("删除失败!");
}
} catch (SQLException e) {
e.printStackTrace();
} finally {
JdbcUtil.close(connection, statement, null);
}
}
/**
* 主键查询
* @param number
*/
public void findByPK(Integer number) {
Connection connection = null;
Statement statement = null;
ResultSet resultSet=null;
try {
connection = JdbcUtil.getConnection();
statement = connection.createStatement();
//查询query,返回一个数据集
resultSet = statement.executeQuery("select * from STUDENT where num =" + number);
while (resultSet.next()) {
int num = resultSet.getInt("num");
String name = resultSet.getString("name");
String sex = resultSet.getString("sex");
int age = resultSet.getInt("age");
Date birthdate = resultSet.getDate("birthdate");
double grade = resultSet.getDouble("grade");
//新建一个对象
new Student(num, age, grade, name, sex, birthdate);
}
} catch (SQLException e) {
e.printStackTrace();
} finally {
JdbcUtil.close(connection, statement, resultSet);
}
}
/**
* 查询全部
* @return
*/
public List<Student> findAll() {
List<Student> list = new ArrayList<>();
Connection connection = null;
Statement statement = null;
ResultSet resultSet=null;
try {
connection = JdbcUtil.getConnection();
statement = connection.createStatement();
//查询query,返回一个数据集
resultSet = statement.executeQuery("select * from STUDENT" );
while (resultSet.next()) {
int num = resultSet.getInt("num");
String name = resultSe