Java连接Sql Servers数据库

待我称王封你为后i 2022-05-13 12:34 228阅读 0赞

1.首先，将数据库驱动jar包导入到lib目录，sqljdbc41.jar

[https://download.csdn.net/download/cc1969281777/10663001][https_download.csdn.net_download_cc1969281777_10663001]

2.创建工具类

package utils;
    import java.sql.Connection;
    import java.sql.DriverManager;
    public class JdbcUtils {
        //驱动路径
    	private static final String DBDRIVER="com.microsoft.sqlserver.jdbc.SQLServerDriver";
    	//数据库地址
    	private static final String DBURL="jdbc:sqlserver://localhost:1433;DataBaseName=ConstructionDB";
    	//数据库登录用户名
    	private static final String User="sa";
    	//密码
    	private static final String Password="123";
    	//数据库连接
    	public static Connection conn=null;
    	public static Connection getConnection(){
    		try{
    			//注册驱动
    			Class.forName(DBDRIVER);
    			//获取连接
    			conn=DriverManager.getConnection(DBURL,User,Password);
    		}
    		catch(Exception e){
    			e.printStackTrace();
    		}
    		//返回连接
    		return conn;
    	}
    }

3.创建dao类

使用JDBCUtils工具，首先导入jar包，commons-dbutils-1.7.jar

[https://download.csdn.net/download/cc1969281777/10663022][https_download.csdn.net_download_cc1969281777_10663022]

package dao;
    import java.sql.Connection;
    import java.sql.SQLException;
    import java.util.List;
    
    import org.apache.commons.dbutils.QueryRunner;
    import org.apache.commons.dbutils.handlers.BeanListHandler;
    
    import enties.Project;
    import utils.JdbcUtils;
    public class ProjectDao {
    
    	public static List<Project> getAll() throws SQLException{
    		Connection conn=JdbcUtils.getConnection();
    		QueryRunner qr=new QueryRunner();
    		String sql="select * from T_project";
    		List list=qr.query(conn, sql, new BeanListHandler(Project.class));
    		return list;
    	}
    /*	测试
     * public static void main(String args[]) throws SQLException{
    		List<Project> list=getAll();
    		Project p;
    		for(int i=0;i<list.size();i++){
    			p=list.get(i);
    			System.out.println(p.getProject_id()+"\t"+p.getDeputy_name());
    		}
    	}*/
    
    }

[https_download.csdn.net_download_cc1969281777_10663001]: https://download.csdn.net/download/cc1969281777/10663001
[https_download.csdn.net_download_cc1969281777_10663022]: https://download.csdn.net/download/cc1969281777/10663022