Java连接MySql数据库入门操作

1、这是连接后进行一些简单操作后的结果:Succeeded connecting to the Database!学号姓名2011001张三2011002李四2011003王五先去下载MySql并安装好。安装 MySql的方法在然后下载jdbc驱动。下载好了解压即可。把那个zip文件也放到解压后的目录中，方便管理使用。MyPackage mysql-connectorjava-5KlJ4 |整 共享 刻录新建力供名称修改E期1/ THdocs2011/2/3 2142文科i. snc2011/2/3 2142文科=| buildjotiI2010/12/6 19:29XM CHANGES2010/

2、12/6 19:29文科 COPYING2010/12/6 19:29 mysql-connertorjava-5.L14.zip2010/12/7 2:50好J52 mysql-connector-java-S.l.li-bin.jar2010/12/6 19:29Exe,README2010/12/6 19:29LJ READ M Etxt2D1O/12/6 19:29文承我使用的是eclipse,我要导入包，先进行一些设置。安装jre。iypt filter tfrxtInstalled JREsGeneralAntHelpInstall/Update JavaAppearance Bu

3、ild Path Code Style Compiler Debug EditorInstalled JREs添加外部jar文件Add, remove or edit J RE definitions. By default the checked J RE is added to the build path ot newly created Java projects.NameLocationAddrr.ItC:Pragram Fi 1 esJavajdkl.6.0_211 Edit圈 lAjdkl. 6.021 (1JQPrcgram Fi 1avaj d kl. 6.0_21Dupli

4、cate.RemoveS&archhM.Installed JREs:Add External JARs»fJavadoc Location.打开刚才解压得到的jar文件。打开的效果。rirf-W 'P"i«ia E:Softwa reJavaMyPackag en et.mindview.jar<-oio E:Softv<3reJ3Y3MyPackagenny5ql-connertof-jav3-5.1.14mysqnrFinish使用mysql创建数据库，进行测试。mysql> use test;Database change

5、d mysql> create table student ( -> sno char(7) not null, -> sname varchar(8) not null, -> sex char(2) not null -> );Query OK, 0 rows affectedmysql> insert into student values-> (2011001,'张三','男');Query OK, 1 row affectedmysql> insert into student values-> (

6、2011002,'李四','男');Query OK, 1 row affectedmysql> insert into student values-> (2011003,'王五','男');Query OK, 1 row affected mysql> select * from student; +| sno | sname | sex | +| 2011001 |张三 |男| 2011002 |李四 |男| 2011003 |王五 |男|+3 rows in setmysql>编码测试。输入下面源代

7、码：import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;public class JDBCTest (public static void main(String args)( try (/加载驱动程序Class. forName ("com.mysql.jdbc.Driver");/ URL指向要访问的数据库名testString url ="

8、;jdbc:mysql:/:3306/test”/ MySQL 配置时的用户名 String user = "root" ;/ MySQL 配置时的密码 String password ="123456"/连续数据库Connection connection = DriverManager.getConnection (url,user, password);if (!connection.isClosed()System. out .println( "Succeeded connecting to the Database

9、!");/ statement用来执行SQL语句Statement statement = connection.createStatement();/要执行的SQL语句 String sql = "select * from student"/执行SQL语句并返回结果集ResultSet rs = statement.executeQuery(sql);System. out .println( "学号"+ "t"+ "姓名");String name = null ; while (rs.next()

10、 (/ 选择sname这列数据name = rs.getString("sname");/输出结果System. out .println(rs.getString("sno" ) + "t"+ name);/关闭结果集rs.close();/关闭连接connection.close(); catch (ClassNotFoundException e) ( System. out .println( "Sorry,can't find the Driver!");e.printStackTrace(); catch (