Domino中Java代理连接mysql数据库.doc

Domino访问Mysql数据库JAVA代理访问使用Java代理库接Mysql，其与Java访问Mysql数据库大体上类似，使用JDBC进行数据库连接，但有一点区别，就是Java代理有安全性等级的设置。所以，使用JAVA代理访问Mysql时有以下几点需要注意：1、 需要将与Mysql对应的连接驱动拷贝至domino服务器程序目录下的jvm/lib/ext下（也可以将其拷贝至服务器的其它目录，并在notes.ini里做对应的配置），并重启domino服务器。2、 需要修改该domino代理的安全性等级为2级或3级，如下图：3、 如果该代理需要在Notes客户端上运行，需要将Mysql对应的驱动拷贝至Notes目录下的jvm/lib/ext下。数据库添加代码：import lotus.domino.*;import java.sql.*;import java.util.ArrayList;import java.io.PrintWriter;public class JavaAgent extends AgentBase String url = jdbc:mysql:/localhost:3306/mytask;Connection conn=null;Statement statement=null;ResultSet rs=null; /数据库连接public boolean CONN() try Class.forName(com.mysql.jdbc.Driver); conn = DriverManager.getConnection(url, root, mysql); statement = conn.createStatement(); return true; catch(Exception e)return false; /查询 public ResultSet Select(String sql) if(this.CONN() try rs = statement.executeQuery(sql); catch(Exception e) return rs; else return null; /执行Sql语句 public boolean ExcuteSql(String sql) boolean x=false; if(this.CONN() try statement.executeUpdate(sql); x=true; catch(Exception e)e.printStackTrace(); return x; /数据库事务 public boolean ExcuteTrans(ArrayList al) boolean x=false; if(this.CONN() try conn.setAutoCommit(false); for(int i=0;ial.size();i+) String y = al.get(i).toString(); statement.execute(y); mit(); conn.setAutoCommit(true); x=true; catch(Exception e) try conn.rollback(); conn.setAutoCommit(true); catch(Exception ex) return x; public void NotesMain() try Session s = getSession();AgentContext ag = s.getAgentContext();Database db = ag.getCurrentDatabase();/Document doc = db.createDocument();/doc.appendItemValue(Form, showData);Document doc = ag.getDocumentContext();String sql;sql = insert into tasks(deptname,proname,taskname,excctype) values (+doc.getItemValueString(DeptName)+,+doc.getItemValueString(ProName)+,+doc.getItemValueString(TaskName)+,+doc.getItemValueString(ExccType)+);PrintWriter pw = getAgentOutput();boolean result = this.ExcuteSql(sql);if (result) pw.println(alert(增加成功););else pw.println(alert(增加失败);); catch(Exception e) e.printStackTrace();数据库查询代码：import lotus.domino.*;import java.sql.*;import java.util.ArrayList;public class JavaAgent extends AgentBase String url = jdbc:mysql:/localhost:3306/anatast;Connection conn=null;Statement statement=null;ResultSet rs=null; /数据库连接public boolean CONN() try Class.forName(com.mysql.jdbc.Driver); conn = DriverManager.getConnection(url, root, mysql); statement = conn.createStatement(); return true; catch(Exception e)return false; /查询 public ResultSet Select(String sql) if(this.CONN() try rs = statement.executeQuery(sql); catch(Exception e) return rs; else return null; /执行Sql语句 public boolean ExcuteSql(String sql) boolean x=false; if(this.CONN() try statement.executeUpdate(sql); x=true; catch(Exception e)e.printStackTrace(); return x; /数据库事务 public boolean ExcuteTrans(ArrayList al) boolean x=false; if(this.CONN() try conn.setAutoCommit(false); for(int i=0;ial.size();i+) String y = al.get(i).toString(); statement.execute(y); mit(); conn.setAutoCommit(true); x=true; catch(Exception e) try conn.rollback(); conn.setAutoCommit(true); catch(Exception ex) return x; public void NotesMain() try Session s = getSession();AgentContext ag = s.getAgentContext();Database db = ag.getCurrentDatabase();/Document doc = db.createDocument();/doc.appendItemValue(Form, showData);Document doc = ag.getDocumentContext();ResultSet rs = this.Select(select taskname,deptname,count(*) as num1 from tasks group by taskname,deptname);String result = ;result = result + 流程环节部门3个月;while(rs.next()result = result + ;result =