Skip to main content

Q) What are some important shortcuts to interact with MyEclipse




A)
Ctrl+s
for saving
Ctrl+m
For minimizing / maximizing
Syso+ctrl+spacebar
For System.out.println()
Ctrl+w
For closing a file
Ctrl+shift+w
For closing all files
Ctrl+/
For connecting or un connecting
Ctrl+d
For deletion of a line which the cursor is pointing
Ctrl+shift+o
For organizing imports. The means un import things are import and un necessary imports are removed
Ctrl+shift+f
For formatting the code
Ctrl+z
For undo
Ctrl+y
For redo

Comments

Popular posts from this blog

Q) Retrieving data from database?

A)   ->to retrieve the data from database we need to submit SELECT statement from JDBC application. -> executeQuery() method of statement object is used for this purpose. This method has the fallowing ResultSet executeQuery(String sql) throws SQLException Ex: ResultSet rs = st.executeQuery(“SELECT * FROM ACCOUNT”); ->objectoriented representation of tables formate data is called ResultSet object. Ao the driver created one object i.e. ResultSet object. ->object orientation representation of a table of records returned from db is nothing but “ ResultSet ” object.  

Q) Explain repeated deletion of records.

A) //RepeatedDeletion.java import java.util.Scanner; import java.sql.*; class RepeatedDeletion {        public static void main(String[] args) {               Connection con= DriverManager. getConnection ( "jdbc:odbc:prince" , "scott" , "tiger" );               PreparedStatement ps=con.PreparedStatement( "DELETE FROM ACCOUNT WHERE ACCNO=?" );               Scanner s= new Scanner(System. in );               while ( true )               {                      System. out .println( "Enter accno : " );      ...

Q) Explain about Types of java database connectivity approaches?

A) ->there are 2 types of connectivity from java application to database server. 1) JDBC-ODBC approach 2) JDBC approach JDBC-ODBC approach: ->in this kind of connectivity sun Microsystems provided driver is used. ->this driver class is”sun.jdbc.odbc.JdbcOdbcDriver”. ->this driver translates JDBC method calls into ODBC function calls. It can’t translate them into ODBC understandable (SQL) calls. ->In order to associate sun driver with ODBC driver we need to externally make some configuration and give some name to that configuration which is known as DSN ( Data Source Name). Note: ->DNS is a user defined name given to a configuration in which ODBC driver and underlying database are involved. ->Using ODBC data source Administrator which is a graphical tool. We configure the DNS. Start->settings->control panel->Administrator tools->data sources(ODBC)->ODBC data source administrator graphical tool is displayed-> click ”add” button ->select the DB-...