源码:
package DB;import java.sql.*;
import javax.sql.*;
import javax.naming.*;public class DBUtils
{
private String url = "jdbc:microsoft:sqlserver://127.0.0.1:1433;User=sa;Password=sa;DatabaseName=j2ee";
private String DriverName = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
private PreparedStatement st = null;
private Statement stmt = null;
private ResultSet rs = null;
private Connection conn = null;
public DBUtils(){}
public void select()
{
try
{
String sql = "select * from User";
Class.forName(DriverName);
conn = DriverManager.getConnection(url);
stmt = conn.createStatement();
rs = stmt.executeQuery(sql);
while(rs.next())
{
String name = rs.getString("name");
String password = rs.getString("password");
System.out.println(name);
System.out.println(password);
}
rs.close();
stmt.close();
conn.close();
}catch(Exception e)
{
System.out.println(e.getMessage());
}
}
public static void main(String []args)
{
DBUtils DB = new DBUtils();
DB.select();
}
}
错误:
[Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]在关键字 'User' 附近有语法错误。
package DB;import java.sql.*;
import javax.sql.*;
import javax.naming.*;public class DBUtils
{
private String url = "jdbc:microsoft:sqlserver://127.0.0.1:1433;User=sa;Password=sa;DatabaseName=j2ee";
private String DriverName = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
private PreparedStatement st = null;
private Statement stmt = null;
private ResultSet rs = null;
private Connection conn = null;
public DBUtils(){}
public void select()
{
try
{
String sql = "select * from User";
Class.forName(DriverName);
conn = DriverManager.getConnection(url);
stmt = conn.createStatement();
rs = stmt.executeQuery(sql);
while(rs.next())
{
String name = rs.getString("name");
String password = rs.getString("password");
System.out.println(name);
System.out.println(password);
}
rs.close();
stmt.close();
conn.close();
}catch(Exception e)
{
System.out.println(e.getMessage());
}
}
public static void main(String []args)
{
DBUtils DB = new DBUtils();
DB.select();
}
}
错误:
[Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]在关键字 'User' 附近有语法错误。
t_usert 代表Table
v 代表View呵呵!
String CLASSFORNAME = "";
String url = "jdbc:jtds:sqlserver://localhost:1433/Northwind"; //ExpExt:数据库名
String user = "sa";
String password = "sa";
try {
Class.forName("net.sourceforge.jtds.jdbc.Driver").newInstance();
Connection conn = DriverManager.getConnection(url, user, password);
return conn;
}
给一个简单的连接给你,当然需要一个连接驱动的架包
sun.jdbc.odbc.JdbcOdbcDriver
jdbc:odbc:name 用 COM.ibm.db2.jdbc.net.DB2Driver 连接到 DB2 数据库
一个 DB2 URL 的示例:
jdbc:db2://aServer.myCompany.com:50002/name 用 com.sybase.jdbc.SybDriver连接到 Sybase 数据库
一个 Sybase URL 的示例:
jdbc:sybase:Tds:aServer.myCompany.com:2025 MySQL driver
com.mysql.jdbc.Driver
jdbc:mysql://hostname:3306/dbname?useUnicode=true&characterEncoding=GBK Microsoft SQL Server Driver
com.microsoft.jdbc.sqlserver.SQLServerDriver
jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=WapSvc;User=sa;Password=pwd Informix
com.informix.jdbc.IfxDriver
jdbc:informix-sqli://hostname:1526/dbname:INFORMIXSERVER=informixservername;user=username;password=password Oracle
oracle.jdbc.driver.OracleDriver
jdbc:oracle:thin:@hostname:1521:<SID> Postgresql
org.postgresql.Driver
jdbc:postgresql://localhost/soft Apache Derby/Java DB
org.apache.derby.jdbc.ClientDriver
jdbc:derby://localhost:1527/databaseName;create=true Access 是通过 ODBC 连接的. Excel 也可以. 甚至可以动态构造连接字符串: 这样可以直接连接到 Access 数据库文件. jdbc:odbc:DRIVER={Microsoft Access Driver (*.mdb)};DBQ=c:\mydata.mdb 类似的 Excel 文件也可以用类似方法: jdbc:odbc:Driver={Microsoft Excel Driver (*.xls)};DBQ=.\mydata.xls
user是关键字
见表用的时候[user]