56 lines
2.0 KiB
Java
56 lines
2.0 KiB
Java
|
||
/**
|
||
* 文件名 : JdbcTest.java
|
||
* 版权 : <版权/公司名>
|
||
* 描述 : <描述>
|
||
* @author liliy
|
||
* 版本 : <版本>
|
||
* 修改时间： 2017年3月12日
|
||
* 修改内容： <修改内容>
|
||
*/
|
||
|
||
import java.sql.Connection;
|
||
import java.sql.DriverManager;
|
||
import java.sql.ResultSet;
|
||
import java.sql.Statement;
|
||
|
||
/**
|
||
* <一句话功能简述>
|
||
* <功能详细描述>
|
||
* @author liliy
|
||
* @version [版本号，2017年3月12日]
|
||
* @see [相关类/方法]
|
||
* @since [产品/模块版本]
|
||
*/
|
||
|
||
public class JdbcTest {
|
||
public static void main(String arg[]) {
|
||
try {
|
||
//System.out.print("sleep now");
|
||
//Thread.sleep(1000*10);
|
||
String url = "jdbc:mysql://127.0.0.1:3306/mysql?"
|
||
+ "user=root&password=123123&useUnicode=true&characterEncoding=UTF8&autoReconnect=true&failOverReadOnly=false&useSSL=false";
|
||
Connection con = null; //定义一个MYSQL链接对象
|
||
Class.forName("com.mysql.jdbc.Driver");// 动态加载mysql驱动
|
||
con = DriverManager.getConnection(url); //链接本地MYSQL
|
||
|
||
Statement stmt; //创建声明
|
||
stmt = con.createStatement();
|
||
String selectSql = "SELECT * FROM user";
|
||
ResultSet selectRes = stmt.executeQuery(selectSql);
|
||
while (selectRes.next()) { //循环输出结果集
|
||
String username = selectRes.getString("User");
|
||
System.out.print("\r\n\r\n");
|
||
System.out.print("username:" + username );
|
||
}
|
||
// PreparedStatement pstmt = (PreparedStatement) con.prepareStatement("GRANT USAGE ON *.* TO 'user01'@'localhost' IDENTIFIED BY '123456' WITH GRANT OPTION;");
|
||
stmt.execute("GRANT USAGE ON *.* TO 'user01'@'localhost' IDENTIFIED BY '123456' WITH GRANT OPTION;");
|
||
stmt.close();
|
||
con.close();
|
||
|
||
} catch (Exception e) {
|
||
System.out.print("MYSQL ERROR:" + e.getMessage());
|
||
}
|
||
|
||
}
|
||
} |