tag:blogger.com,1999:blog-49089214871184343872024-03-08T01:33:24.879-08:00DTR1211Lärarnhttp://www.blogger.com/profile/06486265983656360695noreply@blogger.comBlogger5125tag:blogger.com,1999:blog-4908921487118434387.post-5407108766631455632010-06-07T23:54:00.000-07:002010-06-07T23:55:44.903-07:00utmatning java - by popular demand<pre> <br /> void utmatning(){<br /> String sql = "SELECT * FROM `music`.`Artist`;" ;<br /> System.out.println(sql);<br /> ResultSet rs = dbs.query(sql);<br /> String[] array;<br /> while((array =dbs.fetchArray(rs)) != null){<br /> System.out.println(array[1] + " " + array[2]);<br /> }<br /> }<br /></pre>Patrik Gustafssonhttp://www.blogger.com/profile/15802919875477858710noreply@blogger.com0tag:blogger.com,1999:blog-4908921487118434387.post-82340398032147100832010-03-30T00:35:00.001-07:002010-06-08T00:00:12.669-07:00DatabasServer- java - hur du komunicerar med DB<pre>ppackage musicdb;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.logging.Level;
import java.util.logging.Logger;
/**
*
* @author gustafsp
*/
public class DatabasServer {
final static String server = "localhost";
final static int port = 3306;
final static String login = "root";
final static String password = "mysql";
final static String databas = "music";
private static Connection con;
public static Connection connect() {
try {
Class.forName("com.mysql.jdbc.Driver");
} catch (ClassNotFoundException ex) {
System.out.println("MYSQL driver missing?");
}
//Define URL of database server for
// database named JunkDB on the localhost
// with the default port number 3306.
String url = "jdbc:mysql://" + DatabasServer.server + ":" + DatabasServer.port;
try {
//Get a connection to the database for a
// user named auser with the password
// drowssap, which is password spelled
// backwards.
con = DriverManager.getConnection(
url, DatabasServer.login, DatabasServer.password);
return con;
} catch (SQLException ex) {
System.out.println("Login Fail: password ok?");
}
return null;
}
public static ResultSet query(String sql) {
try {
if (con == null) {
con = DatabasServer.connect();
}
Statement stmt = con.createStatement();
if (stmt.execute(sql)) {
return stmt.getResultSet();
}
} catch (SQLException ex) {
Logger.getLogger(DatabasServer.class.getName()).log(Level.SEVERE, null, ex);
}
return null;
}
public static String[] fetchArray(ResultSet result) {
try {
String[] array = new String[result.getMetaData().getColumnCount()];
if (result.next()) {
for (int i = 1; i <= result.getMetaData().getColumnCount(); i++) {
array[i - 1] = result.getString(i);
}
return array;
}
} catch (SQLException ex) {
Logger.getLogger(DatabasServer.class.getName()).log(Level.SEVERE, null, ex);
}
return null; //om fel eller inget värde
}
}
</pre>Lärarnhttp://www.blogger.com/profile/06486265983656360695noreply@blogger.com0tag:blogger.com,1999:blog-4908921487118434387.post-54776740317383712132010-03-23T06:24:00.000-07:002010-03-23T06:24:54.585-07:00Updatering Sökning, Urval, Statistik/*<br />
* To change this template, choose Tools | Templates<br />
* and open the template in the editor.<br />
*/<br />
<br />
package musicdb;<br />
<br />
import java.sql.ResultSet;<br />
import javax.swing.JOptionPane;<br />
<br />
/**<br />
*<br />
* @author gustafsp<br />
*/<br />
public class DatabasHantering {<br />
// min komentar<br />
DatabasServer dbs = new DatabasServer();<br />
<br />
void urval(String urval){<br />
String sql = "SELECT * FROM `music`.`Artist` WHERE name = '" + urval + "';" ;<br />
System.out.println(sql);<br />
ResultSet rs = dbs.query(sql);<br />
String[] array;<br />
while((array =dbs.fetchArray(rs)) != null){<br />
System.out.println(array[1] + " " + array[2]);<br />
}<br />
<br />
}<br />
void sok(String sok){<br />
String sql = "SELECT * FROM `music`.`Artist` WHERE name LIKE '%" +<br />
sok +<br />
"%' ;" ;<br />
System.out.println(sql);<br />
ResultSet rs = dbs.query(sql);<br />
String[] array;<br />
while((array =dbs.fetchArray(rs)) != null){<br />
System.out.println(array[0] + " " + array[1] + " " + array[2]);<br />
}<br />
}<br />
void statistik(){<br />
String sql = "SELECT " +<br />
"sum(id) AS sum, " +<br />
"min(id) AS min, " +<br />
"max(id) AS max, " +<br />
"avg(id) AS avg," +<br />
"count(*) AS COUNT " +<br />
"FROM `music`.`Artist` GROUP BY Start ;" ;<br />
System.out.println(sql);<br />
ResultSet rs = dbs.query(sql);<br />
String[] array;<br />
while((array =dbs.fetchArray(rs)) != null){<br />
System.out.println(array[0]<br />
+ " " + array[1]<br />
+ " " + array[2]<br />
+ " " + array[3]<br />
+ " " + array[4]);<br />
}<br />
}<br />
<br />
<br />
public static void main(String[] args){<br />
DatabasHantering dh = new DatabasHantering();<br />
String s = JOptionPane.showInputDialog("Sök");<br />
System.out.println("Sök");<br />
dh.sok(s);<br />
System.out.println("Urval");<br />
dh.urval(s);<br />
System.out.println("Stat");<br />
dh.statistik();<br />
<br />
}<br />
}<br />
<div><br />
</div>Lärarnhttp://www.blogger.com/profile/06486265983656360695noreply@blogger.com0tag:blogger.com,1999:blog-4908921487118434387.post-85833190917361064362010-03-23T04:59:00.001-07:002010-03-23T05:02:44.827-07:00PHP - MYSQL Exempel<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"><br />
<html><br />
<head><br />
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8"><br />
<title></title><br />
</head><br />
<body><br />
<?php<br />
if($link = mysql_connect("localhost:3306", "root", "")) {<br />
echo "inloggad";<br />
$sql = "SELECT * FROM mysql.user LIMIT 0 , 30;";<br />
echo $sql;<br />
$result = mysql_query($sql, $link);<br />
if(!$result) {<br />
echo "noThing just a Fail";<br />
}else {<br />
while($row = mysql_fetch_array($result, MYSQL_ASSOC)) {<br />
foreach($row as $value) {<br />
echo $value. "";<br />
}<br />
echo "<br />";<br />
//print_r($row)<br />
}<br />
}<br />
}<br />
else {<br />
echo "Ej inloggad";<br />
}<br />
?><br />
</body><br />
</html><br />
<div><br />
</div>Lärarnhttp://www.blogger.com/profile/06486265983656360695noreply@blogger.com0tag:blogger.com,1999:blog-4908921487118434387.post-48391134306311379002010-03-23T01:28:00.000-07:002010-03-23T05:04:18.080-07:00Sök och urvals<div></div><blockquote><div>package musicdb;<br />
<br />
import java.sql.ResultSet;<br />
import javax.swing.JOptionPane;<br />
<br />
/**<br />
* @author gustafsp<br />
*/<br />
public class DatabasHantering {<br />
// min komentar<br />
DatabasServer dbs = new DatabasServer();<br />
<br />
void urval(String urval){<br />
String sql = "SELECT * FROM `music`.`Artist` WHERE name = '" + urval + "';" ;<br />
System.out.println(sql);<br />
ResultSet rs = dbs.query(sql);<br />
String[] array;<br />
while((array =dbs.fetchArray(rs)) != null){<br />
System.out.println(array[1] + " " + array[2]);<br />
}<br />
<br />
}<br />
void sok(String sok){<br />
String sql = "SELECT * FROM `music`.`Artist` WHERE name LIKE '%" +<br />
sok +<br />
"%' ;" ;<br />
System.out.println(sql);<br />
ResultSet rs = dbs.query(sql);<br />
String[] array;<br />
while((array =dbs.fetchArray(rs)) != null){<br />
System.out.println(array[1] + " " + array[2]);<br />
}<br />
}<br />
public static void main(String[] args){<br />
DatabasHantering dh = new DatabasHantering();<br />
String s = JOptionPane.showInputDialog("Sök");<br />
System.out.println("Sök");<br />
dh.sok(s);<br />
System.out.println("Urval");<br />
dh.urval(s);<br />
<br />
}<br />
}<br />
<div><br />
</div></div></blockquote>Lärarnhttp://www.blogger.com/profile/06486265983656360695noreply@blogger.com0