bookconnectionsql.java

从一开始就使用动态提交技术

package bookshop;
import java.sql.*;

public class bookConnectionSql {
	
	public static Connection getConnect()
	{
		Connection con=null;
		try
		{
			Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
			 con=DriverManager.getConnection("jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=bookshop","sa","");

		}catch(Exception e)
		{
			System.out.println(e);
		}
		return con;
	}
}