?? addcourseaction.java
字號:
package edu.xscj.action;
import java.sql.Connection;
import edu.xscj.conn.ConnectDataBase;
import edu.xscj.bean.*;
import java.sql.PreparedStatement;
public class AddCourseAction {
Connection conn = null;
public AddCourseAction() {
if (conn == null) {
conn = ConnectDataBase.getConn();
}
}
public void setConn() {
if (conn == null) {
conn = ConnectDataBase.getConn();
}
}
public String addCourse(Course course) {
PreparedStatement pstmt = null;
String str = "";
try {
if (conn == null) {
this.setConn();
}
pstmt = conn.prepareStatement("insert into course values(?,?,?)");
pstmt.setString(1, course.getCourNo());
pstmt.setString(2, course.getCourName());
pstmt.setInt(3, course.getCourXuefen());
pstmt.execute();
str = "sucess";
} catch (Exception ex) {
str = "failer";
} finally {
try {
if (pstmt != null) {
pstmt.close();
}
if (conn != null) {
conn.close();
}
} catch (Exception e) {
e.printStackTrace();
}
}
return str;
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -