67,513
社区成员
发帖
与我相关
我的任务
分享
public int deteteEmployeeById(String employeeId) {
int flag = -1;
String sql = "delete employeeManager where employee_id=" + employeeId;
System.out.println(sql);
Connection con = DBCon.getConnection();
try {
Statement stm = con.createStatement();
flag = stm.executeUpdate(sql);
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} finally {
DBCon.closeConnection(con);
}
return flag;
}
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
public class OracleOperating{
private final static String DB_URL = "jdbc:oracle:thin:@你的ID:1521:数据库名称";
private final static String DB_DRIVER = "oracle.jdbc.driver.OracleDriver";
private final static String DB_USERNAME = "你的用户名";
private final static String DB_PASSWORD = "你的密码";
public Connection getConnection(){
Connection conn = null;
try{
Class.forName(DB_DRIVER);
conn = DriverManager.getConnection(DB_URL,DB_USERNAME,DB_PASSWORD);
}catch(Exception ex){
ex.printStackTrace();
}
return conn;
}
public void closeConnection(Connection conn){
try{
if(conn!=null){
if(!conn.isClosed()){
conn.close();
}
}
}catch(Exception ex){
ex.printStackTrace();
}
}
public void select(String param) throws SQLException{
Connection conn=getConnection();
String sql="SELECT * FROM (select t.data_kbn,t.date1,t.text1,t.text5,t.text6,t.setumei, " +
"RANK() OVER (partition by t.data_kbn, t.key2 ORDER BY t.date1 DESC) T " +
"from c_jk_syorijyokyo t where t.data_kbn = 1) TT where tt.T = 1;";
PreparedStatement pstat=conn.prepareStatement(sql);
ResultSet rs=pstat.executeQuery();
while(rs.next()){
System.out.println(rs.getString(1));
System.out.println(rs.getString(2));
System.out.println(rs.getString(3));
.......
}
rs.close();
closeConnection(conn);
}
}