JDBC工具类

最新推荐文章于 2021-04-09 23:27:06 发布

ThinkPet

最新推荐文章于 2021-04-09 23:27:06 发布

阅读量182

点赞数

CC 4.0 BY-SA版权

文章标签： JDBC工具类

本文链接：https://blog.youkuaiyun.com/ThinkPet/article/details/80258304

本文提供了一个Java JDBC数据库操作的实用示例，包括连接数据库、执行查询、参数化查询、执行更新操作以及关闭资源等核心功能。示例使用了Microsoft SQL Server作为数据库，并详细展示了如何通过Java进行数据库交互。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

package com;

import java.sql.*;


public class JDBCUtil {
	private static String strDrive = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
	private static String url = "jdbc:sqlserver://127.0.0.1:1433;DatabaseName=ShopSystem";
	private static String uid = "sa";
	private static String pwd = "123";
	private static Connection conn = null;

	// 注册驱动
	static {
		try {
			Class.forName(strDrive);
		} catch (ClassNotFoundException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}

	// 建立连接
	public static Connection getConnection() {

		try {
			conn = DriverManager.getConnection(url, uid, pwd);
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return conn;
	}

	// Statement查询
	public static ResultSet doQuery(String sql) {
		Statement st = null;
		ResultSet rs = null;
		try {
			st = conn.createStatement();
			rs = st.executeQuery(sql);
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return rs;
	}
	
	
	// PreparedStatement查询
	public static ResultSet doParamQuery(String sql,Object[] params){
		PreparedStatement pst=null;
		ResultSet rs=null;
		try{
			pst=conn.prepareStatement(sql);
			for(int i=0;i<params.length;i++)
			{
				pst.setObject(i+1,params[i]);
			}
			rs=pst.executeQuery();
		}catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return rs;
	}
	
	
	
	//Statement插入，删除，修改
	public static int doUpdate(String sql) {
		int num=0;
		Statement st=null;
		try {
			st = conn.createStatement();
			num=st.executeUpdate(sql);
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			num=-1;
		}
		return num;
	}
	
	
	
	//PreparedStatement插入，删除，修改
	public static int doParamUpdate(String sql,Object[] params){
		int num=0;
		PreparedStatement pst=null;
		try{
			pst=conn.prepareStatement(sql);
			for(int i=0;i<params.length;i++)
			{
				pst.setObject(i+1,params[i]);
			}
			num=pst.executeUpdate();
		}catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			num=-1;
		}
		return num;
	}
	

	// 关闭连接
	public static void closeAll(ResultSet rs, Statement st, Connection conn) {
		try {
			if (rs != null)
				rs.close();
		} catch (SQLException e) {
		} finally {
			try {
				if (st != null)
					st.close();
			} catch (SQLException e) {
			} finally {
				if (conn != null)
					try {
						conn.close();
					} catch (SQLException e) {
						// TODO Auto-generated catch block
						e.printStackTrace();
					}
			}
		}
	}
}