Sunday, February 8, 2015

mysql的一些有用操作

source d:/create-company-data-for-MySQL.sql       // 导入sql源文件

下载安装
http://dev.mysql.com/downloads/connector/
打开Eclipse,创建一个项目,

操作:右键点击--->build Path--->add external Archiver...选择jdbc驱动,点击确定。

新建java文件测试
import java.sql.*;

public class DBTest {
    static Connection conn = null;
      
        public static void main(String[] args) {

            // Initialize variables for fields by data type
            String ssn;
            String firstName;
            String lastName;
            String address;
            int dno;

            int linect = 0;

        try {
            // Create a connection to the local MySQL server, with the "company" database selected.
            //        conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/company", "root", "mypassword");
            // Create a connection to the local MySQL server, with the NO database selected.
                    conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/", "root", "");
    
            // Create a SQL statement object and execute the query.
            Statement stmt = conn.createStatement();
        
            // Set the current database, if not already set in the getConnection
            // Execute a SQL statement
//   String chooseDatabase = "use company;"
            stmt.execute("use company;");

            // Execute a SQL query using SQL as a String object
            ResultSet rs = stmt.executeQuery("SELECT ssn, fname, lname, dno FROM employee;");

            // Iterate through the result set using ResultSet class's next() method
            while (rs.next()) {
                // Keep track of the line/tuple count
                linect++;
                // Populate field variables
                
                firstName = rs.getString("fname");
                lastName = rs.getString("lname");
//                dno = rs.getInt("dno");
    ssn = rs.getString("ssn");
    dno = Integer.parseInt(rs.getString("dno"));
            
                // Do something with the data
                System.out.print(linect + ".\t");
                System.out.print(ssn + "\t");
                System.out.print(firstName + "\t");
                System.out.print(lastName + "\t");
                System.out.print(dno + "\t");
                System.out.println();
            } // End while(rs.next())

            // Always close the recordset and connection.
            rs.close();
            conn.close();
            System.out.println("Success!!");
        } 
        catch(SQLException ex) {
            System.out.println("Error in connection: " + ex.getMessage());
        }
    }

   
    }
}

No comments:

Post a Comment