我以Java连oracle为例子,
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection con= DriverManager.getConnection("jdbc:oracle:thin:@127.0.0.1:1521:accp", "scott", "tiger");
Statement stmt = con.createStatement();
ResultSet r= stmt.executeQuery("SELECT * FROM emp");
while(r.next()){
System.out.println(r.getString(1));
}
oracle的驱动在oracle的目录中,其中scott是用户名,tiger是密码
下面是SQL Server
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver") ;
Connection cn = DriverManager.getConnection("jdbc:microsoft:sqlserver://127.0.0.1:1433;databasename=pubs","sa","") ;
另外,汉字乱码问题是WEB编码协议的问题