/*
忙了一下午，終于搞好了，我的mysql5.0是for windows
請(qǐng)先在my.ini這個(gè)文件里面吧default-character-set=gbk
再建庫(kù)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)
?{
??
?}
}
}