I am Using Windows Authentication (Please kept in mind).
As there is no user name and password.
then
why the following code gives me error?
public class Conection
{
public static void main(String a[]) throws ClassNotFoundException, SQLException
{
try
{
String url = "jdbc:sqlserver://localhost\MALIKUSMANNAWAZ:1433;databaseName=ali";
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
Connection conn = DriverManager.getConnection(url);
System.out.println("connection created");
Statement st=conn.createStatement();
String sql="select * from Login_System";
ResultSet rs=st.executeQuery(sql);
while(rs.next())
{
System.out.println("Name: "+rs.getString(1));
//System.out.println("Address : "+rs.getString(2));
}
if(st!=null)
st.close();
if(conn!=null)
conn.close();
}
catch(SQLException sqle)
{
System.out.println("Sql exception "+sqle);
}
}
}
Please Kept in mind that my PC Name is:
MALIKUSMANNAWAZ
using:
Windows Authentication
Database Name:
ali
IDE:
SQL Server 2012
Aucun commentaire:
Enregistrer un commentaire