Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import java.sql.*;
- public class main {
- public static void main(String[] args) {
- try
- {
- String myDriver = "org.gjt.mm.mysql.Driver";
- String myUrl = "jdbc:mysql://ipdelserver/rank";
- Class.forName(myDriver);
- Connection conn = DriverManager.getConnection(myUrl, "Username", "password");
- String query = "SELECT * FROM Tabella";
- Statement st = conn.createStatement();
- ResultSet rs = st.executeQuery(query);
- while (rs.next())
- {
- int id = rs.getInt("id");
- String str1= rs.getString("str1");
- String str2= rs.getString("str2");
- System.out.format("%s, %s, %s, %s, %s, %s\n", id, str1, str2);
- }
- st.close();
- }
- catch (Exception e)
- {
- System.err.println(e.getMessage());
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement