学习笔记5



mysql与java的连接

方法/步骤

1. 首先要安装mysql,java,eclipse,JDK

   
   

2. 先创建数据库：

   CREATE DATABASE SCUTCS;

   接着，创建表：

   CREATE TABLE STUDENT

   (

   SNO CHAR(7) NOT NULL,

      SNAME VARCHAR(8) NOT NULL,

      SEX CHAR(2) NOT NULL,

      BDATE DATE NOT NULL,

      HEIGHT DEC(5,2) DEFAULT 000.00,

      PRIMARY KEY(SNO)

   );

   然后插入数据，可以用SQL语句insert into <表名> values           (value1, value2, ...);

   
   
3. 访问MySQL数据库。

   import java.sql.*;

   public class JDBCTest {

   public static void main(String[] args){

              // 驱动程序名           String driver = "com.mysql.jdbc.Driver";

              // URL指向要访问的数据库名scutcs           String url = "jdbc:mysql://127.0.0.1:3306/scutcs";

              // MySQL配置时的用户名           String user = "root";              // MySQL配置时的密码           String password = "root";

              try {             // 加载驱动程序            Class.forName(driver);

               // 连续数据库            Connection conn = DriverManager.getConnection(url, user, password);

               if(!conn.isClosed())              System.out.println("Succeeded connecting to the Database!");

               // statement用来执行SQL语句            Statement statement = conn.createStatement();

               // 要执行的SQL语句            String sql = "select * from student";

               // 结果集            ResultSet rs = statement.executeQuery(sql);

               while(rs.next())              // 选择sname这列数据             name = rs.getString("sname

                // 输出结果             System.out.println(rs.getString("sno") + "\t" + name);            }

               rs.close();            conn.close();

              } catch(ClassNotFoundException e) {

               System.out.println("Sorry,can`t find the Driver!");             e.printStackTrace();

              } catch(SQLException e) {

               e.printStackTrace();

              } catch(Exception e) {

               e.printStackTrace();

              } } }