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[1] + " " + array[2]);
}
}
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);
}
}
tisdag 23 mars 2010
Sök och urvals
Prenumerera på:
Kommentarer till inlägget (Atom)
Inga kommentarer:
Skicka en kommentar