University:
California State University, Chico
Course:
CSED 590 | Software Design, Data Structures, and Algorithms
Academic year:

2023
Views:

6

Pages:

3
Author:

dhruvil5011

Practical No. : 5 Problem Statement: Write a java application that fnds out no. of records, no. of columns and types of columns within a table. Program: import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.ResultSetMetaData; import java.sql.Statement; public class Prac5_1 { public static void main(String[] args) throws Exception{ try { Class.forName("com.mysql.cj.jdbc.Driver"); Connection con=DriverManager.getConnection("jdbc:mysql://localhost/mysql","root","123456"); Statement st=con.createStatement(); ResultSet rs=st.executeQuery("select * from student"); ResultSetMetaData rsmd = rs.getMetaData(); int count = 0; while(rs.next()) { count++; } System.out.println("Number of Record is : " + count); System.out.println("Number of Column is : " + rsmd.getColumnCount()); for(int j = 1;j<=rsmd.getColumnCount();j++) { System.out.println("Column Type of " + j + " : " + rsmd.getColumnTypeName(j)); } con.close(); } catch(Exception e) { SCET/CO/2022-23/EVEN/BE Shift-II/Sem-VI Page No : 1 } } } Output: Problem Statement: Write an application that calls Stored Procedure. Program: import java.sql.Connection; import java.sql.DriverManager; import java.sql.SQLException; import java.sql.Types; import java.sql.CallableStatement; public class Prac5_2 { public static void main(String[] args) throws SQLException,ClassNotFoundException{ Class.forName("oracle.jdbc.driver.OracleDriver"); Connection con=DriverManager.getConnection("jdbc:oracle:thin:@172.16.3.91:1521:orcl","su21d126","stud ent"); CallableStatement cs = con.prepareCall("{call STUDENT_PROCEDURES(?,?)}"); SCET/CO/2022-23/EVEN/BE Shift-II/Sem-VI Page No : 2 cs.registerOutParameter(2, Types.VARCHAR); cs.setInt(1, 8);; cs.execute(); System.out.println(cs.getString(2)); } } Procedure: Output: SCET/CO/2022-23/EVEN/BE Shift-II/Sem-VI Page No : 3

Java Database Connectivity and Stored Procedures

Related Documents

Details

Description

Related Documents

Struggling with your assignment and deadlines?

Free up your schedule!

Take 5 seconds to unlock