UcanAccess Connectivity, Lab Reports of Java Programming

Hello guys this pdf have lots of content all are use good and do well....Thank you!

Typology: Lab Reports

2020/2021

Uploaded on 03/26/2021

ramkumar-m-1
ramkumar-m-1 🇮🇳

4 documents

1 / 1

Toggle sidebar

This page cannot be seen from the preview

Don't miss anything!

bg1
<%@ page import="java.sql.*" %>
<%
int a1=Integer.parseInt(request.getParameter("no"));
out.println(a1);
Connection con=DriverManager.getConnection("jdbc:ucanaccess://C:/Users/ELCOT/
Documents/MSACCESS/emp.accdb");
Statement st=con.createStatement();
ResultSet rs = st.executeQuery("select * from emp where empno="+a1);
int n1;
String name, add;
while(rs.next())
{
n1=rs.getInt(1);
name= rs.getString(2);
add=rs.getString(3);
out.println(n1+" "+name+" "+add);
}
%>

Partial preview of the text

Download UcanAccess Connectivity and more Lab Reports Java Programming in PDF only on Docsity!

<%@ page import="java.sql.*" %> <% int a1=Integer.parseInt(request.getParameter("no")); out.println(a1); Connection con=DriverManager.getConnection("jdbc:ucanaccess://C:/Users/ELCOT/ Documents/MSACCESS/emp.accdb"); Statement st=con.createStatement(); ResultSet rs = st.executeQuery("select * from emp where empno="+a1); int n1; String name, add; while(rs.next()) { n1=rs.getInt(1); name= rs.getString(2); add=rs.getString(3); out.println(n1+" "+name+" "+add); } %>