Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import java.sql.Connection;
- import java.sql.DriverManager;
- import java.sql.ResultSet;
- import java.sql.Statement;
- public class ConnectionMySQL {
- public static void main(String a[]){
- try {
- Connection conn = DriverManager.getConnection("jdbc:mysql://10.22.40.134:3306/foo","test","1234");
- String query = "SELECT * FROM testtable";
- Statement stmt = conn.createStatement();
- ResultSet rs = stmt.executeQuery(query);
- while(rs.next()){
- for (int i=1; i<6; i++){
- System.out.println(rs.getString(i));
- }
- }
- } catch (Exception e){
- System.err.println(e);
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement