javaEE课程设计(12)

桂林电子科技大学 计算机与工程学院 信息管理与信息系统 JavaEE 课程设计 报告

Patient JavaBen的添加功能

public boolean add() {

boolean addflag = false;

Connection conn = null;

Statement stmt = null;

ResultSet rs = null;

try {

Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");

conn = DriverManager.getConnection("jdbc:sqlserver://localhost:1433;" + " DatabaseName=MyHospital", "root", "123");

stmt = conn.createStatement();

String sql = "insert into DoctorImfomation values(?,?,?,?,?,?)"; java.sql.PreparedStatement psmt = conn.prepareStatement(sql); psmt.setString(1, );

psmt.setString(2, this.no);

psmt.setString(3, this.major);

psmt.setString(4, this.introduction);

psmt.setString(5, this.workTime);

psmt.setString(6, this.telephone);

int rowCount = psmt.executeUpdate();

if (rowCount > 0) {

addflag = true;

}

} catch (Exception e) {

e.printStackTrace();

} finally {

if (conn != null) {

try {

conn.close();

} catch (SQLException s) {

s.printStackTrace();

}

}

}

return addflag;

}

Patient JavaBen的删除功能

try {