Java连接MySql数据库简单实例

一、代码

import java.sql.*;

public class mysqlConnector {
    private static final String ip = ;10.123.123.123;;

    private static final int port = 3306;
    private static final String username = ;myname;;
    private static final String password = ;mypass;;
    private static final String dbname = ;mydbname;;
    private static final String sql = ;select * from mytable limit 10;;

    public static void main(String[] args) {
        Connection con;
        //jdbc驱动
        String driver=;com.mysql.jdbc.Driver;;
        String url=;jdbc:mysql://;;ip;;:;;port;;/;;dbname;
        try {
            //注册JDBC驱动程序
            Class.forName(driver);
            //建立连接
            con = DriverManager.getConnection(url, username, password);
            if (!con.isClosed()) {

                System.out.println(;数据库连接成功;);
                PreparedStatement ps = con.prepareStatement(sql);
                ResultSet resultSet = ps.executeQuery();
                while(resultSet.next()){
                    System.out.println(resultSet.getString(1));
                }
                System.out.println(;success;);

            }
            con.close();
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
            System.out.println(;数据库驱动没有安装;);
        } catch (SQLException e) {
            e.printStackTrace();
            System.out.println(;数据库连接失败;);
        } catch (Exception e) {
            e.printStackTrace();
            System.out.println(;Exception 报错;);
        }
    }


}

二、需要的jar包

mysql-connector-java-5.1.35.jar

三、使用方法

1.修改代码里的mysql相关ip、账号、密码等;修改要测试的sql语句
2.把这个打成jar包;部署到服务器上执行;就可以连接到mysql数据库、执行编写的sql语句了。