/**
*
*/
package xfhm.controller.project;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
/**
* @author Administrator
* 使用命名管道方式连接 MySQL 只适合在 Windows 系统下用来连接本机的 MySQL ,性能可比一般的TCP/IP方式提升30%~50%。
*/
public class MySQLNamedPipeTester {
public static void main(String[] args) throws Exception {
//加载驱动
Class.forName("com.mysql.jdbc.Driver").newInstance();
//建立连接
Connection conn = DriverManager.getConnection(
"jdbc:mysql://192.168.16.188:3306/XF_HM_Project_Managements?socketFactory=com.mysql.jdbc.NamedPipeSocketFactory",
"root",
"XF_HM_20170121");
PreparedStatement ps = conn.prepareStatement("SELECT * FROM Project_Manage");
ResultSet rs = ps.executeQuery();
while(rs.next()){
System.out.println(rs.getString(1));
}
conn.close();
}
}
*
*/
package xfhm.controller.project;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
/**
* @author Administrator
* 使用命名管道方式连接 MySQL 只适合在 Windows 系统下用来连接本机的 MySQL ,性能可比一般的TCP/IP方式提升30%~50%。
*/
public class MySQLNamedPipeTester {
public static void main(String[] args) throws Exception {
//加载驱动
Class.forName("com.mysql.jdbc.Driver").newInstance();
//建立连接
Connection conn = DriverManager.getConnection(
"jdbc:mysql://192.168.16.188:3306/XF_HM_Project_Managements?socketFactory=com.mysql.jdbc.NamedPipeSocketFactory",
"root",
"XF_HM_20170121");
PreparedStatement ps = conn.prepareStatement("SELECT * FROM Project_Manage");
ResultSet rs = ps.executeQuery();
while(rs.next()){
System.out.println(rs.getString(1));
}
conn.close();
}
}