我们可以使用speedamp来搭一个服务器环境,可以在http://download.csdn.net/detail/baidu_nod/7630265下载
解压后无需安装直接可以使用，点击speedamp.exe,然后可以通过http://localhost/phpmyadmin/index.php来访问本地数据库
java可以通过jdbc来访问数据库,比较重要的是下载一个mysql-connector-java-5.1.22-bin.jar文件，然后在java工程中引用,
在代码里可以这样来访问:
import java.sql.*;public class conntest { public static final string _id = _id; public static final string table_name = spider; public static final string name = name; public static final string class_name = class; private static final string create_table_stmt = create table if not exists + table_name + ( + _id + integer primary key, + name + text, + class_name + text + );; public static void main(string[] args) { java.sql.connection conn = null; statement st = null; resultset rs = null; try { class.forname(com.mysql.jdbc.driver);//加载jar包 conn = drivermanager.getconnection(jdbc:mysql://localhost:3306/test?useunicode=true&characterencoding=utf8,root,);//取得数据库连接 //这个是创建一个表 st = conn.createstatement(); st.execute(create_table_stmt); //这是插入一条语句// st = conn.createstatement();// string sql = insert into spider(_id,name,class) values ('1','xiaoming','a');// st.executeupdate(sql); //这是采用preparedstatement实现的插入一条语句// string sql = insert into spider(_id,name,class) values (?,?,?);// preparedstatement _prepinsert = conn.preparestatement(sql);// _prepinsert.setint(1, 2);// _prepinsert.setstring(2, xiaoli);// _prepinsert.setstring(3, b);// _prepinsert.executeupdate(); // //这是一条更新语句// st = conn.createstatement();// string sql = update spider set class = 'c' where _id = '1';// st.executeupdate(sql); // //这是一条删除语句// st = conn.createstatement();// string sql = delete from spider where _id = '1';// st.executeupdate(sql); //这是查询语句 st = conn.createstatement(); string sql = select * from spider; rs = st.executequery(sql); while(rs.next()){ int id = rs.getint(_id); string name = rs.getstring(name); string class1 = rs.getstring(class); system.out.println(id=+id+ name=+name+ class1=+class1); } }catch(exception e){ e.printstacktrace(); } if(rs != null) { try { rs.close(); } catch (sqlexception e) { e.printstacktrace(); } } if(st != null) { try { st.close(); } catch (sqlexception e) { e.printstacktrace(); } } if(conn != null) { try { conn.close(); } catch (sqlexception e) { e.printstacktrace(); } } }}
我们可以通过这种方式来锻炼写sql语句