简单的数据库连接BEAN,编译出错!大家帮忙啊!
写了一个简单的数据库连接Bean,编译的时候出错!
package jdbcbean;
import java.sql.*;
public class jdbc
{
public jdbc()
{
Connection conn = null ;
String re = "" ;
String strIP = "127.0.0.1" ;
String strDatabaseName="jbook";
String strUser = "sa" ;
String strPass = "123" ;
}
public Connection getConn()
{
try
{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
String url ="jdbc:microsoft:sqlserver://";
url+=strIP;
url+=":1433";
url+="DatabaseName=";
url+=strDatabaseName;
url+=",";
url+=strUser;
url+=",";
url+=strPass;
conn=DriverManager.getConnection(url);
}
catch(Exception e)
{
e.printStackTrace();
}
return this.conn ;
}
}
哪里有错啊?