JSP与数据库的增删改查

package dao;  
  
import java.sql.Connection;  
import java.sql.DriverManager;  
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;  
  
public class baseDao {  
    public static Connection getConnection（）throws Exception{  
//        Class.forName（“com.microsoft.sqlserver.jdbc.SQLServerDriver“）;  
//        String url=“jdbc:sqlserver://127.0.0.1:1433;database=mydb“;  
//        return DriverManager.getConnection（url “sa“ “sa“）; 
    	String driver = “com.mysql.jdbc.Driver“;
        String url = “jdbc:mysql://127.0.0.1:3306/test“;
        String username = “root“;
        String password = “root“;
        Connection conn = null;
        try {
            Class.forName（driver）; //classLoader加载对应驱动
            conn = （Connection） DriverManager.getConnection（url username password）;
        } catch （ClassNotFoundException e） {
            e.printStackTrace（）;
        } catch （SQLException e） {
            e.printStackTrace（）;
        }
        return conn;
    }  
      
    public static void close（ResultSet rsStatement staConnection con）throws Exception{  
        if（rs!=null）{  
                 //关闭结果集  
                rs.close（）;  
        }  
        if（sta!=null）{  
                 //关闭操作句柄  
                 sta.close（）;  
        }  
        if（con!=null）{  
                //关闭链接  
                con.close（）;  
        }  
    }  
}

 属性            大小     日期    时间   名称
----------- ---------  ---------- -----  ----

     文件       1236  2018-04-09 13:31  Project.classpath

     文件        907  2018-04-09 10:26  Project.project

     文件        567  2018-04-09 10:26  Project.settings.jsdtscope

     文件        364  2018-04-09 10:26  Project.settingsorg.eclipse.jdt.core.prefs

     文件        473  2018-04-09 10:26  Project.settingsorg.eclipse.wst.common.component

     文件        345  2018-04-09 10:26  Project.settingsorg.eclipse.wst.common.project.facet.core.xml

     文件         49  2018-04-09 10:26  Project.settingsorg.eclipse.wst.jsdt.ui.superType.container

     文件          6  2018-04-09 10:26  Project.settingsorg.eclipse.wst.jsdt.ui.superType.name

     文件       1491  2018-04-09 13:31  ProjectsrcdaoaseDao.java

     文件       5986  2018-04-11 13:44  ProjectsrcdaoUserInfoDao.java

     文件       1416  2018-04-09 10:34  ProjectsrcentityUserInfo.java

     文件       6193  2018-04-09 13:38  ProjectWebContentadd.jsp

     文件       2599  2018-04-09 10:51  ProjectWebContentdoadd.jsp

     文件       2637  2018-04-09 10:52  ProjectWebContentdoRemove.jsp

     文件       1547  2018-04-09 10:53  ProjectWebContentdoUpdate.jsp

     文件       2290  2018-04-09 13:46  ProjectWebContentindex.jsp

     文件         39  2018-04-09 10:26  ProjectWebContentmeta-INFMANIFEST.MF

     文件       5354  2018-04-09 10:52  ProjectWebContentupdate.jsp

     文件       1558  2018-04-09 13:32  ProjectWebContentWEB-INFclassesdaoaseDao.class

     文件       4356  2018-04-11 13:44  ProjectWebContentWEB-INFclassesdaoUserInfoDao.class

     文件       1691  2018-04-09 13:32  ProjectWebContentWEB-INFclassesentityUserInfo.class

     文件     124727  2016-02-08 22:28  ProjectWebContentWEB-INFlibjasper-el.jar

     文件     601593  2016-02-08 22:28  ProjectWebContentWEB-INFlibjasper.jar

     文件      87805  2016-02-08 22:28  ProjectWebContentWEB-INFlibjsp-api.jar

     文件    1004840  2018-04-09 10:32  ProjectWebContentWEB-INFlibmysql-connector-java-5.1.46-bin.jar

     文件    1004838  2018-04-09 10:32  ProjectWebContentWEB-INFlibmysql-connector-java-5.1.46.jar

     文件     198017  2016-02-08 22:28  ProjectWebContentWEB-INFlibservlet-api.jar

     文件        650  2018-04-09 10:26  ProjectWebContentWEB-INFweb.xml

     目录          0  2018-04-09 13:32  ProjectWebContentWEB-INFclassesdao

     目录          0  2018-04-09 13:32  ProjectWebContentWEB-INFclassesentity

............此处省略17个文件信息