package com.query; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.Statement; public class Main { public Teacher teacher; public Course course; public Section section; public Student student; public static Connection connecting; public static Statement st; public static ResultSet rs; public static void main(String[] args) throws Throwable { Class.forName("com.mysql.jdbc.Driver"); connecting = DriverManager.getConnection( "jdbc:mysql://localhost/student", "root", "4896558"); st = connecting.createStatement(); // st.executeUpdate("insert into student(student_name,gender) values('khalel','male')"); rs = st.executeQuery("Select * from student "); rs = st.executeQuery("Select * from student where idStudent=1"); Student s1 = new Student(); while (rs.next()) { s1.setId(rs.getInt(1)); s1.setName(rs.getString(2)); s1.setGender(rs.getString(3)); System.out.println(s1.getId() + " " + s1.getName() + " " + s1.getGender()); } Course c1 = new Course(); // st.executeUpdate("insert into course(course_name) values('OOP advance')"); rs = st.executeQuery("select * from course where idCourse=1"); while (rs.next()) { c1.setId(rs.getInt(1)); c1.setName(rs.getString(2)); System.out.println(c1.getId() + " " + c1.getName()); } Section s2 = new Section(); // st.executeUpdate("insert into section1(name,teacherId,courseId) values('History',1,1)"); rs = st.executeQuery("Select * from section1 where idsection=1 "); while (rs.next()) { s2.setId(rs.getInt(1)); s2.setName(rs.getString(2)); System.out.println(s2.getId() + " " + s2.getName()); } Teacher t1 = new Teacher(); // st.executeUpdate("insert into teacher (teacher_Name)values ('Amjad')"); rs = st.executeQuery("Select * from teacher where idteacher=1 "); while (rs.next()) { t1.setId(rs.getInt(1)); t1.setName(rs.getString(2)); System.out.println(t1.getId() + " " + t1.getName()); } } }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)