MyEclipse6实战开发讲解入门教程--1安装运行Mysql2CMySQL-Front管理2CJ

MyEclipse6实战开发讲解视频入门1安装运行Mysql,MySQL-Front管理,JDBCHelloWorld开发相关软件:mysql_jdbc.7z2.67MB含Mysql绿色版,MySQL-Front,mysql.jar,建表语句)视频:MyEclipse6_0_1.exe4.87MB17分30秒SQL:CREATETABLE`user`(`id`int(11)NOTNULL,`username`varchar(200)NOTNULL,`password`varchar(20)NOTNULL,`age`int,PRIMARYKEY(`id`))ENGINE=MyISAMDEFAULTCHARSET=GBK;--JDBCDriverName:com.mysql.jdbc.Driver--JDBCDriverURL:jdbc:mysql://hostname/dbname?useUnicode=true&characterEncoding=GBKJava代码:importjava.sql.SQLException;/***第一个JDBC的HelloWorld程序,数据库访问Mysql.*@authorAdministrator*@version0.12007-09-26*/publicclassJDBCHelloWorld{/***@paramargs*@throwsSQLException*/publicstaticvoidmain(String[]args)throwsSQLException{//1.注册驱动try{Class.forName(com.mysql.jdbc.Driver);}catch(ClassNotFoundExceptione){//TODOAuto-generatedcatchblocke.printStackTrace();}//Mysql的驱动//2.获取数据库的连接java.sql.Connectionconn=java.sql.DriverManager.getConnection(jdbc:mysql://localhost/test?useUnicode=true&characterEncoding=GBK,root,null);//3.获取表达式java.sql.Statementstmt=conn.createStatement();//4.执行SQLjava.sql.ResultSetrs=stmt.executeQuery(select*fromuser);//5.显示结果集里面的数据while(rs.next()){System.out.println(rs.getInt(1));System.out.println(rs.getString(username));System.out.println(rs.getString(password));System.out.println();}//执行插入数据的SQL//stmt.executeUpdate(insertintouservalues(2,'中文','345',22));//6.释放资源rs.close();stmt.close();conn.close();}}