- 博客(0)
- 资源 (16)
- 收藏
- 关注
jdbc连接数据库通用类
SqlHelper.java连接数据库通用类...
package org.jdbc.com.util;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class SqlHelper {
/**
* 设置单例
*/
public static SqlHelper instance = new SqlHelper();
/**
* 设置单例的一个实例方法
*
* @return
*/
public static SqlHelper getInstance() {
if (instance == null) {
synchronized (SqlHelper.class) {
instance = new SqlHelper();
}
}
return instance;
}
/**
* 得到MySql连接
*
* @return
*/
public static Connection getMySqlConnection() {
Connection conn = null;
String url = "jdbc:mysql://127.0.0.1:3306/jdbc?useUnicode=true&characterEncoding=utf-8";
String user = "root";
String password = "root";
String driver="com.mysql.jdbc.Driver";
try {
Class.forName(driver);
conn = DriverManager.getConnection(url, user, password);
} catch (Exception e) {
System.out.println("连接数据库出现异常" + e.getMessage());
}
return conn;
}
/**
* 得到MMSQL连接
* @return
*/
public static Connection getMMSQLConnection() {
String url = "jdbc:sqlserver://localhost:1433;DatabaseName=jdbc";
String user = "sa";
String password = "sa";
String Driver="com.microsoft.sqlserver.jdbc.SQLServerDriver";
Connection conn = null;
try {
Class.forName(Driver);
conn = DriverManager.getConnection(url, user, password);
} catch (Exception e) {
System.out.println("连接数据库出现异常" + e.getMessage());
}
return conn;
}
/**
* 得到Oracle连接
* @return
*/
2012-12-18
ie上脚本js、css调试工具(共5个)
Microsoft Script Debugger 2. Companion.JS 3. IE Developer Toolbar 4. Fiddler 5.HttpWatch
2012-06-14
WinForm实例WinForm实例WinForm实例
WinForm实例WinForm实例WinForm实例WinForm实例WinForm实例WinForm实例WinForm实例
2009-02-16
AjaxMvc AjaxMvc net 应用。
AjaxMvc net 应用。AjaxMvc net 应用。AjaxMvc net 应用。AjaxMvc net 应用。AjaxMvc net 应用。
2009-02-16
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人