用Java实现数据库应用系统.docx

文档介绍：用Java实现数据库应用系统(2)实现连接SQLServer的连接工厂,;publicfinalclassSqIServerConnectionFactoryextendsCormectionFactory{privatefinalStringdbDriver=.”;privateStringhost;〃主机privateintport;//端口privateStringdatabaseName;//Sql数据库名称publicSqIServerConnectionFactory(){(dbDriver);}★***@paramhost数据库所在的主机名:如"localhost"***@paramportSQL服务器运行的端口号,如果使用缺省值1433,传入一个负数即可***@paramdatabaseName数据库名称***@paramuserName用户名***@parampassword口令*/publicSqlServerConnectionFactory(Stringhost,intport,StringdatabaseName,StringuserName,Stringpassword){(host);(port);(databaseName);(userName);(password);init();}privatevoidinit(){(dbDriver);(f,jdbc:microsoft:sqlserver://H+()+n:H+newlnteger(port).toString()+11;DatabaseName=H+());//(,,jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=demo,t);publicvoidsetHost(Stringhost){〃处理主机名称if((host==null)||((,M,))||(())||('locar*))){host="localhost";}intindex=("〃",0);if(index==0){host=(2);〃去掉前面的”//”}index=(”〃",0);if(index>=0){try{thrownewException(MSQLServer主机名参数错误!”);}catch(Exceptionex){}}=host;}publicvoidsetPort(intport){*缺省端口1433*/if(p