package org.MyStudent.Main;

import org.MyStudent.bean.Student;
import org.MyStudent.dao.StudentDAO;

public class mainClass {

	public static void main(String[] args) {

		Student student=new Student();
		student.setUsn(326);
		student.setClg_code(11);
		student.setContactNo(6666);
		student.setSName("CASE STUDY");
		student.setSem(6);
		student.setMarks(80);


		StudentDAO s=new StudentDAO();
		s.save(student);

	}

}
-----------------------------------------------------------------


package org.MyStudent.dao;

import java.sql.Connection;
import java.sql.PreparedStatement;

import org.MyStudent.bean.Student;
import org.MyStudent.conn.DbConn;

public class StudentDAO {


	public void save(Student student)
	{

		try
		{

		String sql="insert into student values(?,?,?,?,?,?)";
Connection con= DbConn.getConnect();
PreparedStatement stat=con.prepareStatement(sql);

stat.setInt(1, student.getUsn());
stat.setInt(2, student.getClg_code());
stat.setInt(3, student.getContactNo());
stat.setString(4, student.getSName());
stat.setInt(5, student.getSem());
stat.setInt(6, student.getMarks());

stat.executeUpdate();

		}
		catch (Exception e) {
			e.printStackTrace();
		}

	}

}
-------------------------------------------------------------------

package org.MyStudent.conn;

import java.sql.Connection;
import java.sql.DriverManager;

public class DbConn {


	public static Connection getConnect()
	{
		try
		{

		Class.forName("oracle.jdbc.OracleDriver");
	Connection connection=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe","system","tiger");
		return connection;
		}
		catch (Exception e) {
			return null;
		}
	}

}


------------------------------------------

package org.MyStudent.bean;

public class Student {

	int Usn;
	int Clg_code;
	int ContactNo;
	String SName;
	int Sem;
	int Marks;

	public int getUsn() {
		return Usn;
	}
	public void setUsn(int usn) {
		Usn = usn;
	}
	public int getClg_code() {
		return Clg_code;
	}
	public void setClg_code(int clg_code) {
		Clg_code = clg_code;
	}
	public int getContactNo() {
		return ContactNo;
	}
	public void setContactNo(int contactNo) {
		ContactNo = contactNo;
	}
	public String getSName() {
		return SName;
	}
	public void setSName(String sName) {
		SName = sName;
	}
	public int getSem() {
		return Sem;
	}
	public void setSem(int sem) {
		Sem = sem;
	}
	public int getMarks() {
		return Marks;
	}
	public void setMarks(int marks) {
		Marks = marks;
	}

}