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();
}
}
}
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