JAVA DATABASE

/*this program is for access database with jdbc odbc driver database1
and database with 3 fields*/

import java.awt.*;
import java.sql.*;
import javax.swing.*;
public class db{
public static void main(String[] arguments) {
PreparedStatement ps;
ResultSet rs;
int id;
String s;
Connection conn;
Statement st;
String data = "jdbc:odbc:database1";
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
conn = DriverManager.getConnection(data, "", "");
System.out.print("\nConnection successful");
s= JOptionPane.showInputDialog(null,"Enter ID : ");
id=Integer.parseInt(s);

String name= JOptionPane.showInputDialog(null,"Enter NAME : ");


s= JOptionPane.showInputDialog(null,"Enter MARK : ");
int mark=Integer.parseInt(s);

st=conn.createStatement();
ps=conn.Statement("select * from sinfo where id = "+id);
rs=st.executeQuery("select * from sinfo where id = "+id);
while(rs.next())
{
System.out.print("\n\nID : "+rs.getString(1)+"\tName : "+rs.getString(2)+"\tMarks : "+rs.getString(3));
}
rs=st.executeQuery("insert into sinfo(id,name,mark) values ("+id+", '"+name+"', "+mark+")");
}
catch(Exception e)
{
System.out.print(e);
}

}
}