java向SQLserver插入数据时提示‘‘没有返回结果集‘‘

分手后的思念是犯贱 2023-01-02 13:25 83阅读 0赞

public static Connection getConnection() {
        //配置数据库信息
        	String url="jdbc:sqlserver://localhost:1433;DatabaseName=abc";//数据库地址
            String username="user01";//数据库用户名
            String password="123456";//数据库密码
            Connection conn=null;
    		if (null==conn) {
        
    			try {
        
    				//加载驱动
    				Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
    				//创建数据库链接
    				conn =DriverManager.getConnection(url,username,password);
    			} catch (Exception e) {
        
    				e.printStackTrace();
    			}
    			
    		}
    		return conn;
    	}

protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        
    		// TODO Auto-generated method stub
    		response.getWriter().append("Served at: ").append(request.getContextPath());
    		Date dNow = new Date( );
    	      SimpleDateFormat ft = new SimpleDateFormat ("yyyy-MM-dd hh:mm:ss");
    	     
    	      System.out.println("当前时间为: " + ft.format(dNow));
    	      
    	      String sql="SET NOCOUNT ON; INSERT INTO ab(a,b) VALUES('"+ft.format(dNow)+ "','00:00:00')";
    	      
    	      Connection conn=getConnection();
    	      PreparedStatement pst=null;
    	      try {
        
    			pst=conn.prepareStatement(sql);
    			 pst.executeUpdate();//这里有三个executeUpdate用于增删改executeQuery用于查询，execute通用所有增删查改
    		      pst.close();
    		      conn.close();
    		} catch (SQLException e) {
        
    			// TODO Auto-generated catch block
    			e.printStackTrace();
    		}
    	     
    	}
    	```