package blog;
import java.sql.*;
import java.util.Properties;
import blog.exception.DBException;
import blog.util.DBUtil;
public class AddStudentDao implements IAddStudentDao {
@Override
public boolean addStudent(AddStudentForm studentForm) {
//使用JDBC操作数据
Connection conn = null;
PreparedStatement pstmt = null;
//Statement stmt = null;
//ResultSet rs = null;
//1、首先注册具体数据库的驱动包
try {
//Driver myDriver = (Driver) Class.forName("oracle.jdbc.OracleDriver").newInstance();
Driver myDriver = (Driver) Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
//2、利用DriverManager获取数据库连接对象Connection
Properties properties = new Properties();
properties.put("user", "xzf");
properties.put("password", "1234");
conn = myDriver.connect("jdbc:oracle:thin:@127.0.0.1:1521:orcl",properties);
String sql = " insert into students values(? ,? ,? ,?)";
//3、创建语句对象
System.out.println("major: " + studentForm.getMajor());
pstmt = conn.prepareStatement(sql);
pstmt.setInt(1,studentForm.getsId());
pstmt.setString(2, studentForm.getsName());
pstmt.setString(3, studentForm.getMajor());
pstmt.setInt(4, studentForm.getScore());
//4、执行SQL操作,返回结果集ResultSet
int count = pstmt.executeUpdate();
System.out.println("影响行数:" + count);
return true;
} catch (Exception e) {
e.printStackTrace();
return false;
}finally{
try {
6. 关闭数据库资源,关闭的顺序与申明的顺序相反
//if(rs!=null)rs.close();
if(pstmt!=null)pstmt.close();
if(conn!=null)conn.close();
} catch (SQLException e) {
e.printStackTrace();
return false;
}
}
}
}
转载于:https://www.cnblogs.com/xzf007/archive/2012/07/28/2873835.html