importjava.sql.*;
import java.io.*;
class Slip6_1
{
public static void main(String a[])
{
PreparedStatementps;
Connection con;
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con=DriverManager.getConnection("jdbc:odbc:dsn");
if(con==null)
{
System.out.println("Connection Failed......");
System.exit(1);
}
System.out.println("Connection Esatablished......");
Statement stmt=con.createStatement();
BufferedReaderbr = new BufferedReader(new
InputStreamReader(System.in));
String query="insert into Customer values(?,?,?,?)";
ps=con.prepareStatement(query);
System.out.println("Customer Details....");
System.out.println("Enter CID");
intcid=Integer.parseInt(br.readLine());
ps.setInt(1,cid);
System.out.println("Enter name");
String name=br.readLine();
ps.setString(2,name);
System.out.println("Enter Address");
String add=br.readLine();
ps.setString(3,add);
System.out.println("Enter Ph_No");
String phno=br.readLine();
ps.setString(4,phno);
int no=ps.executeUpdate();
if(no!=0)
System.out.println("Data inserted succesfully.....");
else
System.out.println("Data NOT inserted");
con.close();
}
catch(Exception e)
{
e.printStackTrace();
}
}
}