基础jdbc连接数据库

最新推荐文章于 2024-03-20 15:32:42 发布

zds12345sdfs

最新推荐文章于 2024-03-20 15:32:42 发布

阅读量161

点赞数

分类专栏： java jdbc 文章标签： java jdbc

本文链接：https://blog.csdn.net/zds12345sdfs/article/details/80436668

版权

java 同时被 2 个专栏收录

6 篇文章 0 订阅

订阅专栏

jdbc

1 篇文章 0 订阅

订阅专栏

不废话，直接上代码

package com.happy.action;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.List;
import java.util.Vector;

import javax.sql.DataSource;

import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;

import com.happy.model.place_technology;
import com.happy.util.DBtoExcel;


public class test {

	//打印
	public void Printing() throws ClassNotFoundException, SQLException {
	String DRIVER = "com.mysql.jdbc.Driver";  
        String URL = "jdbc:mysql://127.0.0.1:3306/demo?autoReconnect=true&useUnicode=true&characterEncoding=UTF-8;";  
        String USERNAME = "root";  
        String USERPASSWORD = "123456";  
          
        // 连接数据库  
        Class.forName(DRIVER);  
        Connection conn = (Connection) DriverManager.getConnection(URL,USERNAME,USERPASSWORD);  
        PreparedStatement ps = (PreparedStatement) conn.prepareStatement(sql);  
        ResultSet rs = (ResultSet) ps.executeQuery();

        //ApplicationContext ac = new ClassPathXmlApplicationContext("applicationContext.xml");
        //DataSource dataSource = (DataSource) ac.getBean("dataSource");
        //Connection conn = dataSource.getConnection();
        //PreparedStatement ps = conn.prepareStatement(sql);
        //ResultSet rs = ps.executeQuery();
        
	}

	

}