Coding Lab - TechOnTechnology

Java program to read regno, name and address from the keyboard and insert into the database.





Click Here to Know the Steps to Connect database in Linux Environment System



import java.io.*;
import java.sql.*;
class jdbc1
{
public static void main(String args[]) throws SQLException
         {
                 int reg;
                 String name,address;
                try
                 {
                        DataInputStream in=new DataInputStream(System.in);
                        Class.forName("com.mysql.jdbc.Driver").newInstance();
                        Connection con=DriverManager.getConnection("jdbc:mysql://localhost/student","root","password");
                        System.out.println("Enter the register number");
                        reg=Integer.parseInt(in.readLine());
                         System.out.println("Enter the student name");
                        name=in.readLine();
                        System.out.println("Enter the address");
                        address=in.readLine();
                        Statement stm=con.createStatement();
                String s="insert into student values(" + reg + ",'" + name + "','" + address + "');";
                                stm.executeUpdate(s);
                                System.out.println("Record is inserted");
                         String s1="select * from student";
                         ResultSet rs=stm.executeQuery(s1);
                        while(rs.next())
                        {
                              reg=rs.getInt("reg");
                                name=rs.getString("name");
                                address=rs.getString("address");
                                System.out.println(reg + "\t" + name + "\t" + address + "\t");
                        }

                stm.close();
                con.close();
                }
                catch(Exception e)
                {
e.printStackTrace();
}
        }
}



Click Here to Know the Steps to Connect database in Linux Environment System



Name

Email *

Message *