JDBC连接Azure MySQL DB

来源：互联网发布：centos设置中文编辑：程序博客网时间：2024/06/05 15:23

做个笔记。直接上代码。

package test;import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;public class Mysql2AzureDemo {public static void main(String[] args) throws Exception {Connection conn = null;String sql;// 这里，数据库的URL是重点，若你的用户名是xxxx%xxxx的格式里，需要把%改成%25String url = "jdbc:mysql://xxxx.mysqldb.chinacloudapi.cn:3306/xxxxdb?" + "user=xxxx%25xxxx&password=xxxx&useUnicode=true&characterEncoding=UTF8";try {Class.forName("com.mysql.jdbc.Driver");conn = DriverManager.getConnection(url);Statement stmt = conn.createStatement();sql = "drop table student";int result = stmt.executeUpdate(sql);sql = "create table student(NO varchar(7),name varchar(50),primary key(NO))";result = stmt.executeUpdate(sql);if (result != -1) {sql = "insert into student(NO,name) values('2011001','徐欢欢')";result = stmt.executeUpdate(sql);sql = "insert into student(NO,name) values('2011002','张曦')";result = stmt.executeUpdate(sql);sql = "insert into student(NO,name) values('2011003','王伟')";result = stmt.executeUpdate(sql);sql = "select * from student";ResultSet rs = stmt.executeQuery(sql);System.out.println("学号\t姓名");while (rs.next()) {System.out.println(rs.getString(1) + "\t" + rs.getString(2));}}} catch (SQLException e) {e.printStackTrace();} catch (Exception e) {e.printStackTrace();} finally {conn.close();}}}

阅读全文

0 0