package basic;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class JDBC {
public void findAll() {
try {
// è·å¾æ°æ®åºé©±å¨
//ç±äºé¿æ¶é´ä¸åï¼é©±å¨ååURLé½å¿è®°äºï¼ä¸ç¥é对ä¸å¯¹ï¼ä½ åºè¯¥ç¥éçï¼èªå·±æ¹ä¸ä¸çå
String url = "jdbc:oracle:thin:@localhost:1521:XE";
String userName = "system";
String password = "system";
Class.forName("oracle.jdbc.driver.OracleDriver");
// å建è¿æ¥
Connection conn = DriverManager.getConnection(url, userName,
password);
// æ°å»ºåésqlè¯å¥ç对象
Statement st = conn.createStatement();
// æ§è¡sql
String sql = "select * from users";
ResultSet rs = st.executeQuery(sql);
// å¤çç»æ
while(rs.next()){
//è¿ä¸ªå°æ¹å°±æ¯ç»ä½ çå°è£
ç±»å±æ§èµå¼
System.out.println("UserNameï¼"+rs.getString(0));
}
// å
³éè¿æ¥
rs.close();
st.close();
conn.close();
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
public void delete(){
try {
//æ¥éª¤è¿æ¯é£å
个æ¥éª¤ï¼åè¾¹ç两æ¥æ¯ä¸æ ·ç
String url = "jdbc:oracle:thin:@localhost:1521:XE";
String userName = "system";
String password = "system";
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection conn = DriverManager.getConnection(url,userName,password);
//è¿éçåésqlè¯å¥ç对象æ¯PreparedStatement,æ为é¢å¤çsql对象ï¼å 为ææ¡ä»¶å é¤æ¯éè¦ä¸å®å¼ç
String sql = "delete from users where id = ?";
PreparedStatement ps = conn.prepareStatement(sql);
ps.setInt(0, 1);
int row = ps.executeUpdate();
if(row!=0){
System.out.println("å é¤æåï¼");
}
// å
³éè¿æ¥
rs.close();
st.close();
conn.close();
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
温馨提示:答案为网友推荐,仅供参考