Service Temporarily Unavailable
The server is temporarily unable to service your request due to maintenance downtime or capacity problems. Please try again later.
Apache/2.0.55 (Win32) Resin/3.0.17 Server at localhost Port 80 <<more
现在的GUI tools好多啊！！！呵呵，当然Mysql也不逊色，今天用了一下，哇！好方便！！！很多的复杂操作不再要握们手动去操作了！！呵呵，还有Mysql 的UML工具哦！！呵呵！！！相信Mysql GUI tools绝对不逊色与其他 的第三方GUI tools!!下载地址:http://www.mysql.org/downloads/gui-tools/5.0.html
赶快去下载哦！！！手动设置编码好麻烦！！！备份/还原一键即可哦！！呵呵带着走也方便
/*
忙了一下午，终于搞好了，我的mysql5.0是for windows
请先在my.ini这个文件里面吧default-character-set=gbk
再建库bo,表mo(id char(6))
*/
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class DbCon {
public static void main(String []argv)
{
try
{
Class.forName("org.gjt.mm.mysql.Driver");
System.out.println("Create Sucess!!");
Connection con=DriverManager.getConnection("jdbc:mysql://localhost/bo?user=root&password=nihaoma&useUnicode=true&characterEncoding=GBK");
System.out.println("Connect Sucess!!");
//ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE
Statement st=con.createStatement();
ResultSet su=st.executeQuery("select * from mo");
while (su!=null && su.next())
{
System.out.println(su.getString("id"));
}
st.execute("insert into mo values('人')");
//System.out.print(ne);
//System.out.println("end...");
}
catch(ClassNotFoundException e)
{
}
catch(SQLException e)
{
}
catch(Exception e)
{
}
}
}