求一段bean的程序
//数据库的连接
package beans;

import java.sql.*;

public class Conn
{
String DriverName= "com.microsoft.jdbc.sqlserver.SQLServerDriver ";
String Url= "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=Mydata ";
String UserName= "sa ";
String PassWord= " ";

public void setDriverName(String newDriverName) {
DriverName = newDriverName;
}

public String getDriverName() {
return DriverName;
}


public void setUrl(String newUrl) {
Url = newUrl;
}

public String getUrl() {
return Url;
}

public void setUser(String newUser) {
UserName = newUser;
}

public String getUser() {
return UserName;
}

public void setPassword(String newPassword) {
PassWord = newPassword;
}

public String getPassword() {
return PassWord;
}

public Connection getConnection() {
try {
Class.forName(DriverName);
return DriverManager.getConnection(Url, UserName, PassWord);
} catch (Exception e) {
e.printStackTrace();
return null;
}
}

/*public static void main(String[] args)
{

try{

Conn dc = new Conn();
Connectionconn = dc.getConnection();
Statement stmt=conn.createStatement();
ResultSet rs=stmt.executeQuery( "select*from Userlist ");




while(rs.next()){
System.out.print( "名称: "+rs.getString(1));
System.out.print( "\tpassword: "+rs.getString(2));
System.out.println();
}

}catch(Exception e){
e.printStackTrace();
}
}//测试数据库连接*/

}

//数据库的连接
package beans;

import java.sql.*;

public class Conn
{
String DriverName= "com.microsoft.jdbc.sqlserver.SQLServerDriver ";
String Url= "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=Mydata ";
String UserName= "sa ";
String PassWord= " ";

public void setDriverName(String newDriverName) {
DriverName = newDriverName;
}

public String getDriverName() {
return DriverName;
}


public void setUrl(String newUrl) {
Url = newUrl;
}

public String getUrl() {
return Url;
}

public void setUser(String newUser) {

UserName = newUser;
}

public String getUser() {
return UserName;
}

public void setPassword(String newPassword) {
PassWord = newPassword;
}

public String getPassword() {
return PassWord;
}

public Connection getConnection() {
try {
Class.forName(DriverName);
return DriverManager.getConnection(Url, UserName, PassWord);
} catch (Exception e) {
e.printStackTrace();
return null;
}
}

/*public static void main(String[] args)
{




try{

Conn dc = new Conn();
Connectionconn = dc.getConnection();
Statement stmt=conn.createStatement();
ResultSet rs=stmt.executeQuery( "select*from Userlist ");




while(rs.next()){
System.out.print( "名称: "+rs.getString(1));
System.out.print( "\tpassword: "+rs.getString(2));

System.out.println();
}

}catch(Exception e){
e.printStackTrace();
}
}//测试数据库连接*/

}

求大虾帮我用两个程序写一个连接数据库的bean。书上的怎么弄都弄不好
ps:数据库连接已经搞定，就是不会写bean
谢谢了

[解决办法]
package ajax.login;

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

public class DbConnect {
private String strUrl;
private String strUser;
private String strPass;
private String strDB;
private String strDBIP;
public Connection conn;
public DbConnect(){
strUrl= "jdbc:microsoft:sqlserver:// ";
strUser= "sa ";
strPass= "xxx ";
strDB= "webases ";
strDBIP= "127.0.0.1 ";
}
public Connection getConnection(){
strUrl+=strDBIP+ ":1433;DatabaseName= "+strDB;
try{
Class.forName( "com.microsoft.jdbc.sqlserver.SQLServerDriver ").newInstance();
conn=DriverManager.getConnection(strUrl,strUser,strPass);

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

}
}