5th sem solution

Year 2017 Group B 2.Write a program to display records from the table “employee” that contains (id, name, post and salary) inside the database “testdb”.

import java.sql.*;
public class Ques2_2017 {
public static void main(String[] args) {
String url = "jdbc:mysql://localhost:3306/testdb";
String uname = "root";
String pwd = "";
try {
Class.forName("com.mysql.jdbc.Driver");
Connection con = DriverManager.getConnection(url, uname, pwd);
String sql = "select * from employee";
Statement st = con.createStatement();
ResultSet rs = st.executeQuery(sql);
while(rs.next()) {
        System.out.println(rs.getString("id"));
        System.out.println(rs.getString("name"));
        System.out.println(rs.getString("post"));
       System.out.println(rs.getString("salary"));
}
}catch(Exception ex) {
  System.out.println(ex);
     }
   }
 }

import java.sql.*;

public class Ques2_2017 {

public static void main(String[] args) {

String url = "jdbc:mysql://localhost:3306/testdb";

String uname = "root";

String pwd = "";

try {

Class.forName("com.mysql.jdbc.Driver");

Connection con = DriverManager.getConnection(url, uname, pwd);

String sql = "select * from employee";

Statement st = con.createStatement();

ResultSet rs = st.executeQuery(sql);

while(rs.next()) {

System.out.println(rs.getString("id"));

System.out.println(rs.getString("name"));

System.out.println(rs.getString("post"));

System.out.println(rs.getString("salary"));

}

}catch(Exception ex) {

System.out.println(ex);

}

Q.no 3 Create jsp page to display all odd numbers from 10 to 50

<%@page contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
  <title>Printing odd numbers from 10 to 50</title>
</head>
<body>
<% out.print("<b> odd numbers from 10 to 50</><br>");
for( int i=10;i<=50;i++) {
  if(i%2!==0){
        out.print("<br><b>"+i+"</b>");
   }
 }
%>
</body>
</html>

<%@page contentType="text/html" pageEncoding="UTF-8"%>

<!DOCTYPE html>

<html>

<head>

<title>Printing odd numbers from 10 to 50</title>

</head>

<body>

<% out.print(" odd numbers from 10 to 50</> ");

for( int i=10;i<=50;i++) {

if(i%2!==0){

out.print(" "+i+"");

}

</body>

</html>

Q.no 5 Write a servlet to find the reverse of a string.

import java.applet.*;
import java.awt.event.*;
import java.awt.*;
public class T2017_5 extends Applet implements ActionListener{
Panel p1,p2;
Label l1,l2,l3;
TextField t1,t2,t3;
Button b1,b2;
public void init(){
p1=new Panel();
p2=new Panel();
p1.setLayout(new GridLayout(3,2));
p2.setLayout(new FlowLayout());
l1=new Label("Number 1");
l2=new Label("Number 2");
l3=new Label("Result");
t1=new TextField();
t2=new TextField();
t3=new TextField();
t3.setEditable(false);
p1.add(l1); p1.add(t1);
p1.add(l2); p1.add(t2);
p1.add(l3); p1.add(t3);
add(p1); add(p2);
b1=new Button("+");
b2=new Button("-");
p2.add(b1); p2.add(b2);
}
public void start(){
b1.addActionListener(this);
b2.addActionListener(this);
}
public void actionPerformed(ActionEvent e){
int a=Integer.parseInt(t1.getText());
int b=Integer.parseInt(t2.getText());
if(e.getSource()==b1){
int c=a+b;
t3.setText(" "+c);
}
else if(e.getSource()==b2){
int c=a-b;
t3.setText(" "+c);
  }
 }
 }

import java.applet.*;

import java.awt.event.*;

import java.awt.*;

public class T2017_5 extends Applet implements ActionListener{

Panel p1,p2;

Label l1,l2,l3;

TextField t1,t2,t3;

Button b1,b2;

public void init(){

p1=new Panel();

p2=new Panel();

p1.setLayout(new GridLayout(3,2));

p2.setLayout(new FlowLayout());

l1=new Label("Number 1");

l2=new Label("Number 2");

l3=new Label("Result");

t1=new TextField();

t2=new TextField();

t3=new TextField();

t3.setEditable(false);

p1.add(l1); p1.add(t1);

p1.add(l2); p1.add(t2);

p1.add(l3); p1.add(t3);

add(p1); add(p2);

b1=new Button("+");

b2=new Button("-");

p2.add(b1); p2.add(b2);

}

public void start(){

b1.addActionListener(this);

b2.addActionListener(this);

}

public void actionPerformed(ActionEvent e){

int a=Integer.parseInt(t1.getText());

int b=Integer.parseInt(t2.getText());

if(e.getSource()==b1){

int c=a+b;

t3.setText(" "+c);

}

else if(e.getSource()==b2){

int c=a-b;

t3.setText(" "+c);

}

Group […]

Tag: 5th sem solution

Java 2 old Papers Solution 2017 || BIM STUDY NOTES