Thread: database connectivity

[



















package demo5;
import java.sql.*;
public class Demo5 {


public static void main(String[] args) {
try{

String Query="select * from student where rollno=2";
Class.forName("com.mysql.jdbc.Driver");
try (Connection con = DriverManager.getConnection("jdbc:mysql://localhost/demo5","root","0" )) {
Statement st=con.createStatement();
ResultSet rs=st.executeQuery(Query);
rs.next();
String sname=rs.getString(2);
System.out.println(sname);
}


}





catch(Exception ex ){







}












]/[run:
BUILD SUCCESSFUL (total time: 0 seconds)


just coming but i made connectivity with mysql but it means i made four table thatis rollno and and name i also pass a string in this query where student rollno=2 but it is just geting executed its not displaying row table y so
]

--- Update ---

plz help me out frndssssssss

hi frnds i done connnectivity with mysql i written a code of connectivity in netbeans basically i made 4 table in mysql i want yto select one row from the table were rollno=2 dissplay the name but wen i execute the connectivity code it just run build succesfully it wont display the rowwwwwwwwwww y sooooo just executes succesfully wont show table

frnd m new to forum frnd say wats a problem m getting just executed succesfully y not it disolaying atable or row

sir its connectivity code i written in netbeans but wen i execute it it just run build succesfully it gives y not it display a row of table

Please format your code. For guidelines Please read .

In your code you have to iterate through the resultset you get on executing the query.
try this..

while(rs.next()){
String sname=rs.getString(2);
System.out.println(sname);
}

my database is not connecting u have any idea how to connect aprat frnd

I didn't get your problem.

hi frnds i done connnectivity with mysql i written a code of connectivity in netbeans basically i made 4 table in mysql i want yto select one row from the table were rollno=2 dissplay the name but wen i execute the connectivity code it just run build succesfully it wont display the rowwwwwwwwwww y sooooo just executes succesfully wont show table

.
are you facing problem in getting the data from resultset?
or have problem with your database connectivity?

Paste the full error message that you get while connecting to the database for better clarification.