Reterieving Database date
import java.sql.*; //Import all the package as per your requirement.
public class className
{
public static void main(String args[])
{
Connection con = null;
String url = "jdbc.mysql://localhost:3306/"; //url of your Database
String db = "DatabaseName"; // Name of your database
String driver ="com.mysql.jdbc.Driver"; //Driver for mysql
String user = "UserName"; //userName of DataBase.
String pass = "password"; //password of Database.
try
{
Class.forName(driver).newInstance();
con = DriverManager.getConnection(url + db , user ,pass);
Statement st = con.createStatement();
ResultSet res = st.executeQuery("Select * from tableName");
while(res.next())
{
String user1 = res.getString("columnName");
String pass1 = res.getString("columnName");
String data=(user1 + pass1);
System.out.println(data);
}
}
catch(Exception e)
{
e.printStackTrace;
}
}
}
Note:-To manipulate data from table write suitable query in executeQuery .
No comments:
Post a Comment