Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
Connection conn = DriverManager.getConnection
("jdbc:microsoft:sqlserver://YourServerName:YourServerPort","username","password");
conn.setCatalog(YourDataBaseName);
Connection conn = DriverManager.getConnection
("jdbc:microsoft:sqlserver://YourServerName:YourServerPort","username","password");
conn.setCatalog(YourDataBaseName);
解决方案 »
- websphere在web.xml中新添加一个servlet配置不生效
- 希望得到各位的帮助,js问题~~
- js
- 自己做的管理系统登陆不稳定是什么原因,谢谢
- 用jspSmart上传文件时,那个方法是设置是否覆盖同名文件的?
- 如何用javamail突破smtp server发送邮件数目的限制?
- 关于pageoffice
- 用jbuilder8.0开发struts(1.0.2),jsp不能保存:com.borland.primetime.util.AssertionException: gbk
- 哪位大神用过Neo4J?实在解决不了了,紧急求助
- 菜鸟提问。
- 不知道问题出在哪里?在jsp里没有错误的,但是在java application却总是出现错误。请指点一下!
- 这个是不是gb2312向unicode转化时产生的错误?
try{
Class.forName ("com.microsoft.jdbc.sqlserver.SQLServerDriver");
java.util.Date d1 = new java.util.Date(); myconn = DriverManager.getConnection(strcon,"sa","");
myconn.setCatalog("alberta");
谢谢!我把程序对应部位改成了这样,但是执行却抛出一个违例,不知道我有没有写错?
JDBC root worry!com.microsoft.jdbc.sqlserver.SQLServerDriver
<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*" %><html>
<head>
<title>
Connect DataBase with JDBC
</title>
</head>
<body>
<h1><center>
Connect DataBase with JDBC</center>
</h1>
<%
String banker_no,name,address;
Connection myconn = null;
Statement stmt = null;
ResultSet rset = null;
%>
<%
String strcon="jdbc:microsoft:sqlserver://xfm:1433";
try{
Class.forName ("com.microsoft.jdbc.sqlserver.SQLServerDriver");
java.util.Date d1 = new java.util.Date();
//连接数据库 myconn = DriverManager.getConnection(strcon,"sa","");
myconn.setCatalog("alberta");
//创建SQL语句对象 stmt = myconn.createStatement();
rset = stmt.executeQuery("select * from banker");
java.util.Date d2 = new java.util.Date();
out.println("数据库连接时间是:"+ (d2.getTime()-d1.getTime()));
%>
<table border=1 width=90%>
<%
while(rset.next())
{
banker_no =rset.getString(1);
name = rset.getString(2);
address = rset.getString(3);
%>
<tr><td width=20%>banker_no:</td><td width=80% ><%=banker_no%></td> </tr>
<tr><td width=20%>Name:</td><td width=80% ><%=name%></td> </tr>
<tr><td width=20%>address:</td><td width=80% ><%=address%></td> </tr>
<%
}
%>
</table>
</form>
</body>
</html>
<%
}catch(Exception e){
System.out.println("JDBC root worry!"+e.getMessage());
}finally{
if( rset!=null)
{
rset.close();
}
if (stmt!=null)
{
stmt.close();
}
if (myconn!=null)
{
myconn.close();
}
}
%>
我下了个MSSQL的驱动程序,ZIP文件,里面全是class文件,我该怎么用?是否解开放到classpath指定的地方就可以了?