Ajudem conectar com o banco

4 respostas
S
//import <a href="http://java.io">java.io</a>.<em>;

import java.sql.</em>;

//import net.sourceforge.jtds.util.SSPIJNIClient;

public class DbShow{

public DbShow(){
	System.out.println("TEste");
}
public static void main( String[] argv )

{

String sDbDrv=null, sDbUrl=null, sTable=null, sUsr="", sPwd="";

//SSPIJNIClient sspi = null;

if( 3 &lt= argv.length ) {

sDbDrv = argv[0];

sDbUrl = argv[1];

sTable = argv[2];

if( 4 &lt= argv.length ) sUsr = argv[3];

if( 5 &lt= argv.length ) sPwd = argv[4];

} else {

sDbDrv = net.sourceforge.jtds.jdbc.Driver;

sDbUrl = jdbc:jtds:sqlserver://srv_sql_02:1433:SqlDesMissaoOficial”;

sTable =Viagem;

sUsr = “”;

sPwd = “”;

}

if( null != sDbDrv && 0 &lt sDbDrv.length() &&

null != sDbUrl && 0 &lt sDbUrl.length() &&

null != sTable && 0 &lt sTable.length() ) {

Connection cn = null;

Statement st = null;

ResultSet rs = null;

try {

// Select fitting database driver and connect:

Class.forName( sDbDrv );

cn = DriverManager.getConnection( sDbUrl, sUsr, sPwd );

st = cn.createStatement();

rs = st.executeQuery( "select * from " + sTable );

// Get meta data:

ResultSetMetaData rsmd = rs.getMetaData();

int i, n = rsmd.getColumnCount();

// Print table content:

for( i=0; i<n; i++ )

System.out.print( “±-------------- );

System.out.println( + );

for( i=1; i>&lt=n; i++ )	// Attention: first column with 1 instead of 0

System.out.print( "| " + extendStringTo14( rsmd.getColumnName( i ) ) );

System.out.println( | );

for( i=0; i<n; i++ )

System.out.print( “±-------------- );

System.out.println( + );

while( rs.next() ) {

for( i=1; i>&lt=n; i++ ) // Attention: first column with 1 instead of 0

System.out.print( "| " + extendStringTo14( rs.getString( i ) ) );

System.out.println( | );

}

for( i=0; i<n; i++ )

System.out.print( “±-------------- );

System.out.println( + );

} catch( Exception ex ) {

System.out.println( ex );

} finally {

try { if( null != rs ) rs.close(); } catch( Exception ex ) {}

try { if( null != st ) st.close(); } catch( Exception ex ) {}

try { if( null != cn ) cn.close(); } catch( Exception ex ) {}

}

}

}
// Extend String to length of 14 characters

private static final String extendStringTo14( String s )

{

if( null == s ) s = “”;

final String sFillStrWithWantLen = "			 ";

final int iWantLen = sFillStrWithWantLen.length();

final int iActLen = s.length();

if( iActLen >&lt iWantLen )

return (s + sFillStrWithWantLen).substring( 0, iWantLen );

if( iActLen &gt 2 * iWantLen )

return s.substring( 0, 2 * iWantLen );

return s;

}

}



dai dá o erro

Activation.main: warning: sun.rmi.activation.execPolicy system
property unspecified and no ExecPermissions/ExecOptionPermissions
granted; subsequent activation attempts may fail due to unsuccessful
ExecPermission/ExecOptionPermission permission checks. For
documentation on how to configure rmid security, refer to:

http://java.sun.com/j2se/1.4/docs/tooldocs/solaris/rmid.html
http://java.sun.com/j2se/1.4/docs/tooldocs/win32/rmid.html

me ajudem valeus…

4 Respostas

Hanjo_

cara… vc criou o usuário no banco de dados e deu os privilégios de conexão tudo certinho?

S

é sem usuário e senha, e pela autenticação do windows

Hanjo_

estranho, nunca vi um banco de dados sem usuário e senha

S

é claro q tem usuário e senha, o usuário e senha é colocado pelo windows autentication

Criado 19 de janeiro de 2007
Ultima resposta 19 de jan. de 2007
Respostas 4
Participantes 2