databaseconn.java

网上书店 源代码和数据库网上书店 源代码和数据库

package com.shop.model.utils;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

public class DataBaseConn {
    public Connection getConnection(){
    	Connection conn=null;
    	String url="jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=bookdev";
    	String userName="sa";
    	String password="sasa";
    	
    	try {
			Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
		} catch (ClassNotFoundException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
    	try {
			conn=DriverManager.getConnection(url,userName,password);
			System.out.println("连接数据库成功.....");
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
    	return conn;
    }
    public static void main(String[] args){
    	DataBaseConn dbUtils=new DataBaseConn();
    	dbUtils.getConnection();
    }
}