该楼层疑似违规已被系统折叠 隐藏此楼查看此楼
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
public class a
{
private String dbURL;
private String user;
private String password;
public Connection getConnection()
{
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
return DriverManager.getConnection(dbURL,user,password);
} catch (Exception e) {
// TODO: handle exception
System.out.println(e.toString());
}
return null;
}
public void setURL(String dbURL)
{
this.dbURL=dbURL;
}
public void setUser(String user)
{
this.user=user;
}
public void setPassword(String password)
{
this.password=password;
}
public static void main(String args[])
{
Statement sta;
ResultSet rs;
try {
a driver=new a();
driver.setURL("jdbc:odbc:book");
driver.setUser("sa");
driver.setPassword("sa");
Connection con=driver.getConnection();
sta=con.createStatement();
//String query="select * from Authors";
rs=sta.executeQuery("select * from Authors Where Author_ID='1'");
System.out.println(con.getCatalog());
rs.next();
while(rs.next())
{
System.out.println(rs.getString("Name"));
}
try {
sta.close();
} catch (Exception e) {
// TODO: handle exception
System.out.println(e.toString());
}
} catch (Exception e) {
// TODO: handle exception
System.out.println(e.toString());
}
}
}
java.sql.SQLException: [Microsoft][ODBC SQL Server Driver][SQL Server]第 1 行: ' ' 附近有语法错�