用jdbc连接sqlserver2000数据库

 

用jdbc连接sqlserver2000数据库

---

1。首先安装jdbc驱动在服务器上，
2。把msbase.jar ,mssqlserver.jar and msutil.jar包含在编辑项目中
3。import lotus.domino.*;
import java.sql.Connection;
import java.sql.*;
import java.sql.DriverManager;

public class JavaAgent extends AgentBase {
public void NotesMain() {
try {

Session session = getSession();
AgentContext agentContext = session.getAgentContext();
//System.out.println("aaaaaaaaa");
Document doc = agentContext.getDocumentContext();

// (Your code goes here)
//add jdbc driver
Connection conn=null;
Statement stmt=null;
ResultSet rs=null;
//String strdate="2006-11-3";
//System.out.println("11111111");

try{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
conn=DriverManager.getConnection("jdbc:microsoft:sqlserver://192.168.1.2:1433;databaseName=supplies","sa","123456");
stmt=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
String strSQL="select p.patternname,sum(i.account)as num from tabinstore i inner join tabpatterncode p on i.patterncode=p.patterncode where i.indate='2006-11-3' and i.storelocationid='1001' group by p.patternname";

rs=stmt.executeQuery(strSQL);

while(rs.next()){
String companyName=rs.getString("num");
System.out.println(companyName);
}
//dim v
//Database db=agentContext.getCurrentDatabase();
doc.replaceItemValue("todaykc","123456");
doc.save(false,false);
}catch(Exception e){System.out.println(e);}
finally{
try{
if(rs!=null){rs.close();}
if(stmt!=null){stmt.close();}
if(conn!=null){conn.close();}
}catch(SQLException sqle){System.out.println(sqle);}
}

} catch(Exception e) {
e.printStackTrace();
}
}
}