Write a JDBC program to remove “percentage” column from student (rno, sname, percentage) table

By
import java.io.*;
import java.sql.*;
public class RemoveColumn
{           static Connection cn;
            static Statement st;
            static ResultSet rs;
            public static void main(String args[])
            {           try{
                                    BufferedReader br=new BufferedReader(new InputStreamReader(System.in));
                                    Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
                                    cn=DriverManager.getConnection("jdbc:odbc:dsn","","");
                                    st=cn.createStatement();
                                    rs=st.executeQuery("select * from student");
                                    while(rs.next())
                                    {
                        System.out.println(rs.getInt("rno")+"\t"+rs.getString("sname")+"\t"+rs.getInt("percentage"));                               }
                                    String str="alter table student drop column percentage";
                                    st.executeUpdate(str);
                                    System.out.println("Column is remove");
                                    rs=st.executeQuery("select * from student");
                                    while(rs.next()) {
                                                                     System.out.println(rs.getInt("rno")+"\t"+rs.getString("sname"));
                                                                  }
                                    cn.close();      
                        }catch(Exception e){
                                                               System.out.println(e);
                                                           }
            }
}

Comments

Post a Comment

Popular posts from this blog

Write a java program to create Teacher table(TNo.TName, Sal, Desg) and insert a record in it.

By
import java.io.*; import java.sql.*; public class CreateTeacherTable {            static Connection cn;             static Statement st;             public static void main(String args[])             {                    try                  {                                 int tno,sal;                         String tname,desg;                         BufferedReader br=new BufferedReader(new InputStreamReader(System.in));                         Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");    ...
Read more

Create a JSP page to accept a number from an user and display it in words: Example: 123 – One Two Three. The output should be in red color.

By
NumberWord.html <html> <body> <form method=get action="NumberWord.jsp"> Enter Any Number : <input type=text name=num><br><br> <input type=submit value="Display"> </form> <body> </html> NumberWord.jsp <html> <body> <font color=red> <%! int i,n;        String s1; %> <%   s1=request.getParameter("num");          n=s1.length();          i=0;          do          {            char ch=s1.charAt(i);            switch(ch)             {                 case '0': out.println("Zero...
Read more

Write a JSP program to accept the details of Account (ANo, Type, Bal) and store it into database and display it in tabular form. (Use PreparedStatement interface)

By
SaveAccount.html <html> <body> <form method=get action="saveAccount.jsp"> Enter Account No. : <input type=text name=ano><br><br> Enter Account Type:<input type=text name=type><br><br> Enter Balance : <input type=text name=bal><br><br> <input type=submit value="Save"> </form> </body> </html> saveAccount.jsp <html> <body> <%@ page import="java.sql.*;" %> <%! int ano,bal;        String type;  %> <%       ano=Integer.parseInt(request.getParameter("ano"));       type=request.getParameter("type");       bal=Integer.parseInt(request.getParameter("bal"));       try{             Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");           ...
Read more