Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public static String Server="192.168.0.26:1433";
- public static String DataBase="TEST_CON";
- public static String Username="sa";
- public static String Password="12345678";
- public static Connection Abrir() throws ClassNotFoundException, SQLException, InstantiationException, IllegalAccessException
- {
- Class.forName("net.sourceforge.jtds.jdbc.Driver").newInstance();
- Connection conn = DriverManager.getConnection("jdbc:sqlserver://"+conexao.Server+ ";databaseName="+conexao.DataBase,conexao.Username,conexao.Password);
- return conn;
- }
- public int Testar() throws ClassNotFoundException, SQLException, InstantiationException, IllegalAccessException {
- int u = 0;
- Connection conn = conexao.Abrir();
- Statement MW = conn.createStatement();
- ResultSet rs = MW.executeQuery("SELECT*From Tb_utilizador order by Nome");
- while (rs.next()) {
- u = 1;
- }
- return u;
- }
- try {
- b.Testar();
- }
- catch (ClassNotFoundException e)
- {
- Mensagem("Erro1",""+e.getMessage());
- }
- catch (InstantiationException e)
- {
- Mensagem("Erro2",""+e.getMessage());
- }
- catch (IllegalAccessException e)
- {
- Mensagem("Erro3",""+e.getMessage());
- }
- catch (SQLException e)
- {
- Mensagem("Erro4",""+e.getMessage());
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement