java与mysql
来源:互联网 发布:端口在线扫描 编辑:程序博客网 时间:2024/06/14 18:28
import java.io.IOException;
import java.io.InputStream;
import java.sql.SQLException;
import java.util.Properties;
import org.junit.Test;
import com.mysql.jdbc.Connection;
import com.mysql.jdbc.Driver;
public class DBTest
{
/*public static void main(String[] args)
{
Driver driver = new Driver();
String url = "jdbc:mysql://192.168.52.128:3306/mysqltest";
Properties info = new Properties();
info.put("user", "root");
info.put("password", "123456");
//Connection connection;
try {
//connection = getConnectionInfo();
//System.out.println(connection);
//connection.close();
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}*/
@Test
public void Test()
{
//System.out.println(getConnectionInfo());
Connection connection = null;
connection = getConnectionInfo();
if(connection != null)
{
System.out.println(connection);
try {
connection.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
else
{
System.out.println("获取连接失败");
}
}
public Connection getConnectionInfo()
{
String driverClass = null;
String jdbcUrl = null;
String user = null;
String password = null;
//读取配置文件
InputStream in = getClass().getClassLoader().getResourceAsStream("db.properties");
Properties pro = new Properties();
try {
pro.load(in);
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
return null;
}
driverClass = pro.getProperty("driver");
jdbcUrl = pro.getProperty("jdbcUrl");
user = pro.getProperty("user");
password = pro.getProperty("password");
//System.out.println("driver="+driverClass+"\njdbcUrl="+jdbcUrl+"\nuser="+user+"\npassword="+password);
Driver driver;
try {
driver = (Driver) Class.forName(driverClass).newInstance();
} catch (InstantiationException e) {
// TODO Auto-generated catch block
e.printStackTrace();
return null;
} catch (IllegalAccessException e) {
// TODO Auto-generated catch block
e.printStackTrace();
return null;
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
return null;
}
//System.out.println(driver);
Properties info = new Properties();
info.put("user", user);
info.put("password", password);
Connection connection = null;
try {
connection = (Connection)driver.connect(jdbcUrl, info);
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
return null;
}
return connection;
}
}
import java.io.InputStream;
import java.sql.SQLException;
import java.util.Properties;
import org.junit.Test;
import com.mysql.jdbc.Connection;
import com.mysql.jdbc.Driver;
public class DBTest
{
/*public static void main(String[] args)
{
Driver driver = new Driver();
String url = "jdbc:mysql://192.168.52.128:3306/mysqltest";
Properties info = new Properties();
info.put("user", "root");
info.put("password", "123456");
//Connection connection;
try {
//connection = getConnectionInfo();
//System.out.println(connection);
//connection.close();
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}*/
@Test
public void Test()
{
//System.out.println(getConnectionInfo());
Connection connection = null;
connection = getConnectionInfo();
if(connection != null)
{
System.out.println(connection);
try {
connection.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
else
{
System.out.println("获取连接失败");
}
}
public Connection getConnectionInfo()
{
String driverClass = null;
String jdbcUrl = null;
String user = null;
String password = null;
//读取配置文件
InputStream in = getClass().getClassLoader().getResourceAsStream("db.properties");
Properties pro = new Properties();
try {
pro.load(in);
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
return null;
}
driverClass = pro.getProperty("driver");
jdbcUrl = pro.getProperty("jdbcUrl");
user = pro.getProperty("user");
password = pro.getProperty("password");
//System.out.println("driver="+driverClass+"\njdbcUrl="+jdbcUrl+"\nuser="+user+"\npassword="+password);
Driver driver;
try {
driver = (Driver) Class.forName(driverClass).newInstance();
} catch (InstantiationException e) {
// TODO Auto-generated catch block
e.printStackTrace();
return null;
} catch (IllegalAccessException e) {
// TODO Auto-generated catch block
e.printStackTrace();
return null;
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
return null;
}
//System.out.println(driver);
Properties info = new Properties();
info.put("user", user);
info.put("password", password);
Connection connection = null;
try {
connection = (Connection)driver.connect(jdbcUrl, info);
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
return null;
}
return connection;
}
}
0 0
- java与mysql相连
- java与MySQL连接
- mysql与java
- java与mysql连接
- java与mysql
- mysql 与 java
- MySql与Java数据类型转换
- mysql与java的连接
- MySql与Java 数据类型转换
- Java与MySQL数据库编程
- mysql 与 java数据类型对应
- mysql 与 java的连接
- mysql 与java时间类型
- java 与mysql的连接
- MySql类型与Java类型
- Java与MySQL数据库初步
- Mysql与Java类型转换
- java 与mysql交互乱码解决之道
- 关于问题short s1 = 1; s1 = s1 + 1;出现编译错误,而 short s1 = 1; s1 += 1;不出现编译错误。
- 回调函数
- ios利用短信SKD实现短信验证(使用mob网站提供的免费接口)
- 找到含有n个不同字符的子串的最大长度
- Codeforces Round #375 (Div. 2) B. Text Document Analysis(字符串处理,简单题目)
- java与mysql
- 投资分析框架
- 10.2弱校题解
- [LeetCode]--136. Single Number
- 【微信开发】-发送位置获取周边信息, 主要代码在private function receiveLocation($object)
- 括号匹配
- springmvc请求问题
- CSS3利用@font-face使用自定义字符和图标
- 396. Rotate Function