Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import java.sql.*;
- public class statemetn2 {
- public static void main(String[] args) throws Exception{
- // TODO Auto-generated method stub
- String JDBCDrivers = "oracle.jdbc.driver.OracleDriver";
- String useThisDriver_url = "jdbc:oracle:thin:@localhost:1521:xe";
- Class.forName(JDBCDrivers);
- Connection con = DriverManager.getConnection(useThisDriver_url,"user08","1111");
- PreparedStatement pstmt = con.prepareStatement("SELECT * from EMP2 where EMPNO=7001");
- ResultSet rs = pstmt.executeQuery();
- while(rs.next()){
- String col1 = rs.getString(1);
- String col2 = rs.getString(2);
- System.out.print("EMPNO: " + col1 );
- System.out.print("\tEMPNAME: " + col2);
- }
- rs.close(); stmt.close(); con.close();
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement