database

try{
Class.forName("com.mysql.jdbc.Driver");
java.sql.Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3306/entrydata","root","");
java.sql.Statement stmt=con.createStatement();
stmt.execute("insert into data(username,mobno,gender,state,address) VALUES('Vijay','9051458472','male','new delhi','saraswati')");
ResultSet rs=stmt.executeQuery("select username,mobno,gender,state,address from data");
while(rs.next()){
System.out.println(rs.getString("username"));
System.out.println(rs.getDouble("mobno"));
System.out.println(rs.getString("gender"));
System.out.println(rs.getString("state"));
System.out.println(rs.getString("address"));
}
con.close();

}catch(Exception e1){
System.out.println(e1);
}
}

No comments:

Post a Comment