日常笔记（JDBC连接+AJax+前端页面的方法）

Jdbc连接

public class SqlServerCon extends MyConnection 
{
    public Connection connection = null;
    public PreparedStatement ps= null;
    public SqlServerCon() 
    {
        Properties pro=new Properties(); 
   try {
        String path =   Thread.currentThread().getContextClassLoader()
            .getResource("").getPath()+"database.properties";       
            FileInputStream inputFile = new FileInputStream(path);
            pro.load(inputFile);
            inputFile.close();
            String sqlServerurl = pro.get("SqlServerjdbcurl").toString();
            String sDataBase = pro.getProperty("SDataBase").toString();
            //;databaseName=manager
            String connectionString = sqlServerurl + ";" + "databaseName=" + sDataBase;
            String sUserName = pro.getProperty("SUserName").toString();
            String sPassword = pro.getProperty("SPassword").toString();
            Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
            connection = (Connection) DriverManager.getConnection(connectionString,sUserName,sPassword);        
        } catch (Exception e) {
            e.printStackTrace();
        }
        }
           // 预命令
            public PreparedStatement ExecuteSql(String sql)
            {           
         try {
    ps = (PreparedStatement)connection.prepareStatement(sql);       
            } catch (SQLException e) {          
            e.printStackTrace();
            }
                return ps;
            }   
          // 关闭连接
        public void CloseConnection()
            {
            try {
                this.connection.close();
                this.ps.close();
                } catch (SQLException e) {
            e.printStackTrace();
                }               
            }

（ajxa使用）初始化项目+遍历Json数据+清空数据表的数据

$(function(){
    $.ajax({
        type: 'post',
        url: 'initProjectList',
        data:{},
        dataType:'json',
        success: function(data)
         {
        //清空数据表格的数据
$('#projectInfoTable').datagrid('loadData', {total: 0, rows: []});
        var d = $.parseJSON(data); 
        //遍历JSON数据              
        for(var p in d)
        {           
            //JSON 封装       
         var version = "";
         if(d[p].version == -1)
        {
            version = "" ;
        }
        else
        {
           version = d[p].version;
         //输出语句  
        console.info("version: " + d[p].version);
            }
            var project_row = {
            'projectId':d[p].projectId,
            'versionId':d[p].versionId,
            'projectName':d[p].name,
            'productVersion':version,
            'Operator':d[p].operator,
            'OperatorTime':d[p].operateTime,
            'remark':d[p].remark
            }
     //数据表格行添加          
    $("#projectInfoTable").datagrid("appendRow", project_row); 
           }        
           },   
        error:function()
        {   
        if (data.indexOf("error:") >= 0)
            {
            alert(data.substr(data.indexOf(":") +1));
            return;
            }   
        }
    }); 
  //选择当前行的信息    
    var  row = $("#projectInfoTable").datagrid("getSelected");     
  //上一行赋值
  window.parent.showTab("参数输入", projectId + ",-1");
  //采用正则表达式获取地址栏参数  
function GetQueryString(name)  {
     var reg = new RegExp("(^|&)"+ name +"=([^&]*)(&|$)");
     var r = window.location.search.substr(1).match(reg);
     if(r!=null)return  unescape(r[2]); return null;
  }
$(function()
{
    var id = GetQueryString("projectId");
    var projectId = id.substr(0, id.indexOf(","));
    computingVersionId = id.substr(id.indexOf(",") + 1);
}