Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- //package net.codejava.jdbc;
- import java.sql.Connection;
- import java.sql.DatabaseMetaData;
- import java.sql.DriverManager;
- import java.sql.*;
- /**
- * This program demonstrates how to establish database connection to Microsoft
- * SQL Server.
- * @author www.codejava.net
- *
- */
- public class JdbcSQLServerConnection {
- public static void main(String[] args) {
- /*
- Connection conn = null;
- try {
- String dbURL = "jdbc:sqlserver://localhost\\sqlexpress";
- String user = "sa";
- String pass = "secret";
- conn = DriverManager.getConnection(dbURL);
- if (conn != null) {
- DatabaseMetaData dm = (DatabaseMetaData) conn.getMetaData();
- System.out.println("Driver name: " + dm.getDriverName());
- System.out.println("Driver version: " + dm.getDriverVersion());
- System.out.println("Product name: " + dm.getDatabaseProductName());
- System.out.println("Product version: " + dm.getDatabaseProductVersion());
- }
- } catch (SQLException ex) {
- ex.printStackTrace();
- } finally {
- try {
- if (conn != null && !conn.isClosed()) {
- conn.close();
- }
- } catch (SQLException ex) {
- ex.printStackTrace();
- }
- }
- }*/
- try{
- Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
- Connection con=DriverManager.getConnection("jdbc:odbc:university_data");
- String s1="";
- String s2 = "";
- Statement st = con.createStatement();
- String s = " select * from name";
- ResultSet rs = st.executeQuery(s);
- while(rs.next())
- {
- s1= rs.getString(1);
- s2=rs.getString(2);
- System.out.println("User:"+s1);
- System.out.println("pass:"+s2);
- }
- }
- catch(Exception e)
- {
- System.out.println(e);
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement