* To change this template, choose Tools | Templates
* and open the template in the editor.
*/
package musicdb;
import java.sql.ResultSet;
import javax.swing.JOptionPane;
/**
*
* @author gustafsp
*/
public class DatabasHantering {
// min komentar
DatabasServer dbs = new DatabasServer();
void urval(String urval){
String sql = "SELECT * FROM `music`.`Artist` WHERE name = '" + urval + "';" ;
System.out.println(sql);
ResultSet rs = dbs.query(sql);
String[] array;
while((array =dbs.fetchArray(rs)) != null){
System.out.println(array[1] + " " + array[2]);
}
}
void sok(String sok){
String sql = "SELECT * FROM `music`.`Artist` WHERE name LIKE '%" +
sok +
"%' ;" ;
System.out.println(sql);
ResultSet rs = dbs.query(sql);
String[] array;
while((array =dbs.fetchArray(rs)) != null){
System.out.println(array[0] + " " + array[1] + " " + array[2]);
}
}
void statistik(){
String sql = "SELECT " +
"sum(id) AS sum, " +
"min(id) AS min, " +
"max(id) AS max, " +
"avg(id) AS avg," +
"count(*) AS COUNT " +
"FROM `music`.`Artist` GROUP BY Start ;" ;
System.out.println(sql);
ResultSet rs = dbs.query(sql);
String[] array;
while((array =dbs.fetchArray(rs)) != null){
System.out.println(array[0]
+ " " + array[1]
+ " " + array[2]
+ " " + array[3]
+ " " + array[4]);
}
}
public static void main(String[] args){
DatabasHantering dh = new DatabasHantering();
String s = JOptionPane.showInputDialog("Sök");
System.out.println("Sök");
dh.sok(s);
System.out.println("Urval");
dh.urval(s);
System.out.println("Stat");
dh.statistik();
}
}
Inga kommentarer:
Skicka en kommentar