JAVA J
来源:互联网 发布:物流排队网络 编辑:程序博客网 时间:2024/05/22 02:23
package com.syc.java;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class DB {
static{
try {
Class.forName("com.mysql.jdbc.Driver");
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
}
public static Connection getConnection(){
Connection conn=null;
try {
conn=DriverManager.getConnection("jdbc:mysql://localhost/logoshop", "root", "root");
} catch (SQLException e) {
e.printStackTrace();
}
return conn;
}
public static void closeConnection(Connection conn){
if(conn!=null){
try {
conn.close();
conn=null;
} catch (SQLException e) {
e.printStackTrace();
}
}
}
public static Statement getStatement(Connection conn){
Statement state=null;
try {
state=conn.createStatement();
} catch (SQLException e) {
e.printStackTrace();
}
return state;
}
public static void closeStatement(Statement state){
if(state!=null){
try {
state.close();
state=null;
} catch (SQLException e) {
e.printStackTrace();
}
}
}
public static PreparedStatement getPreparedStatement(Connection conn,String sql){
PreparedStatement pstate=null;
try {
pstate=conn.prepareStatement(sql);
} catch (SQLException e) {
e.printStackTrace();
}
return pstate;
}
public static PreparedStatement getPreparedStatement(Connection conn,String sql,boolean is){
PreparedStatement pstate=null;
try {
pstate=conn.prepareStatement(sql,Statement.RETURN_GENERATED_KEYS);
} catch (SQLException e) {
e.printStackTrace();
}
return pstate;
}
public static ResultSet executeQuery(Statement state,String sql){
ResultSet reSet=null;
try {
reSet=state.executeQuery(sql);
} catch (SQLException e) {
e.printStackTrace();
}
return reSet;
}
public static void closeResultSet(ResultSet reSet){
if(reSet!=null){
try {
reSet.close();
reSet=null;
} catch (SQLException e) {
e.printStackTrace();
}
}
}
}
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class DB {
static{
try {
Class.forName("com.mysql.jdbc.Driver");
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
}
public static Connection getConnection(){
Connection conn=null;
try {
conn=DriverManager.getConnection("jdbc:mysql://localhost/logoshop", "root", "root");
} catch (SQLException e) {
e.printStackTrace();
}
return conn;
}
public static void closeConnection(Connection conn){
if(conn!=null){
try {
conn.close();
conn=null;
} catch (SQLException e) {
e.printStackTrace();
}
}
}
public static Statement getStatement(Connection conn){
Statement state=null;
try {
state=conn.createStatement();
} catch (SQLException e) {
e.printStackTrace();
}
return state;
}
public static void closeStatement(Statement state){
if(state!=null){
try {
state.close();
state=null;
} catch (SQLException e) {
e.printStackTrace();
}
}
}
public static PreparedStatement getPreparedStatement(Connection conn,String sql){
PreparedStatement pstate=null;
try {
pstate=conn.prepareStatement(sql);
} catch (SQLException e) {
e.printStackTrace();
}
return pstate;
}
public static PreparedStatement getPreparedStatement(Connection conn,String sql,boolean is){
PreparedStatement pstate=null;
try {
pstate=conn.prepareStatement(sql,Statement.RETURN_GENERATED_KEYS);
} catch (SQLException e) {
e.printStackTrace();
}
return pstate;
}
public static ResultSet executeQuery(Statement state,String sql){
ResultSet reSet=null;
try {
reSet=state.executeQuery(sql);
} catch (SQLException e) {
e.printStackTrace();
}
return reSet;
}
public static void closeResultSet(ResultSet reSet){
if(reSet!=null){
try {
reSet.close();
reSet=null;
} catch (SQLException e) {
e.printStackTrace();
}
}
}
}
阅读全文
0 0
- java中的j++/j--
- JAVA J
- java j=j++有感
- java j=j++有感
- java中j=J++综合理解
- J - Java Beans
- 从J#谈起Java
- Java基础.J.1
- java一些细节j
- J. Java Beans
- Java中j=j++与c语言中j=j++的区别
- java.lang.NoClassDefFoundError:j…
- J
- j
- j
- J#
- J
- J
- 传统电路交换网和软交换
- (转)redhat7.3 ssh无法登陆
- search方法
- Mark贴
- c++11 Thread库之使写多线程程序
- JAVA J
- PowerShell 启用AD部门的动态群组邮箱
- 如何成为Python高手
- java二进制,字节数组,字符,十六进制,BCD编码转换
- npm和cnpm的区别
- Echart的学习之路(一)
- leetcode二叉树合并非递归版本
- linux系统下搭建SVN服务器
- Cannot load OCI DLL 87