mm

slip no 1

1.

public class s1_1 extends Thread

{

char c;

public void run()

{

for(c = 'A'; c<='Z';c++)

{

System.out.println(""+c);

try

{

Thread.sleep(3000);

}

catch(Exception e)

{

e.printStackTrace();

}

public static void main(String args[])

{

s1_1 t = new s1_1();

t.start();

}

2.

import javax.swing.*;

import java.awt.*;

import java.awt.event.*;

import java.sql.*;

public class s1_2 extends Frame implements ActionListener {

Label l1, l2, l3;

TextField t1, t2, t3;

Button b;

Connection cn;

Statement st;

ResultSet rs;

public s1_2() {

setLayout(null);

l1 = new Label("Eno");

l2 = new Label("EName");

l3 = new Label("Salary");

t1 = new TextField();

t2 = new TextField();

t3 = new TextField();

b = new Button("Save");

l1.setBounds(50, 50, 100, 30);

t1.setBounds(160, 50, 100, 30);

l2.setBounds(50, 90, 100, 30);

t2.setBounds(160, 90, 100, 30);

l3.setBounds(50, 130, 100, 30);

t3.setBounds(160, 130, 100, 30);

b.setBounds(50, 170, 100, 30);

add(l1);

add(t1);

add(l2);

add(t2);

add(l3);

add(t3);

add(b);

b.addActionListener(this);

setSize(500, 500);

setVisible(true);

addWindowListener(new WindowAdapter() {

public void windowClosing(WindowEvent e) {

System.exit(0);

}

});

}

public void actionPerformed(ActionEvent oe) {

String str = oe.getActionCommand();

if (str.equals("Save")) {

try {

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

cn = DriverManager.getConnection("jdbc:odbc:Ass", "", "");

st = cn.createStatement();

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

String enn = t2.getText();

int sal = Integer.parseInt(t3.getText());

String strr = "insert into emp values(" + en + ",'" + enn + "'," + sal + ")";

int k = st.executeUpdate(strr);

if (k > 0) {

JOptionPane.showMessageDialog(null, "Record Is Added");

}

} catch (Exception er) {

System.out.println("Error: " + er);

}

public static void main(String args[]) {

new s1_2();

}

slip no 2

1.

import java.io.*;

import java.util.*;

public class S2_1 {

public static void main(String args[]) throws IOException {

HashSet<String> set = new HashSet<String>();

BufferedReader br = new BufferedReader(new InputStreamReader(System.in));

System.out.println("Enter how many no");

int n = Integer.parseInt(br.readLine());

System.out.println("Enter Friend's Names:");

for (int i = 0; i < n; i++) {

set.add(br.readLine());

}

System.out.println("Original HashSet: " + set);

List<String> list = new ArrayList<String>(set);

Collections.sort(list);

System.out.println(" elements " + "in sorted order " + "using List: " + list);

}

2.a

import java.io.*;

import javax.servlet.*;

import javax.servlet.http.*;

public class NewServlet extends HttpServlet

{

public void doGet(HttpServletRequest req,HttpServletResponse resp)throws IOException,ServletException

{

resp.setContentType("text/html");

String userinfo=req.getHeader("User-Agent");

PrintWriter p=resp.getWriter();

}

b.

<html>

<body>

Username:<input type="text" name="t1">

</form>

</body>

</html>

slip no 3

1.

<html>

<body>

Enter the patient no :<input type=text namme="p1"><br>

Enter the patient name :<input type=text namme="p2"><br>

Enter the patient address :<input type=text namme="p3"><br>

Enter the patient age:<input type=text namme="p4"><br>

Enter the patient Disease:<input type=text namme="p5"><br>

</form>

</body>

</html>

//jsp

<%@page language="java" %>

<html>

<body>

int no=Integer.parseInt(request.getParameter("p1"));

int name=Integer.parseInt(request.getParameter("p2"));

int address=Integer.parseInt(request.getParameter("p3"));

int age=Integer.parseInt(request.getParameter("p4"));

int disease=Integer.parseInt(request.getParameter("p5"));

out.println(no+"\t"+name+"\t"+address+"\t"+age+"\t"+disease);

</body>

</html>

2.

import java.util.*;

import java.io.*;

public class Slip3_2

{

public static void main(String args[])throws IOException

{

BufferedReader br=new BufferedReader(new InputStreamReader(System.in));

String name;

int n;

LinkedList a=new LinkedList();

{

System.out.println("1) Add element at the end of the list");

System.out.println("2) Delete first element of the list");

System.out.println("3) contents of list in reverse order");

System.out.println("4) display");

System.out.println("5) Exit");

System.out.println("Enter your choice");

n=Integer.parseInt(br.readLine());

switch(n)

{

case 1:System.out.println("Enter the name to enter in LinkedList");

name=br.readLine();

a.add(name);

break;

case 2:a.removeFirst();

break;

case 3:System.out.println("Reverse the LinkedList");

Collections.reverse(a);

break;

case 4:System.out.println(" Display linkedList");

System.out.println(a);

break;

case 5:return ;

}

}while(n!=5);

}

slip no 4

1.

import java.awt.*;

import java.awt.event.*;

class Slip4_1 extends Frame implements Runnable

{

Thread t;

Label l1;

int f;

Slip4_1()

{

t=new Thread(this);

t.start();

setLayout(null);

l1=new Label("Hello JAVA");

l1.setBounds(100,100,100,40);

add(l1);

setSize(300,300);

setVisible(true);

f=0;

}

public void run()

{

try

{

if(f==0)

{

t.sleep(200);

l1.setText("");

f=1;

}

if(f==1)

{

t.sleep(200);

l1.setText("Hello Java");

f=0;

}

catch(Exception e)

{

System.out.println(e);

}

run();

}

public static void main(String a[])

{

new Slip4_1();

}

2.

import java.io.*;

import java.util.*;

public class Slip4_2 {

public static void main(String args[]) throws IOException {

BufferedReader br = new BufferedReader(new InputStreamReader(System.in));

String cname;

int n, code;

Hashtable a = new Hashtable();

do {

System.out.println("1) Add new City and its code");

System.out.println("2) Remove a city name");

System.out.println("3) Search and display a city");

System.out.println("4) Display");

System.out.println("5) Exit");

System.out.println("Enter your choice");

n = Integer.parseInt(br.readLine());

switch (n) {

case 1:

System.out.println("Enter the new City and its code");

cname = br.readLine();

code = Integer.parseInt(br.readLine());

a.put(cname, code);

break;

case 2:

System.out.println("Enter the city to be deleted");

cname = br.readLine();

a.remove(cname);

break;

case 3:

System.out.println("Enter the City to be Searched and displayed");

cname = br.readLine();

System.out.println(a.get(cname));

break;

case 4:

System.out.println(a);

break;

case 5:

return;

}

} while (n != 5);

}

slip no 5

1 import java.io.;

import java.util.;

class GFG {
public static void main(String[] args)

{

Hashtable<String, String> ht = new Hashtable<String, String>();

ht.put("Name", "Rohan");

ht.put("Mpbile_Nos", "8446049402");

Enumeration<String> e = ht.keys();

while (e.hasMoreElements()) {
String key = e.nextElement();

corresponding to

System.out.println(key + ":" + ht.get(key));

}

}

}

2.

<%@page import="java.sql.*,java.util.*"%>

Class.forName("org.postgresql.Driver");

Connection con = DriverManager.getConnection(

"jdbc:postgresql:ty1","postgres","");

Set s = new TreeSet();

while(true){

int n = (int)(Math.random()*11+1);

s.add(n);

if(s.size()==5) break;

}

PreparedStatement ps = con.prepareStatement("select * from questions where qid=?");

int i=0;

Vector v = new Vector(s);

session.setAttribute("qids",v);

int qid = Integer.parseInt(v.get(i).toString());

ps.setInt(1,qid);

ResultSet rs = ps.executeQuery();

rs.next();

<tr>

<td><b>Question:<%=i+1%></b></td>

</tr>

<tr>

</tr>

<tr>

<td>

<b>

</b>

</td>

</tr>

<tr>

</td>

</tr>

</table>

</form>

</body>

Acceptans.jsp

<%@page import="java.sql.*,java.util.*"%>

Class.forName("org.postgresql.Driver");

Connection con = DriverManager.getConnection(

"jdbc:postgresql:ty1","postgres","");

Vector answers = (Vector)session.getAttribute("answers");

if(answers==null)

answers = new Vector();

int qno = Integer.parseInt(request.getParameter("qno"));

int ans = Integer.parseInt(request.getParameter("op"));

int i = Integer.parseInt(request.getParameter("qid"));

answers.add(qno+" "+ans);

session.setAttribute("answers",answers);

String ok = request.getParameter("ok");

if(ok.equals("Submit") || i==5){

response.sendRedirect("result.jsp");

return;

}

PreparedStatement ps = con.prepareStatement("select * from questions where qid=?");

Vector v = (Vector)session.getAttribute("qids");

int qid = Integer.parseInt(v.get(i).toString());

ps.setInt(1,qid);

ResultSet rs = ps.executeQuery();

rs.next();

<tr>

<td><b>Question:<%=i+1%></b></td>

</tr>

<tr>

</tr>

<tr>

<td>

<b>

</b>

</td>

</tr>

<tr>

</td>

</tr>

</table>

</form>

</body>

Result.jsp

<%@page import="java.sql.*,java.util.*,java.text.*"%>

Class.forName("org.postgresql.Driver");

Connection con = DriverManager.getConnection(

"jdbc:postgresql:ty1","postgres","");

Vector v = (Vector)session.getAttribute("answers");

if(v==null){

<h1>No questions answered</h1>

return;

}

PreparedStatement ps = con.prepareStatement("select ans from questions where qid=?");

int tot=0;

for(int i=0;i<v.size();i++){

String str = v.get(i).toString();

int j = str.indexOf(' ');

int qno = Integer.parseInt(str.substring(0,j));

int gans = Integer.parseInt(str.substring(j+1));

ps.setInt(1,qno);

ResultSet rs = ps.executeQuery();

rs.next();

int cans = rs.getInt(1);

if(gans==cans) tot++;

}

session.removeAttribute("qids");

session.removeAttribute("answers");

session.removeAttribute("qid");

<h3>Score:<%=tot%></h1>

<center><a href='exam.jsp'>Restart</a></center>

</body>

SQL File

create table questions(qid serial primary key, question text, option1 text, option2 text, option3 text, option4 text, ans int);

insert into questions

(question,option1,option2,option3,option4,ans)

values

('Who is prime minister of India?','Rahul Gandhi','Narendra Modi','Sonia Gandhi','Manmohan Singh',2),

('Who is finance minister of India','Rahul Gandhi','P Chidambaram','Manmohan Singh','Arun Jately',4),

('What is square root of 16?','2','4','1','256',4),

('Who is chief minister of Maharashtra','Uddhav Tharakey','Devendra Fadanavis','Raj Thakarey','Sharad Pawar',2),

('What is full for of LIFO?','Last In First Out','Late In First Out','Long In First Out','Large In First Out',1),

('Which is capital of India','Delhi','Maharashtra','Kolkata','Goa',1), ('What is currency of India','Dollar','Rupee','Pound','Yen',2),

('Who Invented C?','Kim Thompson','Bill Joy','Dennis Ritche','Balaguru Swamy',3),

('Where was Java invented?','Microsoft','Oracle','Sun Microsystem','Intel',3),

('What is cube root of 8?','2','3','4','5',1),('What is full form of FIFO','Fast In Fast Out','First in First Out','Fast In First Out','First In Fast Out',2);

slip no 6

import java.io.*;

import java.util.*;

class Slip6_1

{

public static void main(String args[])throws IOException

{

BufferedReader br=new BufferedReader(new InputStreamReader(System.in));

TreeSet ts=new TreeSet();

int i,n,no,choice;

System.out.println("Enter How many numbers :");

n=Integer.parseInt(br.readLine());

System.out.println("Enter the numbers :");

for(i=0;i<n;i++)

{

no=Integer.parseInt(br.readLine());

ts.add(no);

}

{

System.out.println("1)Search fo number:");

System.out.println("2)dispaly all");

System.out.println("3)exit");

System.out.println("Enter you choice:");

choice=Integer.parseInt(br.readLine());

switch(choice)

{

case 1:System.out.println("Enter th no to be searched ");

n=Integer.parseInt(br.readLine());

if(ts.contains(n))

{

System.out.println("Elemnt present:\t"+n);

}

else

System.out.println("Not Present \t"+n);

break;

case 2:System.out.println(ts);

break;

case 3:return;

}

}while(choice!=3);

}

import java.awt.*;

import java.applet.*;

public class Slip6_2 extends Applet implements Runnable

{

int r,g1,y,i;

Thread t;

public void init()

{

r=0;g1=0;y=0;

t=new Thread(this);

t.start();

}

public void run()

{

try { for (i=24;i>=1;i--)

{

t.sleep(100);

if (i>=16 && i<24)

{

g1=1;

repaint();

}

if (i>=8 && i<16)

{

y=1;

repaint();

}

if (i>=1 && i<8)

{

r=1;

repaint();

}

if (i==0)

{

run();

}

catch(Exception e)

{

}

public void paint(Graphics g) {

g.drawOval(100,100,100,100);

g.drawOval(100,225,100,100);

g.drawOval(100,350,100,100);

g.drawString("start",200,200);

if (r==1)

{ g.setColor(Color.red);

g.fillOval(100,100,100,100);

g.drawOval(100,100,100,100);

g.drawString("stop",200,200);

r=0;

}

if (g1==1)

{ g.setColor(Color.green);

g.fillOval(100,225,100,100);

g1=0;

g.drawOval(100,225,100,100);

g.drawString("go",200,200);

}

if (y==1)

{ g.setColor(Color.yellow);

g.fillOval(100,350,100,100);

y=0;

g.drawOval(100,350,100,100);

g.drawString("slow",200,200);

}

slip no 7

1.

import java.util.Random;

class Square extends Thread

{

int x;

Square(int n)

{

x = n;

}

public void run()

{

int sqr = x * x;

System.out.println("Square of " + x + " = " + sqr );

}

class Cube extends Thread

{

int x;

Cube(int n)

{

x = n;

}

public void run()

{

int cub = x * x * x;

System.out.println("Cube of " + x + " = " + cub );

}

class Number extends Thread

{

public void run()

{

Random random = new Random();

for(int i =0; i<10; i++)

{

int randomInteger = random.nextInt(100);

System.out.println("Random Integer generated : " + randomInteger);

Square s = new Square(randomInteger);

s.start();

Cube c = new Cube(randomInteger);

c.start();

try {

Thread.sleep(1000);

} catch (InterruptedException ex) {

System.out.println(ex);

}

public class Slip7_1{

public static void main(String args[])

{

Number n = new Number();

n.start();

}

2.

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.SQLException;

import java.sql.Statement;

public class JDBCExample {

static final String DB_URL = "jdbc:mysql://localhost/";

static final String USER = "guest";

static final String PASS = "guest123";

public static void main(String[] args) {

// Open a connection

try(Connection conn = DriverManager.getConnection(DB_URL, USER, PASS);

Statement stmt = conn.createStatement();) {

String sql = "CREATE DATABASE STUDENTS";

stmt.executeUpdate(sql);

System.out.println("Database created successfully...");

} catch (SQLException e) {

e.printStackTrace();

}

public class insert1 {

public static void main(String args[]) {

String id = "id1";

String pwd = "pwd1";

String fullname = "JAVA";

String email = "Java.com";

try {

Class.forName("oracle.jdbc.driver.OracleDriver");

Connection con = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl", "login1", "pwd1");

Statement stmt = con.createStatement();

String q1 = "insert into userid values('" +id+ "', '" +pwd+ "', '" +fullname+ "', '" +email+ "')";

int x = stmt.executeUpdate(q1);

if (x > 0)

System.out.println("Successfully Inserted");

else

System.out.println("Insert Failed");

con.close();

}

catch(Exception e) {

System.out.println(e);

}

slip no 8

public class s8_1 extends Thread

{

String str;

int n;

s8_1(String str, int n)

{

this.str = str;

this.n = n;

}

public void run()

{

try

{

for (int i = 0; i < n; i++)

{

System.out.println(getName() + " : " + str);

}

} catch (Exception e)

{

e.printStackTrace();

}

public static void main(String[] args)

{

s8_1 t1 = new s8_1("COVID19", 10);

s8_1 t2 = new s8_1("LOCKDOWN2020", 20);

s8_1 t3 = new s8_1("VACCINATED", 30);

t1.start();

t2.start();

t3.start();

}

2.

<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>

<!DOCTYPE html>

<html>

<head>

</head>

<body>

<h1>The required Result is:</h1>

<h2>

int n = 0;

int flag = 0;

String ns = request.getParameter("n");

if (ns != null && !ns.isEmpty()) {

n = Integer.parseInt(ns);

if (n > 1) {

for (int i = 2; i <= n / 2; i++) {

if (n % i == 0) {

flag = 1;

break;

}

if (flag == 0) {

out.println("<pre>");

out.println(n + " is a prime no.");

out.println("</pre>");

} else {

out.println("<pre>");

out.println(n + " is not a prime no.");

out.println("</pre>");

}

</h2>

</center>

</body>

</html>

slip no 9

import java.awt.*;import java.awt.geom.*;import javax.swing.*;import java.awt.event.*;import java.util.*;

public class BouncingBallApp extends JFrame

{

public static void main(String[] args)

{

Container container = new Container();

BouncingBallApp bBalls = new BouncingBallApp();

bBalls.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);

BouncingBallPanel BBP = new BouncingBallPanel();

container.add(BBP);

bBalls.addMouseListener(BBP);

bBalls.setBackground(Color.WHITE);

bBalls.setSize(400, 300);

BBP.setSize(400, 300);

BBP.setLayout(null);

bBalls.setContentPane(BBP);

bBalls.setVisible(true);

}

class BouncingBallPanel extends JPanel implements MouseListener

{

public Ball[] array;

private int count = 0;

Random generator = new Random();

public BouncingBallPanel()

{

array = new Ball[20];

}

public void mouseClicked(MouseEvent event)

{

array[count] = new Ball(this);

count++;

if( count == 1)

{

final Runnable update = new Runnable()

{

public void run()

{

for (int j = 0; j < array.length; j++)

{

if(array[j] != null)

{

array[j].move();

}

};

(new Thread(new Ball(this))).start();

Runnable graphic = new Runnable()

{

public void run()

{

while(true)

{

try

{

EventQueue.invokeLater(update);

Thread.sleep(generator.nextInt(10 +100));

}catch (InterruptedException exp){}

}

};

new Thread(graphic).start();

}

public void mouseExited(MouseEvent event){}

public void mouseReleased(MouseEvent event){}

public void mouseEntered(MouseEvent event){}

public void mousePressed(MouseEvent event){}

public void paintComponent(Graphics g)

{

super.paintComponent(g);

Graphics2D g2d = (Graphics2D) g;

for(int i = 0; i < array.length; i++)

{

if(array[i] != null)

{

g2d.setColor(array[i].getColor());

g2d.fillOval((int)array[i].getX(), (int)array[i].getY(), (int)array[i].getDiameter(), (int)array[i].getDiameter());

}

class Ball implements Runnable

{

private double x;

private double y;

private int deltaX;

private int deltaY;

private double diameter;

private Color color;

BouncingBallPanel BBP2;

Random random = new Random();

public Ball(BouncingBallPanel a)

{

x = random.nextInt(400);

y = random.nextInt(300);

deltaX = 1 + random.nextInt(10);

deltaY = 1 + random.nextInt(10);

diameter = 5 + random.nextInt(20);

color = new Color(random.nextInt(256), random.nextInt(256), random.nextInt(256));

BBP2 = a;

}

public double getX()

{

return x;

}

public double getY() {

return y;

}

public double getDiameter() {

return diameter;

}

public Color getColor() {

return color;

}

public void move() {

x += deltaX;

y += deltaY;

if (x > 400 - getDiameter()|| x <0)

{

deltaX = -deltaX;

}

if (y > 300 - getDiameter() || y < 0)

{

deltaY = -deltaY;

}

@Override

public void run()

{

while(true)

{

move();

BBP2.repaint();

try{

Thread.currentThread().sleep(10 + random.nextInt(100));

}catch(InterruptedException exp){}

}

2.

Step 1:

Step 2:

<groupId>org.springframework</groupId>

<artifactId>spring-webmvc</artifactId>

</dependency>

</dependencies>

Step 3:

import org.springframework.stereotype.Controller;

import org.springframework.web.bind.annotation.RequestMapping;

import org.springframework.web.bind.annotation.ResponseBody;

@Controller

public class MainController {

Step 6:

private String message = "If you can't explain it simply, you don't understand it well enough.";

Step 5:

@RequestMapping("/message")

Step 7:

@ResponseBody

public String showMessage() {

return message;

}

slip no 10

import java.text.*;

import java.util.*;

public class s10_1

{

public static void main(String args[])

{

SimpleDateFormat formatDate = new SimpleDateFormat( "dd/MM/yyyy HH:mm:ss z");

Date date = new Date();

formatDate.setTimeZone(TimeZone.getTimeZone("IST"));

System.out.println(formatDate.format(date));

}

2.

import javax.swing.table.*;

import java.sql.*;

import java.awt.event.*;

import java.awt.*;

import javax.swing.*;

public class s10_2 extends JFrame implements ActionListener

{

JTextField t1,t2,t3;

JLabel l1,l2,l3;

JButton b1,b2;

int row,column;

StudDb()

{

setLayout(new FlowLayout());

setSize(500,500);

setVisible(true);

setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);

l1=new JLabel("RollNo");

add(l1);

t1=new JTextField(10);

add(t1);

l2=new JLabel("Name");

add(l2);

t2=new JTextField(10);

add(t2);

l3=new JLabel("Percentage");

add(l3);

t3=new JTextField(10);

add(t3);

b1=new JButton("Insert");

add(b1);

b1.addActionListener(this);

b2=new JButton("Display");

add(b2);

b2.addActionListener(this);

try

{

Class.forName("org.postgresql.Driver");

}

catch(Exception e)

{

System.out.println("Error"+e.getMessage());

}

public void actionPerformed(ActionEvent e2)

{

if(e2.getSource()==b1)

{

try

{

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

String ename=t2.getText();

float percentage=Float.parseFloat(t3.getText());

Connection conn =

DriverManager.getConnection("jdbc:postgresql://localhost/stud","postgres","password");

PreparedStatement st=conn.prepareStatement("insert into

student values(?,?,?)");

st.setInt(1, eno);

st.setString(2,ename);

st.setFloat(3,percentage);

st.executeUpdate();

st.close();

JOptionPane.showMessageDialog(this,"Inserted");

}catch(Exception e)

{

System.out.println("Error"+e.getMessage());

}

if(e2.getSource()==b2)

{

try

{

Object[] data=new Object[3];

DefaultTableModel dtm=new DefaultTableModel();

JTable jt=new JTable(dtm);

ResultSet rs;

System.out.println("hello");

jt.setBounds(20,20,50,50);

String[] darr={"RollNo","Name","Percentage"};

for(int column=0;column<3;column++)

{

dtm.addColumn(darr[column]);

}

Connection conn = DriverManager.getConnection("jdbc:postgresql://localhost/stud","postgres","password");

Statement st=conn.createStatement();

rs=st.executeQuery("select * from student");

for(row=0;rs.next();row++)

{

for(int column=0;column<3;column++)

{

data[column]=rs.getObject(column+1);

}

dtm.addRow(data);

}

rs.close();

getContentPane().add(new JScrollPane(jt));

}catch(Exception e)

{

}

public static void main(String[] args)

{

new StudDb();

}

slip no 11

1.

import java.io.*;

import javax.servlet.*;

import javax.servlet.http.*;

import java.sql.*;

public class servletDatabase extends HttpServlet {

Connection cn;

public void init() {

try {

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

cn = DriverManager.getConnection("jdbc:mysql://localhost/stud", "root", "password");

System.out.println("Connected to database");

} catch(Exception ce) {

System.out.println("Error: " + ce.getMessage());

}

public void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {

resp.setContentType("text/html");

PrintWriter pw = resp.getWriter();

try {

int rno = Integer.parseInt(req.getParameter("t1"));

String qry = "SELECT * FROM student WHERE rollno=" + rno;

Statement st = cn.createStatement();

ResultSet rs = st.executeQuery(qry);

pw.print("<table border=1>");

while (rs.next()) {

pw.print("<tr>");

pw.print("<td>" + rs.getInt(1) + "</td>");

pw.print("<td>" + rs.getString(2) + "</td>");

pw.print("<td>" + rs.getFloat(3) + "</td>");

pw.print("</tr>");

}

pw.print("</table>");

} catch(Exception se) {

System.out.println("Error: " + se.getMessage());

}

pw.close();

}

2.

import java.sql.*;

public class ResultSetMetaData {

public static void main(String[] args) {

try {

Statement stmt;

Class.forName("org.postgresql.Driver");

Connection conn = DriverManager.getConnection("jdbc:postgresql://localhost/stud", "postgres", "password");

stmt = conn.createStatement();

ResultSet rs = stmt.executeQuery("SELECT * FROM student");

ResultSetMetaData rsmd = rs.getMetaData();

int noOfColumns = rsmd.getColumnCount();

System.out.println("Number of columns = " + noOfColumns);

for (int i = 1; i <= noOfColumns; i++) {

System.out.println("Column No : " + i);

System.out.println("Column Name : " + rsmd.getColumnName(i));

System.out.println("Column Type : " + rsmd.getColumnTypeName(i));

System.out.println("Column display size : " + rsmd.getColumnDisplaySize(i));

}

conn.close();

} catch (ClassNotFoundException e) {

System.out.println("Error: PostgreSQL JDBC Driver not found");

e.printStackTrace();

} catch (SQLException e) {

System.out.println("SQL Exception: " + e.getMessage());

e.printStackTrace();

}

slip no 12

import java.io.*;

import javax.servlet.*;

import javax.servlet.http.*;

import java.sql.*;

public class servletDatabase extends HttpServlet

{

Connection cn;

public void init()

{

try

{

Class.forName("org.gjt.mm.mysql.Driver");

cn=DriverManager.getConnection("jdbc:mysql://localhost/stud","root","password");

System.out.println("Hii");

}

catch(Exception ce)

{

System.out.println("Error"+ce.getMessage());

}

public void doGet(HttpServletRequest req, HttpServletResponse resp)

throws ServletException, IOException

{

resp.setContentType("text/html");

PrintWriter pw=resp.getWriter();

try

{

int rno=Integer.parseInt(req.getParameter("t1"));

String qry="Select * from student where rollno="+rno;

Statement st=cn.createStatement();

ResultSet rs=st.executeQuery(qry);

while(rs.next())

{

pw.print("<table border=1>");

pw.print("<tr>");

pw.print("<td>" + rs.getInt(1) + "</td>");

pw.print("<td>" + rs.getString(2) + "</td>");

pw.print("<td>" + rs.getFloat(3) + "</td>");

pw.print("</tr>");

pw.print("</table>");

}

catch(Exception se){}

pw.close();

}

HTML File

<html>

<body>

Enter Roll No:<input type="text" name="t1">

</form>

</body>

</html>

pssql> create database stud;

Query OK, 1 row affected (0.00 sec)

pssql> create table student(rollno int primary key,name text,percentage float);

Query OK, 0 rows affected (0.07 sec)

pssql> insert into student values(1,'student1',79);

Query OK, 1 row affected (0.04 sec)

pssql> insert into student values(2,'student2',69);

Query OK, 1 row affected (0.05 sec)

pssql> insert into student values(3,'student3',58);

Query OK, 1 row affected (0.06 sec)

pssql> select * from student;

2.

import java.sql.*;
import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import java.util.*;
class s12_2 extends JFrame implements ActionListener {
JLabel l1, l2, l3;
JTextField t1, t2, t3;
JButton b1, b2, b3;
String sql;
JPanel p, p1;
Connection con;
PreparedStatement ps;
JTable t;
JScrollPane js;
Statement stmt;
ResultSet rs;
ResultSetMetaData rsmd;
int columns;
Vector<String> columnNames = new Vector<String>();
Vector<Vector<Object>> data = new Vector<Vector<Object>>();
s12_2() {
l1 = new JLabel("Enter no:");
l2 = new JLabel("Enter name:");
l3 = new JLabel("Percentage:");
t1 = new JTextField(20);
t2 = new JTextField(20);
t3 = new JTextField(20);
b1 = new JButton("Save");
b2 = new JButton("Display");
b3 = new JButton("Clear");
b1.addActionListener(this);
b2.addActionListener(this);
b3.addActionListener(this);
p = new JPanel();
p1 = new JPanel();
p.add(l1);
p.add(t1);
p.add(l2);
p.add(t2);
p.add(l3);
p.add(t3);
p.add(b1);
p.add(b2);
p.add(b3);
add(p);
setLayout(new GridLayout(2, 1));
setSize(600, 800);
setVisible(true);
setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
}
public void actionPerformed(ActionEvent e) {
if ((JButton) b1 == e.getSource()) {
int no = Integer.parseInt(t1.getText());
String name = t2.getText();
int p = Integer.parseInt(t3.getText());
System.out.println("Accept Values");
try {
Class.forName("org.postgresql.Driver");
con = DriverManager.getConnection("jdbc:postgresql://192.168.100.254/Bill", "oracle", "oracle");
sql = "insert into stud values(?,?,?)";
ps = con.prepareStatement(sql);
ps.setInt(1, no);
ps.setString(2, name);
ps.setInt(3, p);
System.out.println("Values set");
int n = ps.executeUpdate();
if (n != 0) {
JOptionPane.showMessageDialog(null, "Record inserted...");
} else {
JOptionPane.showMessageDialog(null, "Record NOT inserted");
}
} catch (Exception ex) {
System.out.println(ex);
}
} else if ((JButton) b2 == e.getSource()) {
try {
Class.forName("org.postgresql.Driver");
con = DriverManager.getConnection("jdbc:postgresql://192.168.100.254/Bill", "oracle", "oracle");
System.out.println("Connected");
stmt = con.createStatement();
rs = stmt.executeQuery("select * from stud");
rsmd = rs.getMetaData();
columns = rsmd.getColumnCount();

for (int i = 1; i <= columns; i++) {
columnNames.addElement(rsmd.getColumnName(i));
}

while (rs.next()) {
Vector<Object> row = new Vector<Object>(columns);
for (int i = 1; i <= columns; i++) {
row.addElement(rs.getObject(i));
}
data.addElement(row);
}
t = new JTable(data, columnNames);
js = new JScrollPane(t);
p1.add(js);
add(p1);
setSize(600, 600);
setVisible(true);
} catch (Exception e1) {
System.out.println(e1);
}
} else {
t1.setText("");
t2.setText("");
t3.setText("");
}
}
public static void main(String a[]) {
s12_2 ob = new s12_2();
}
}

slip no 13

import java.sql.*;

import java.io.*;

public class DBMetaData

{

public static void main(String[] args) throws Exception

{

ResultSet rs = null;

Class.forName("org.postgresql.Driver");

Connection conn = DriverManager.getConnection("jdbc:postgresql://localhost/dbtry","postgres","redhat");

DatabaseMetaData dbmd = conn.getMetaData();

System.out.println("Database Product name = " + dbmd.getDatabaseProductName());

System.out.println("User name = " + dbmd.getUserName());

System.out.println("Database driver name= " + dbmd.getDriverName());

System.out.println("Database driver version = "+ dbmd.getDriverVersion());

System.out.println("Database product name = " + dbmd.getDatabaseProductName());

System.out.println("Database Version = " + dbmd.getDriverMajorVersion());

rs = dbmd.getTables(null,null,null, new String[]{"TABLE"});

System.out.println("List of tables...");

while(rs.next())

{

String tblName = rs.getString("TABLE_NAME");

System.out.println("Table : "+ tblName);

}

conn.close();

}

2.

Class MyThread extends Thread

{ public MyThread(String s)

{

super(s);

}

public void run()

{

System.out.println(getName()+"thread created.");

while(true)

{

System.out.println(this);

int s=(int)(math.random()*5000);

System.out.println(getName()+"is sleeping for :+s+"msec");

try{

Thread.sleep(s);

}

catch(Exception e)

{

}

Class ThreadLifeCycle

{

public static void main(String args[])

{

MyThread t1=new MyThread("shradha"),t2=new MyThread("pooja");

t1.start();

t2.start();

try

{

t1.join();

t2.join();

}

catch(Exception e)

{

}

System.out.println(t1.getName()+"thread dead.");

System.out.println(t2.getName()+"thread dead.");

}

slip no 14

import java.io.*;

public class SearchThread extends Thread {

File f1;

String fname;

static String str;

String line;

LineNumberReader reader = null;

SearchThread(String fname) {

this.fname = fname;

f1 = new File(fname);

}

public void run() {

try {

FileReader fr = new FileReader(f1);

reader = new LineNumberReader(fr);

while ((line = reader.readLine()) != null) {

if (line.contains(str)) {

System.out.println("String found in " + fname + " at line " + reader.getLineNumber());

return; // Stop the thread when string is found

}

reader.close(); // Close the reader after finishing reading the file

} catch (Exception e) {

e.printStackTrace();

}

public static void main(String[] args) throws IOException {

Thread t[] = new Thread[20];

BufferedReader br = new BufferedReader(new InputStreamReader(System.in));

System.out.println("Enter String to search");

str = br.readLine();

FilenameFilter filter = (dir, name) -> name.endsWith(".txt");

File dir1 = new File(".");

File[] files = dir1.listFiles(filter);

if (files == null || files.length == 0) {

System.out.println("No files available with .txt extension");

} else {

for (int i = 0; i < files.length; i++) {

t[i] = new SearchThread(files[i].getName());

t[i].start();

}

2.

<!DOCTYPE html>

<html>

<body>

Enter Any Number : <input type="text" name="num"><br><br>

</form>

</body>

</html>

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

<!DOCTYPE html>

<html>

<body>

int n = Integer.parseInt(request.getParameter("num"));

int rem, r;

if (n < 10) {

out.println("Sum of first and last digit is ");

} else {

rem = n % 10;

do {

r = n % 10;

n = n / 10;

} while (n > 0);

n = rem + r;

out.println("Sum of first and last digit is ");

}

</body>

</html>

slip no 15

public class MainThread

{

public static void main(String arg[])

{

Thread t=Thread.currentThread();

System.out.println("Current Thread:"+t);//Change Name

t.setName("My Thread ");

System.out.println ("After the name is Changed:"+t);

try {

for(int i=2;i>0;i--)

{

System.out.println(i);

Thread.sleep(1000);

}

catch(Exception e)

{

System.out.println(e);

}

import java.io.*;

import javax.servlet.*;

import javax.servlet.http.*;public class VisitServlet extends

HttpServlet

{

static int i=1;

public void doGet(HttpServletRequest request,HttpServletResponse

response)

throws IOException,ServletException

{

response.setContentType("text/html");

PrintWriter out=response.getWriter();

String k=String.valueOf(i);

Cookie c=new Cookie("visit",k);

response.addCookie(c);

int j=Integer.parseInt(c.getValue());

if(j==1)

{

out.println("Welcome to web page ");

}

else {

out.println("You are visited at "+i+" times");

}

i++;

}

}Web.xml

<?xml version="1.0" encoding="ISO-8859-1"?>

<web-app>

<servlet-name>VisitServlet</servlet-name>

<servlet-class>VisitServlet</servlet-class>

</servlet>

36<servlet-mapping>

<servlet-name>VisitServlet</servlet-name>

<url-pattern>/VS</url-pattern>

</servlet-mapping>

</web-app>

slip no 16

import java.util.*; import java.io.*; class S16_1 { public static void main(String args[])throws IOException { BufferedReader br=new BufferedReader(new InputStreamReader(System.in)); TreeSet ts=new TreeSet(); int i,n,num; System.out.println("How many Integers :"); n=Integer.parseInt(br.readLine()); System.out.println("Enter the number :"); for(i=0;i<n;i++) { num=Integer.parseInt(br.readLine()); ts.add(num); } System.out.println("The Integers are ->"+ts); } }

2.

import java.sql.*; public class JDBC { public static void main(String[] args) { try { Connection conn = DriverManager.getConnection("jdbc:postgresql://localhost:5434/postgres", "postgres", "saqlain"); PreparedStatement insertStmt = conn.prepareStatement("INSERT INTO Teacher (Tno, Tname, Subject) VALUES (?, ?, ?)"); insertStmt.setInt(1, 1); insertStmt.setString(2, "John Doe"); insertStmt.setString(3, "JAVA"); insertStmt.executeUpdate(); insertStmt.setInt(1, 2); insertStmt.setString(2, "Jane Smith"); insertStmt.setString(3, "Python"); insertStmt.executeUpdate(); insertStmt.setInt(1, 3); insertStmt.setString(2, "Mike Johnson"); insertStmt.setString(3, "C++"); insertStmt.executeUpdate(); insertStmt.setInt(1, 4); insertStmt.setString(2, "Sarah Lee"); insertStmt.setString(3, "JAVA"); insertStmt.executeUpdate(); insertStmt.setInt(1, 5); insertStmt.setString(2, "David Chen"); insertStmt.setString(3, "PHP"); insertStmt.executeUpdate(); PreparedStatement selectStmt = conn.prepareStatement("SELECT * FROM Teacher WHERE Subject = ?"); selectStmt.setString(1, "JAVA"); ResultSet rs = selectStmt.executeQuery(); while (rs.next()) { int tno = rs.getInt("Tno"); String tname = rs.getString("Tname"); String subject = rs.getString("Subject"); System.out.println("Teacher number: " + tno + ", Teacher name: " + tname + ", Subject: " + subject); } rs.close(); selectStmt.close(); insertStmt.close(); conn.close(); } catch (SQLException e) { e.printStackTrace(); } } }

slip no 17

1.

import java.io.*; import java.util.*; class s17_1 { public static void main(String args[])throws IOException { BufferedReader br=new BufferedReader(new InputStreamReader(System.in)); TreeSet ts=new TreeSet(); int i,n,no,choice; System.out.println("Enter How many numbers :"); n=Integer.parseInt(br.readLine()); System.out.println("Enter the numbers :"); for(i=0;i<n;i++) { no=Integer.parseInt(br.readLine()); ts.add(no); } do { System.out.println("1)Search fo number:"); System.out.println("2)dispaly all"); System.out.println("3)exit"); System.out.println("Enter you choice:"); choice=Integer.parseInt(br.readLine()); switch(choice) { case 1:System.out.println("Enter th no to be searched "); n=Integer.parseInt(br.readLine()); if(ts.contains(n)) { System.out.println("Elemnt present:\t"+n); } else System.out.println("Not Present \t"+n); break; case 2:System.out.println(ts); break; case 3:return; } }while(choice!=3); } }

2.

import java.awt.BorderLayout; import java.awt.event.ActionEvent; import java.awt.event.ActionListener; import javax.swing.JButton; import javax.swing.JFrame; import javax.swing.JPanel; import javax.swing.JTextField; public class s17_2 implements Runnable { private JTextField textField; public s17_2(JTextField textField) { this.textField = textField; } public void run() { for (int i = 1; i <= 100; i++) { textField.setText(Integer.toString(i)); try { Thread.sleep(100); } catch (InterruptedException e) { e.printStackTrace(); } } } public static void main(String[] args) { JFrame frame = new JFrame("Number Display"); frame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE); JTextField textField = new JTextField(10); JButton button = new JButton("Start"); JPanel panel = new JPanel(); panel.add(textField); panel.add(button); frame.add(panel, BorderLayout.CENTER); frame.pack(); frame.setVisible(true); button.addActionListener(new ActionListener() { public void actionPerformed(ActionEvent e) { s17_2 numberDisplay = new s17_2(textField); Thread thread = new Thread(numberDisplay); thread.start(); } }); } }

slip no 18

2.

import java.io.IOException; import java.io.PrintWriter; import javax.servlet.ServletException; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; public class StudentDetails extends HttpServlet { private static final long serialVersionUID = 1L; protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { response.setContentType("text/html"); PrintWriter out = response.getWriter(); String seatNo = request.getParameter("seatno"); String studName = request.getParameter("studname"); String studentClass = request.getParameter("class"); int totalMarks = Integer.parseInt(request.getParameter("totalmarks")); double percentage = (double) totalMarks / 5; String grade; if (percentage >= 80) { grade = "A+"; } else if (percentage >= 70) { grade = "A"; } else if (percentage >= 60) { grade = "B"; } else if (percentage >= 50) { grade = "C"; } else { grade = "F"; } out.println("<html>"); out.println("<head>"); out.println("<title>Student Details</title>"); out.println("</head>"); out.println("<body>"); out.println("<h1>Student Details</h1>"); out.println("<table>"); out.println("<tr><td>Seat No:</td><td>" + seatNo + "</td></tr>"); out.println("<tr><td>Student Name:</td><td>" + studName + "</td></tr>"); out.println("<tr><td>Class:</td><td>" + studentClass + "</td></tr>"); out.println("<tr><td>Total Marks:</td><td>" + totalMarks + "</td></tr>"); out.println("<tr><td>Percentage:</td><td>" + percentage + "%</td></tr>"); out.println("<tr><td>Grade:</td><td>" + grade + "</td></tr>"); out.println("</table>"); out.println("</body>"); out.println("</html>"); } }

slip no 19

import java.util.Scanner; import java.util.LinkedList; public class s19_1 { public static void main(String[] args) { Scanner sc = new Scanner(System.in); LinkedList<Integer> list = new LinkedList<Integer>(); System.out.print("Enter the number of integers: "); int n = sc.nextInt(); System.out.println("Enter " + n + " integers:"); for (int i = 0; i < n; i++) { int num = sc.nextInt(); list.add(num); } System.out.println("Negative Integers:"); for (int i : list) { if (i < 0) { System.out.println(i); } } sc.close(); // Close the scanner } }

2.

import java.io.IOException; import java.io.PrintWriter; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import javax.servlet.ServletException; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; public class LoginServlet extends HttpServlet { private static final long serialVersionUID = 1L; protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { response.setContentType("text/html;charset=UTF-8"); PrintWriter out = response.getWriter(); String username = request.getParameter("username"); String password = request.getParameter("password"); Connection conn = null; PreparedStatement stmt = null; ResultSet rs = null; try { // Load the JDBC driver Class.forName("com.mysql.cj.jdbc.Driver"); // Set up the connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/mydatabase", "root", "password"); // Prepare the statement stmt = conn.prepareStatement("SELECT * FROM users WHERE username=? AND password=?"); stmt.setString(1, username); stmt.setString(2, password); // Execute the query rs = stmt.executeQuery(); // Check if the user exists if (rs.next()) { out.println("<h1>Login successful!</h1>"); } else { out.println("<h1>Error: Invalid username or password.</h1>"); } } catch (ClassNotFoundException | SQLException e) { e.printStackTrace(); } finally { // Close the resources in a finally block to ensure they are always closed try { if (rs != null) { rs.close(); } if (stmt != null) { stmt.close(); } if (conn != null) { conn.close(); } } catch (SQLException e) { e.printStackTrace(); } } } }

slip no 20

<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%> <!DOCTYPE html> <html> <head> <meta charset="UTF-8"> <title>Number to Words Converter</title> <style> .red { color: red; } </style> </head> <body> <h1>Number to Words Converter</h1> <form method="post"> Enter a number: <input type="text" name="number"/><br/> <input type="submit" value="Convert"/> </form> <br/> <% // Get the number from the request parameter String numberStr = request.getParameter("number"); // Check if the number is not null and not empty if (numberStr != null && !numberStr.trim().isEmpty()) { try { // Convert the number to words String[] words = {"Zero", "One", "Two", "Three", "Four", "Five", "Six", "Seven", "Eight", "Nine"}; String number = numberStr.trim(); // Validate if the input contains only digits if (number.matches("\\d+")) { out.println("<span class=\"red\">"); for (int i = 0; i < number.length(); i++) { out.println(words[Character.getNumericValue(number.charAt(i))] + " "); } out.println("</span>"); } else { out.println("<span class=\"red\">Invalid input: Please enter a valid number</span>"); } } catch (Exception e) { out.println("<span class=\"red\">Error: " + e.getMessage() + "</span>"); } } %> </body> </html>

2.

import java.awt.BorderLayout; import java.awt.Dimension; import java.awt.Graphics; import java.awt.Image; import java.awt.event.ActionEvent; import java.awt.event.ActionListener; import java.io.File; import java.io.IOException; import javax.imageio.ImageIO; import javax.swing.JFrame; import javax.swing.JPanel; import javax.swing.Timer; public class BlinkingImage extends JPanel implements ActionListener { private static final long serialVersionUID = 1L; private Image image; private boolean blinkOn = true; public BlinkingImage(Image image) { this.image = image; Timer timer = new Timer(500, this); // timer fires every 500ms timer.start(); } @Override protected void paintComponent(Graphics g) { super.paintComponent(g); if (blinkOn && image != null) { g.drawImage(image, 0, 0, this); } } @Override public void actionPerformed(ActionEvent e) { blinkOn = !blinkOn; repaint(); } public static void main(String[] args) { try { // Load the image Image image = ImageIO.read(new File("path/to/image.png")); // Create the panel with the blinking image JPanel contentPane = new BlinkingImage(image); contentPane.setPreferredSize(new Dimension(image.getWidth(null), image.getHeight(null))); // Create and configure the frame JFrame frame = new JFrame("Blinking Image"); frame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE); frame.getContentPane().add(contentPane, BorderLayout.CENTER); frame.pack(); frame.setLocationRelativeTo(null); frame.setVisible(true); } catch (IOException e) { e.printStackTrace(); System.err.println("Error loading the image: " + e.getMessage()); } } }

slip no 21

import java.util.*; import java.io.*; public class s21_1 { public static void main(String[] args) { Scanner sc = new Scanner(System.in); LinkedList<Integer> list = new LinkedList<Integer>(); System.out.print("Enter the number of integers: "); int n = sc.nextInt(); System.out.println("Enter " + n + " integers:"); for (int i = 0; i < n; i++) { int num = sc.nextInt(); list.add(num); } Iterator itr=list.iterator(); if(itr.hasNext()) { System.out.println(itr.next()); } } }

2.

import java.util.LinkedList; public class ProducerConsumer { public static void main(String[] args) { LinkedList<Integer> buffer = new LinkedList<>(); int bufferSize = 5; Thread producerThread = new Thread(new Producer(buffer, bufferSize), "Producer"); Thread consumerThread = new Thread(new Consumer(buffer), "Consumer"); producerThread.start(); consumerThread.start(); } } class Producer implements Runnable { private final LinkedList<Integer> buffer; private final int bufferSize; private int value = 0; public Producer(LinkedList<Integer> buffer, int bufferSize) { this.buffer = buffer; this.bufferSize = bufferSize; } public void run() { while (true) { synchronized (buffer) { if (buffer.size() < bufferSize) { buffer.add(value); System.out.println(Thread.currentThread().getName() + " produced " + value); value++; buffer.notifyAll(); } else { try { buffer.wait(); } catch (InterruptedException e) { e.printStackTrace(); } } } } } } class Consumer implements Runnable { private final LinkedList<Integer> buffer; public Consumer(LinkedList<Integer> buffer) { this.buffer = buffer; } @Override public void run() { while (true) { synchronized (buffer) { if (buffer.isEmpty()) { try { buffer.wait(); } catch (InterruptedException e) { e.printStackTrace(); } } else { int value = buffer.removeFirst(); System.out.println(Thread.currentThread().getName() + " consumed " + value); buffer.notifyAll(); } } } } }

slip no 22

//s22_1 import java.sql.*; public class EmployeeManagement { static final String JDBC_DRIVER = "com.mysql.cj.jdbc.Driver"; static final String DB_URL = "jdbc:mysql://localhost:3306/mydatabase"; static final String USER = "username"; static final String PASSWORD = "password"; public static void main(String[] args) { Connection conn = null; Statement stmt = null; try { Class.forName(JDBC_DRIVER); conn = DriverManager.getConnection(DB_URL, USER, PASSWORD); stmt = conn.createStatement(); int choice; do { System.out.println("Menu:"); System.out.println("1. Insert"); System.out.println("2. Update"); System.out.println("3. Display"); System.out.println("4. Exit"); System.out.print("Enter your choice: "); choice = Integer.parseInt(System.console().readLine()); switch (choice) { case 1: System.out.print("Enter employee number: "); int eno = Integer.parseInt(System.console().readLine()); System.out.print("Enter employee name: "); String ename = System.console().readLine(); System.out.print("Enter employee salary: "); double salary = Double.parseDouble(System.console().readLine()); String sql = "INSERT INTO Employee (ENo, EName, Salary) VALUES (" + eno + ", '" + ename + "', " + salary + ")"; stmt.executeUpdate(sql); System.out.println("Record inserted successfully."); break; case 2: System.out.print("Enter employee number: "); eno = Integer.parseInt(System.console().readLine()); System.out.print("Enter new employee name: "); ename = System.console().readLine(); System.out.print("Enter new employee salary: "); salary = Double.parseDouble(System.console().readLine()); sql = "UPDATE Employee SET EName='" + ename + "', Salary=" + salary + " WHERE ENo=" + eno; int rowsAffected = stmt.executeUpdate(sql); if (rowsAffected == 0) { System.out.println("No records found with employee number " + eno); } else { System.out.println(rowsAffected + " record(s) updated successfully."); } break; case 3: sql = "SELECT * FROM Employee"; ResultSet rs = stmt.executeQuery(sql); while (rs.next()) { eno = rs.getInt("ENo"); ename = rs.getString("EName"); salary = rs.getDouble("Salary"); System.out.println("Employee number: " + eno + ", Employee name: " + ename + ", Employee salary: " + salary); } rs.close(); break; case 4: System.out.println("Exiting program."); break; default: System.out.println("Invalid choice. Please try again."); break; } } while (choice != 4); } catch (Exception e) { e.printStackTrace(); } finally { try { if (stmt != null) { stmt.close(); } if (conn != null) { conn.close(); } } catch (SQLException e) { e.printStackTrace(); } } } } //s22_2 <%@ page language="java" %> <html> <head> <title>Greeting Page</title> </head> <body> <h1>Welcome to our website</h1> <% String userName = request.getParameter("userName"); String greetingMessage = "Hello, " + userName; java.util.Date date = new java.util.Date(); java.text.SimpleDateFormat sdf = new java.text.SimpleDateFormat("hh:mm:ss a"); int hour = Integer.parseInt(sdf.format(date).substring(0, 2)); if (hour >= 0 && hour < 12) { greetingMessage += ". Good morning!"; } else if (hour >= 12 && hour < 18) { greetingMessage += ". Good afternoon!"; } else { greetingMessage += ". Good evening!"; } %> <p><%= greetingMessage %></p> <form action="greeting.jsp" method="get"> Enter your name: <input type="text" name="userName"> <input type="submit" value="Submit"> </form> </body> </html>

2.

<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%> <!DOCTYPE html> <html> <head> <meta charset="UTF-8"> <title>Greeting Page</title> </head> <body> <h1>Welcome to our website</h1> <% String userName = request.getParameter("userName"); // retrieve user input from the form String greetingMessage = "Hello, " + userName; java.util.Date date = new java.util.Date(); // get the current date and time java.text.SimpleDateFormat sdf = new java.text.SimpleDateFormat("hh:mm:ss a"); // format the date and time int hour = Integer.parseInt(sdf.format(date).substring(0, 2)); // extract the hour from the formatted date if (hour >= 0 && hour < 12) { greetingMessage += ". Good morning!"; } else if (hour >= 12 && hour < 18) { greetingMessage += ". Good afternoon!"; } else { greetingMessage += ". Good evening!"; } %> <p><%= greetingMessage %></p> <form action="greeting.jsp" method="get"> Enter your name: <input type="text" name="userName"> <input type="submit" value="Submit"> </form> </body> </html>

slip no 23

//s23_1 import java.util.Scanner; public class VowelDisplay { public static void main(String[] args) { Scanner scanner = new Scanner(System.in); System.out.print("Enter a string: "); String inputString = scanner.nextLine().toLowerCase(); // convert input to lowercase for (int i = 0; i < inputString.length(); i++) { char c = inputString.charAt(i); if (isVowel(c)) { System.out.print(c + " "); try { Thread.sleep(3000); // pause for 3 seconds } catch (InterruptedException e) { e.printStackTrace(); } } } } public static boolean isVowel(char c) { return (c == 'a' || c == 'e' || c == 'i' || c == 'o' || c == 'u'); } } //s23_2 import java.util.ArrayList; import java.util.Iterator; import java.util.ListIterator; public class StudentNames { public static void main(String[] args) { ArrayList<String> studentNames = new ArrayList<>(); for (String arg : args) { studentNames.add(arg); } System.out.println("Student names using Iterator:"); Iterator<String> iterator = studentNames.iterator(); while (iterator.hasNext()) { System.out.println(iterator.next()); } System.out.println("\nStudent names using ListIterator:"); ListIterator<String> listIterator = studentNames.listIterator(); while (listIterator.hasNext()) { System.out.println(listIterator.next()); } } }

2.

import java.util.ArrayList; import java.util.Iterator; import java.util.ListIterator; public class StudentNames { public static void main(String[] args) { ArrayList<String> studentNames = new ArrayList<>(); for (String arg : args) { studentNames.add(arg); } System.out.println("Student names using Iterator:"); Iterator<String> iterator = studentNames.iterator(); while (iterator.hasNext()) { System.out.println(iterator.next()); } System.out.println("\nStudent names using ListIterator:"); ListIterator<String> listIterator = studentNames.listIterator(); while (listIterator.hasNext()) { System.out.println(listIterator.next()); } } }

slip no 24

import java.awt.Color; import java.awt.Font; import java.awt.Graphics; import javax.swing.JFrame; import javax.swing.JPanel; public class ScrollingText extends JPanel implements Runnable { private int x, y; private String message; private Thread thread; private boolean running; public ScrollingText(String message) { this.message = message; x = getWidth(); y = getHeight() / 2; setFont(new Font("Arial", Font.BOLD, 20)); setForeground(Color.RED); setBackground(Color.WHITE); thread = new Thread(this); running = true; thread.start(); } public void run() { while (running) { try { Thread.sleep(20); } catch (InterruptedException e) { e.printStackTrace(); } x--; if (x < -getFontMetrics(getFont()).stringWidth(message)) { x = getWidth(); } repaint(); } } public void paintComponent(Graphics g) { super.paintComponent(g); g.drawString(message, x, y); } public static void main(String[] args) { JFrame frame = new JFrame("Scrolling Text"); frame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE); frame.setSize(400, 100); ScrollingText scrollingText = new ScrollingText("This is scrolling text"); frame.add(scrollingText); frame.setVisible(true); } }

2.

<%@ page language="java" %>

<%@ page import="java.io.*, java.util.*" %>

String username = request.getParameter("username");

String password = request.getParameter("password");

if (username.equals(password)) {

response.sendRedirect("Login.html?message=Login Successfully");

} else {

response.sendRedirect("Error.html?message=Login Failed");

}

slip no 25

<%@ page language="java" %> <%@ page import="java.io.*, java.util.*" %> <% String name = request.getParameter("name"); int age = Integer.parseInt(request.getParameter("age")); String message; if (age >= 18) { message = name + ", you are eligible to vote."; } else { message = name + ", you are not eligible to vote."; } %> <!DOCTYPE html> <html> <head> <title>Voting Eligibility Checker</title> </head> <body> <h3><%= message %></h3> <form method="post" action=""> <label for="name">Name:</label> <input type="text" name="name" id="name" required><br><br> <label for="age">Age:</label> <input type="number" name="age" id="age" required><br><br> <input type="submit" value="Check Eligibility"> </form> </body> </html>

slip no 26

import java.sql.*; import javax.swing.*; import javax.swing.table.DefaultTableModel; public class CollegeDetailsJTable extends JFrame { static final String DB_URL = "jdbc:mysql://localhost:3306/college"; static final String DB_USER = "root"; static final String DB_PASSWORD = "password"; public CollegeDetailsJTable() { super("College Details"); JTable table = new JTable(); String[] columnNames = {"CID", "CName", "Address", "Year"}; DefaultTableModel model = new DefaultTableModel(columnNames, 0); try { Connection conn = DriverManager.getConnection(DB_URL, DB_USER, DB_PASSWORD); Statement stmt = conn.createStatement(); ResultSet rs = stmt.executeQuery("SELECT * FROM college"); while (rs.next()) { String cid = rs.getString("CID"); String cname = rs.getString("CName"); String address = rs.getString("Address"); int year = rs.getInt("Year"); model.addRow(new Object[]{cid, cname, address, year}); } rs.close(); stmt.close(); conn.close(); } catch (SQLException e) { e.printStackTrace(); } table.setModel(model); JScrollPane scrollPane = new JScrollPane(table); getContentPane().add(scrollPane); setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE); setLocationRelativeTo(null); pack(); setVisible(true); } public static void main(String[] args) { new CollegeDetailsJTable(); } }

2.

<!DOCTYPE html> <html> <head> <title>Sum of First and Last Digit</title> </head> <body> <h1>Calculate Sum of First and Last Digit</h1> <% int num = Integer.parseInt(request.getParameter("number")); int firstDigit = num; while (firstDigit >= 10) { firstDigit /= 10; } int lastDigit = num % 10; int sum = firstDigit + lastDigit; out.println("<p style=\"color:red;font-size:18px;\">Sum of first and last digit of " + num + " is " + sum + "</p>"); %> <form action="" method="get"> <label for="number">Enter a number:</label> <input type="number" id="number" name="number" required> <button type="submit">Calculate</button> </form> </body> </html>

slip no 27

1.

import java.sql.*; import javax.swing.*; import javax.swing.table.DefaultTableModel; public class CollegeDetailsJTable extends JFrame { static final String DB_URL = "jdbc:mysql://localhost:3306/college"; static final String DB_USER = "root"; static final String DB_PASSWORD = "password"; public CollegeDetailsJTable() { super("College Details"); JTable table = new JTable(); String[] columnNames = {"CID", "CName", "Address", "Year"}; s DefaultTableModel model = new DefaultTableModel(columnNames, 0); try (Connection conn = DriverManager.getConnection(DB_URL, DB_USER, DB_PASSWORD)) { String sql = "SELECT * FROM college"; try (PreparedStatement pstmt = conn.prepareStatement(sql); ResultSet rs = pstmt.executeQuery()) { while (rs.next()) { String cid = rs.getString("CID"); String cname = rs.getString("CName"); String address = rs.getString("Address"); int year = rs.getInt("Year"); model.addRow(new Object[]{cid, cname, address, year}); } } } catch (SQLException e) { e.printStackTrace(); } table.setModel(model); JScrollPane scrollPane = new JScrollPane(table); getContentPane().add(scrollPane); setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE); setLocationRelativeTo(null); pack(); setVisible(true); } public static void main(String[] args) { new CollegeDetailsJTable(); } }

2.

import java.io.*;

import javax.servlet.*;

import javax.servlet.http.*;

public class ChangeSessionTimeout extends HttpServlet {

public void doGet(HttpServletRequest request, HttpServletResponse response)

throws ServletException, IOException {

HttpSession session = request.getSession();

session.setMaxInactiveInterval(600);

response.setContentType("text/html");

PrintWriter out = response.getWriter();

out.println("<html><body>");

out.println("<h3>Session Timeout Changed to 10 Minutes</h3>");

out.println("</body></html>");

}

slip no 28

1.

<%@ page language="java" %>

<html>

<head>

<title>Reverse String</title>

</head>

<body>

<h2>Enter a string to reverse:</h2>

</form>

String inputString = request.getParameter("stringToReverse");

if (inputString != null) {

StringBuilder reversedString = new StringBuilder(inputString);

reversedString.reverse();

out.print("<h2>Reversed string: " + reversedString + "</h2>");

}

</body>

</html>

2. slip no 29

1.

import java.sql.*;

public class DonarTableColumnInfo {

public static void main(String[] args) {

String url = "jdbc:mysql://localhost:3306/mydb"; // replace mydb with your database name

String username = "root"; // replace root with your MySQL username

String password = "password"; // replace password with your MySQL password

try (Connection con = DriverManager.getConnection(url, username, password);

PreparedStatement ps = con.prepareStatement("SELECT * FROM DONAR");

ResultSet rs = ps.executeQuery()) {

ResultSetMetaData rsmd = rs.getMetaData();

int columnCount = rsmd.getColumnCount();

System.out.println("Column Name\t\tData Type");

System.out.println("------------------------------------------");

for (int i = 1; i <= columnCount; i++) {

String columnName = rsmd.getColumnName(i);

String dataType = rsmd.getColumnTypeName(i);

System.out.println(columnName + "\t\t\t" + dataType);

}

} catch (SQLException e) {

System.out.println("Error: " + e.getMessage());

}

2.

import java.util.LinkedList;

public class LinkedListDemo {

public static void main(String[] args) {

LinkedList<Integer> list = new LinkedList<>();

list.addFirst(10);

list.addFirst(20);

list.addFirst(30);

System.out.println("LinkedList after adding elements at first position: " +

list);

list.removeLast();

System.out.println("LinkedList after deleting last element: " + list);

System.out.println("Size of LinkedList: " + list.size());

}

slip no 30

1.

class Counter {

private int count = 0;

public synchronized void increment() {

count++;

}

public int getCount() {

return count;

}

class MyThread extends Thread {

private Counter counter;

public MyThread(Counter counter) {

this.counter = counter;

}

public void run() {

for (int i = 0; i < 1000; i++) {

counter.increment();

}

public class SyncDemo {

public static void main(String[] args) {

Counter counter = new Counter();

MyThread thread1 = new MyThread(counter);

MyThread thread2 = new MyThread(counter);

thread1.start();

thread2.start();

try {

thread1.join();

thread2.join();

} catch (InterruptedException e) {

System.out.println("Main thread interrupted");

Thread.currentThread().interrupt(); // Restore interrupted status

}

System.out.println("Count: " + counter.getCount());

}

2.

import java.sql.*;

public class ScrollableResultSetExample {

public static void main(String[] args) {

Connection conn = null;

Statement stmt = null;

ResultSet rs = null;

try {

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

conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/mydb", "username", "password");

stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);

rs = stmt.executeQuery("SELECT * FROM Teacher");

rs.last();

int rowCount = rs.getRow();

rs.beforeFirst();

ResultSetMetaData rsmd = rs.getMetaData();

for (int i = 1; i <= rsmd.getColumnCount(); i++) {

System.out.print(rsmd.getColumnName(i) + "\t");

}

System.out.println();

while (rs.next()) {

System.out.print(rs.getInt("TID") + "\t");

System.out.print(rs.getString("TName") + "\t");

System.out.print(rs.getInt("Salary") + "\t");

System.out.println();

}

} catch (Exception ex) {

ex.printStackTrace();

} finally {

try {

if (rs != null) rs.close();

if (stmt != null) stmt.close();

if (conn != null) conn.close();

} catch (SQLException e) {

e.printStackTrace();

}

slip no 1

1.

2.

slip no 2

1.

b.

slip no 3

1.

2.

slip no 4

1.

2.

slip no 5

1

2.

slip no 6

slip no 7

1.

2.

slip no 8

2.

slip no 9

2.

slip no 10

2.

slip no 11

1.

2.

slip no 12

2.

slip no 13

2.

slip no 14

2.

slip no 15

slip no 16

2.

slip no 17

1.

2.

slip no 18

2.

slip no 19

2.

slip no 20

2.

slip no 21

2.

slip no 22

2.

slip no 23

2.

slip no 24

2.

slip no 25

slip no 26

2.

slip no 27

2.

slip no 28

2.

slip no 29

2.

slip no 30

2.

Comments

Post a Comment